[real example] SQL Performance Tuning Result Reporting

[real example] How to report SQL Performance Tuning Results Some customers care about SQL Performance Tuning so much, that they use our database administrators for continuous Microsoft SQL Server performance tuning. Once we tune, I noticed sometimes it was hard to communicate benefit achieved. We struggled a bit with reporting which would communicate that was

Read More »

Guide on How to Compare Performance of Two SQL Servers

(using the least known SQL Server feature – SQL Distributed Replay) Simple question we are trying to answer is – how does NEW SQL Server compare to an OLD? RED 9 BUTTON Why? Why would you want to compare two SQL Servers? We just paid $75,000 for a new server and I need to prove

Read More »

What hardware your SQL Server is bottlenecking on?

What hardware your SQL Server is bottlenecking on?   What hardware components does your SQL Server depend on the most for speed? Only 4 components that matter: CPU RAM Disk Networking   Which hardware component SQL Server bottlenecks on in 99% of cases? Disk.   I bet you $100, that your SQL Server is bottlenecking

Read More »

SQL Server Health Check – Case Study

SQL Server Health Check – Case Study   Industry vertical: National Automotive Service Client background: 2000+ employees $1 Billion+ in revenues 300 locations nationwide   Problem Summary: Client is experiencing severe issues with the Microsoft Windows Failover Clustering stability. Four node Windows Cluster goes down about two-three times per day and takes about 30 minutes

Read More »

SQL Performance improved! Wait…why cant I feel (damn) difference?!

SQL Performance tuned! Done! But wait…why cant I feel a (damn) difference?! I ran into an issue recently. After doing (an incredible!) job at tuning SQL Server Performance, I received this note from the client: “the changes are made, but we don’t feel the difference” [shortened to distill down to the point] Which…umhh… really bothers me… If I

Read More »