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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2014-02-05 : 16:14:44
|
| I'm building a profiler trace (2008 R2) to hopefully trap some blocking by tracing the Blocked Process Report event.If I filter on Duration > 5,000,000 is that 5 seconds?I want to trap sql statements running longer than 5 secs.Thanks,Jack |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-05 : 16:36:21
|
| From Profiler, duration is in milliseconds. From a server-side trace or when reading the raw Profiler data (not in the GUI), duration is in microseconds. For 5 seconds, you would specify 5000 for duration in Profiler.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2014-02-05 : 16:57:57
|
| Thanks, Tara. Well, that would explain why I'm not trapping anything! Will change it to 5000 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Profiler Trace - Setting Duration Filter
Tara Kizer