Daily Archives: October 21, 2019

Creating test data using TSQL- 4 weeks of CPU stats

To Spoof the creation of SQL creating the CPU stats for the last 4 weeks I used some useful SQL routines, the full code is linked here but the relevant sections are explained in the blog post. These are a … Continue reading

Posted in DataScotland, Tips & Tricks, TSQL | Leave a comment

Monitoring CPU

As part of a licensing project, it was found to be very useful to get an overview of current servers CPU across the SQL estate. There was an expensive 3rd party software solution that was reporting high CPU usage on … Continue reading

Posted in Management Studio, Performance Tuning | Tagged , , , , | Leave a comment