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, 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 is the threshold in Seconds, if a transaction exceeds... Continue Reading →

Inspector V1.2 revised installation guide

  There is a new setup process for the Inspector, below we have outlined the steps required to get you started.   Grab a copy of SQLUndercoverinspectorV1.sql from GitHub Run the setup script in the context of your logging database     You have now created the Inspector schema and InspectorSetup stored procedure in your logging database,... 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 ↑