Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-26 : 03:05:27
|
| Hi iam having three trace files out of which each one is having lakhs of select statements.on what basis i can figure out these either cpu,duration or reads.is there any way to sort cpu directly from tool |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-30 : 14:06:40
|
| Maybe you can use the ReadTrace tool. One of the reports show the most resource-consuming query types by CPU, Duration, Reads, and Writes based on trace files that you specify as an input. Search the Microsoft site for "RML Utilities for SQL Server" to download. |
 |
|
|
|
|
|
sql server trace file