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 |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2003-05-05 : 04:03:44
|
| Hello,Can anyone pls. tell me what paramaters are to be used in Profiler/Perf. Monitor to trace a query which takes a long time to execute and also takes up a lot of cpu space. Regards |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-05 : 11:05:40
|
| Do you know which query takes a long time?If not then you can use Stored procedure rpc completedtsql sql batch completedput in a filter for duration to get long running ones.This will give you the queries that are causing problems.Now put them in query analyser and loko at the expected execution plan. If you need the actual plan and they do updates run on a test system or in a transaction.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Tracing long running queries