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 |
|
sureshot
Yak Posting Veteran
72 Posts |
 Posted - 2005-10-03 : 02:57:50
|
| I added SHOWPLAN ALL to a trace that only shows the queries that took longer than 1 second to execute. The problem is that SHOW PLAN ALL doesn't have reads so isn't being filtered and I get the plan for every query running on the system. I fear the rapid growth in disk space of the trace and the speed impact of tracing every plan. Any suggestions? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-03 : 09:56:46
|
| The BinaryData column has to be included for the trace to be displayed in profiler.-ec |
 |
|
|
sureshot
Yak Posting Veteran
72 Posts |
Posted - 2005-10-03 : 10:04:32
|
| I know. It's there. My problem is that a row is recorded for every show plan ever made instead of just the ones related to the statements with long durations so it's a ton of unneeded data being logged. |
|
|
|
|
|
|
Filtering SHOWPLAN ALL