You might want to try the free trial of Qure Optimizer, a workload tuning solution by DBSophic. I have seen quite a few cases where users didn't get what they...

There are several free tools you can use to analyze your trace files and quickly identify problematic queries. One of the popular ones is Qure Analyzer, available here:

Free SQL Server...

Thanks -- very handy.

Actually, here's a free tool I use for troubleshooting a wide range of query-related problems (by I/O, by CPU, by User, by multiple dimensions... whatever).

It's called...

Thanks for very clear overview of indexing considerations. A related topic that is sometimes overlook is the challenge of predicting the effects of an individual index on the workload as...

When it comes to trouble-shooting performance problems, there are several good free tools out there.

One free tool for analyzing trace files is Qure Analyzer by DBSophic. You can find...

There are also a few free tools out there that will help you analyze the trace file and zero-in on the problematic procedure etc.

One such tool is Qure Analyzer. A...