I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines of "but David, I'm seeing SOS_SCHEDULER_YIELD, we must have CPU issues". Yes this particular customer had been CPU bound recently but was that really their problem... Continue Reading →
SQL Undercover TV – Instant File Initialisation
Adrian has a look at the performance benefits of instant file initialisation https://www.youtube.com/watch?v=b6NE-ipzLbQ&feature=youtu.be Below is Ade's auto growth script... DECLARE @trcfilename VARCHAR(1000) ; SELECT @trcfilename = path FROM sys.traces WHERE is_default = 1 SELECT StartTime , DB_NAME(DatabaseID) AS DatabaseName , FileName, SUM(( IntegerData * 8 ) / 1024) AS [Growth (MB)] , ( Duration /... Continue Reading →
Installing and Configuring the Undercover Catalogue
Quick video showing you how to install and configure the SQL Undercover Catalogue https://www.youtube.com/watch?v=SJ5YlTGkV5o
Undercover TV – Table Variable Deferred Compilation
David takes a look at a new feature of SQL 2019, table variable deferred compilation https://www.youtube.com/watch?v=pscQwLwYe10&feature=youtu.be
Undercover Tools: January Updates and Change Log
Below is the January list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.0Major upgrade, see https://sqlundercover.com/2020/01/06/undercover-catalogue-0-4-0-released/ for full details Update 0.4.1ServerConfig module added, detailing settings exposed in sp_configure settings Services module fix, adds compatibility with older service packs of SQL2012 and 2014 Addition of an upgrade history table Undercover Inspector Update... Continue Reading →
Inspector 2.1 now available
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 →