This month's T-SQL Tuesday invitation is from Ken Fisher and he's asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into my head, an accidental discovery that I made the other day. I apologise if this is common knowledge among the PoSH guys but it was a... Continue Reading →
BlitzFileStats custom module available for Inspector V2
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on producing two other new modules for Perfmon data and BlitzWho data collected by the First Responder kit data collection alongside the previously released BlitzWaits custom module... Continue Reading →
Undercover Tools: June Updates
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 →
A Bug in ‘Move All Your SQL Database and Log Files in Bulk’
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 🙂
Move All Your SQL Database and Log Files in Bulk
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 →
T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday
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 →
Undercover Tools: February Updates and Change Log
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
SOS_SCHEDULER_YIELD – What is it really telling us?
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