Detect Worst Performing SQL Queries

How to use SQL Server DMO’s to gather what resources are the bottlenecks and which queries are causing those bottlenecks.

How to find out during production peak hour what are the exact queries taking most of the resources and will benefit most from fine-tuning…

Quick SQL Server Sessions Troubleshooting

I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server. For me almost every SQL Server performance troubleshooting starts with checking how sessions are doing, trying to find out which sessions are problem and needs quick fix…