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 |
|
abc123
Starting Member
47 Posts |
 Posted - 2008-07-17 : 00:41:53
|
| hi, I am new to SQL server. Consider I have 6/7 application and one application is very slow.how I can find out which application is slow and why?Also how I can find out which query is running slow? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
abc123
Starting Member
47 Posts |
Posted - 2008-07-17 : 00:47:32
|
| have any command or system procedure which i can use ? |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-17 : 01:33:06
|
| Try and trap what you define as a slow running query (or maybe a fast running query that repeats often) analyse the execution plan .Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
query perfomance