Inspector V2.00 now available

The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The latest powerBI template can be found here.As more features are documented they will be updated on the Inspector V2 page. New Features Schedule report windows and... Continue Reading →

Inspector V1.4 now available

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 →

Inspector V1.2 now available

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 →

Inspector revised installation guide

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 →

Create a website or blog at WordPress.com

Up ↑