SupportSQL

Using the SQL Server Performance Dashboard reports we identify here a statement that only takes several ms to run, but is run 120,000 times a day, is improved on immensely by adding a clustered index to a table that only had 1000 records. Usually not significant for small tables, the fact that the statement was called so often created a 80% cup utilization, and then down to 40% after the small clustered index was applied.

Here the CPU is back down to acceptable production levels:

—by Alek Kirstein – SupportSQL.com