[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
Guide on How to Compare Performance of Two SQL Servers – Part2
Part 2 – Guide on How to Compare Performance of Two SQL Servers (and the end result we want out of DReplay testing) In Part1, I talked about: Why would you compare performance of two SQL Servers. And end result that we want to get by doing this comparison. In big picture, here
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
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
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
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
