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 |
|
kshahzad
Starting Member
45 Posts |
 Posted - 2013-08-02 : 09:23:07
|
| I need to capture all the stored procedures and queries that takes more than 20 seconds to run from SQL Profiler.Please guide? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-02 : 09:51:38
|
| Apply the appropriate filters in Properties -> Event Selection tab, Column Filters. Depending on whether you are looking for CPU time or Duration, appply the filter on one or the other. |
 |
|
|
|
|
|
Capture stored procedure/queries from SQL Profiler