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 V1.2 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 →

The SQL Agents’ view of SQL Server

I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one schedule one of the jobs was enabled and the other was not enabled - all pretty normal at this point but here is where it got weird. The disabled job was running on schedule regardless!... Continue Reading →

Create a website or blog at WordPress.com

Up ↑