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 |
|
prasanth_sqlbeginner
Starting Member
3 Posts |
 Posted - 2012-06-07 : 13:34:57
|
| Without using SQL Profiler is there any other way to identify all Stored Procs which are taking more than 2 secs to execute? Will any of the DMVs be of help here?RegardsPrasanth |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-06-07 : 18:36:29
|
| I don't think there's a way to do this without running a trace or sql profiler, neither of which I am proficient enough to help you further. Perhaps you can ask your question in the administration forum and get an answer to your question.JimEveryday I learn something that somebody else already knew |
 |
|
|
prasanth_sqlbeginner
Starting Member
3 Posts |
Posted - 2012-06-07 : 21:37:22
|
| Thanks Jim. |
|
|
|
|
|
|
List all Stored Procs which are taking >=2 secs