All the changes for this release can be found in the Github Project page Mainly bug fixes this time around , but we have also added new functionality: Improvements #263 If you centralize your Servers' collections into a single database, you may be interested in the latest addition, we added the ability to override most... Continue Reading →
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on producing two other new modules for Perfmon data and BlitzWho data collected by the First Responder kit data collection alongside the previously released BlitzWaits custom module... Continue Reading →
As always all updates can be found on our Github repo Breaking changes (Powershell collection): We only test the powershell collection against 2-3 servers so please test carefully before rolling out changes especially if you are centralising more servers than we do. Unlike the SQL based agent collections we would recommend running the powershell collection... Continue Reading →
We have been working on a new custom module for Inspector V2, in fact this module is part of a new project where we will be producing two other new modules for Perfmon data and BlitzWho data collected by the First Responder kit data collection. It's all open source so if you have improvement ideas... Continue Reading →
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may just be for you, you can find the code on GitHub. New to the Inspector? be sure to check out the Introducing Inspector post first.We have... Continue Reading →
The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project page #68 Added a new table [Inspector].[ExecutionLog] which will hold elapsed time for each of the stored procedures executed during a collection, this table is truncated... Continue Reading →
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow advisory condition when using the Inspector default warning level (NULL), we have now updated Git with the latest revision. If you would rather not re install 1.3 again you can workaround the issue by running... Continue Reading →
Inspector V1.3 is now available on GitHub. We have updated the sample report for you to play with which includes the new informational section added in this build. We updated our getting started guide. We know some of you really hate linked servers so we have been working on a powershell collection which will allow... Continue Reading →
It has been long overdue but finally V1.2 is now available on GitHub. V1.2 brings a lot of changes, We put together a sample report for you to play with but here is an overview of what has been added. Enhancements: #9 Long running transactions module added - A new setting has been added to [Inspector].[Settings]. This setting... Continue Reading →
Pre-requisites: SQL 2012 or higher SQL Server Agent A database to store the the data collected by the agent jobs (this can be one you use for your other DBA needs it doesn’t have to be a dedicated database) Optional: For instances with availability groups where you take backups on the secondary replicas you will... Continue Reading →
SQL Undercover 