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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Capture stored procedure/queries from SQL Profiler

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.
Go to Top of Page
   

- Advertisement -