Before moving forward be sure to have read this previous post that is the basis for the current post. This is the link to me GitHub diskspd project containing the relevant files discussed in these 2 blog posts mini serious. Working quiet often with diskspd it was only natural for me to automate the tiring …
If your server is stressed out on CPU I am pretty sure you would benefit using these queries to correctly identify and prioritize your course of action. The first query is the simplest as it only retrieves data from sys.sysprocesses so when a server is really stressed out on CPU and queries take long to …
This is the link to my GitHub diskspd project diskspd was designed as a storage testing tool and that basically mean test your SAN or NAS but not only SAN/NAS based disks, you can test any other disk, be it a DAS, a local drive on your server or your new laptop’s SSD (I always …
Using diskspd to test disk performance with SQL Server Read More »
SQL Server exposes missing indexes metadata via the following 3 DMVs (Dynamic Management Views) sys.dm_db_missing_index_details, sys.dm_db_missing_index_groups and sys.dm_db_missing_index_group_stats which combined in a simple query return valuable information of indexes that were detected as missing by the Optimizer and logged in those DMVs. The information in these DMVs is updated by the execution of every query …
As far as I recall the trigger to code sp_helpindex2 was that with the introduction of INCLUDE columns to indexes that was added in SQL Server 2005 the old way of viewing indexes using sp_helpindex was useless since Microsoft has not modified their procedure to support the recently added INCLUDE columns. I had therefore found myself, when tuning queries, …
