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 |
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-10-01 : 10:32:30
|
Hi,I wanna run the trace sample: Find the Worst Performing Queries in Profiler , butr I can't find it? where is it pls?I only see : Duration template..etc but not: Find the Worst Performing Queries template |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-01 : 10:33:49
|
"Worst Performing Query" according to what?1) Locks?2) CPU or DURATION?3) READS? E 12°55'05.25"N 56°04'39.16" |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-10-01 : 10:37:50
|
I guess it's duration, since I am looking for long runing queries. Thanks Peso. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 11:24:32
|
If you've got the Duration template that's the one to use, or am I missing something? |
|
|
vivekgupta85
Starting Member
2 Posts |
Posted - 2012-12-24 : 07:19:49
|
Hi All,I have to find worst queries that are taking too much time in sql server 2000.I have take the help of Sql profiler and I found some queries related to aspx page.My boss wants this should be in sql format. How can i find out.Please help me.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-24 : 11:48:09
|
quote: Originally posted by vivekgupta85 Hi All,I have to find worst queries that are taking too much time in sql server 2000.I have take the help of Sql profiler and I found some queries related to aspx page.My boss wants this should be in sql format. How can i find out.Please help me.Thanks
Duplicate:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=2275 |
|
|
|
|
|