Save Money By Investing in Performance Tuning - Not More Hardware
$7,000 (money saved) = $10,000 (new hardware not needed) - $3,000 (performance tuning)

Before: High CPU Utilization Problem - CPU Near 100%


After: Low CPU Utilization - Reduced to Under 40% by TuneSQLServer Consulting
Note the vertical units max value of 40% (not 100%)



The Before and After graphs were generated by perfmon from real production data on the same weekday in 2 different weeks. The client (Travidia) supplied the graphs showing the performance improvement. Improved indexing reduces CPU utilization by reducing the amount of data scanned in tables stored in RAM, reducing hash joins and reducing the need for sorting. The trick is to identify which new indexes will provide the most bang for the buck. The tuneSQLServer.com methodology identifies high cost queries and priortizes improvements so that you get important performance improvements fast. You get improvements which benefit your daily operations after the first day of having us on the job. These improvements boost the capabilities of your system and reduce stress on your employees, managers and customers.

tuneSQLServer.com
expertSQLServer.com