Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix - LocalInterrogation There was an issue with the LocalInterrogation stored proc not updating the execution log, this has now been fixed. Undercover Inspector Updates we forgot to mention from May (V2.2): Added EmailGroup column to ReportData table #216Added... Continue Reading →
It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it's all been fixed now 🙂
As always, the script from this post can also be found on our GitHub repo, HERE You've got a SQL Server with a few hundred databases on it (to be honest it doesn't even need to be quite that many) and you need to move all the data and log files to a new location.... Continue Reading →
This month's T-SQL Tuesday invitation comes from Tracy Boggiano and she's asking us to write about our experiences with Query Store. I thought about what I should write, I'm a big fan of query store and I've used it to help me out on a number of occasions recently. I could write about one of... Continue Reading →
Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags - Capture trace flags which are switched on on your SQL Servers Cluster - Capture details on any clusters that your SQL Servers sit on top of. Undercover Inspector
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 →
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 →
Quick video showing you how to install and configure the SQL Undercover Catalogue https://www.youtube.com/watch?v=SJ5YlTGkV5o
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
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 →
