Do we have any pre defined queries from Microsoft which gives the idea to check SQL Performance. My application is running slow now days and wanted to check if any queries/functions/data/indexes creating these problems.
Here's where I would start: 1. Blocking 2. PerfMon - any hardware bottlenecks 3. Profiler/Server side trace - identify long running queries, high reads, high CPU 4. Wait stats 5. Missing indexes 6. Code refactoring and fine tuning index based on #3