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 |
|
Wang
Starting Member
48 Posts |
 Posted - 2006-08-18 : 07:42:35
|
| Hi allI am looking at setting up a black box trace on our production server.I just wanted to check and make sure no one has heard of this having any adverse effect on systems - in particular Clustered sql servers?Cheers |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-18 : 08:37:25
|
| Well, if you are talking about profiler tracing, it does have a performance impact on the server. It would be best to trace only what you need, and to write it to a SQL table on another box - as I recall, that was the suggested method for reducing impact on the box being monitored.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
Wang
Starting Member
48 Posts |
Posted - 2006-08-18 : 10:32:15
|
| Thanks, thats normal, but I want to set up the BlackBox trace. I am just worried about a few rumours I have heard with it damaging clustering. I suspect these are not justified, I wanted to check here. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-08-18 : 12:21:52
|
| Well, I haven't done it on a cluster per se - I did deploy some automated trace create SP's I wrote to a clustered environment that was managed by the production dba's, and they ran w/o problems. But that's by no means 'the last word' on the topic... hopefully someone with more real world clustering experince will be able to comment*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
Black Box tracing