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 |
|
nathans
Aged Yak Warrior
938 Posts |
 Posted - 2005-07-07 : 10:35:26
|
| Guys,While troubleshooting a query timeout in production I ran a profiler trace (from client machine) to capture the db activity for review. Ive done this many times in the past without any impact on production servers, though this time (coincidentally, I think) performance was greatly impacted and subsequentlly caused ~1 hour downtime, which I now need to answer for.I was tracing a specific db_name and nt_login... and ~6 events, for less than 3 minutes. What is the impact of running profiler in prod environment? Is this bad practice? Are there specific measures that you take to minimize performance degradation? How can I research the profiler engine to show that the trace did not cause the downtime? Thanks for any input!Nathan Skerl |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-07 : 11:50:00
|
| I typically will run it on my local machine and the write the results to their as well to reduce the impact of profiler on the production box. There is an impact and it is typically seen when you are monitoring too much stuff.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-07 : 13:11:52
|
| I seriously doubt that your trace caused the performance problem as you ran for it very short amount of time and traced only specific events and it was filtered. There really is no way to prove it though.Tara |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-07-07 : 17:46:43
|
quote:
Originally posted by tdugganThere really is no way to prove it though.
A serious doubt from the Goddess is good enough for me.  Nathan Skerl |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-07-07 : 23:14:16
|
| We run traces on all of our production servers constantly without any impact to the servers. We DO NOT open up Profiler on them. I've never seen any issues with this, and it's been a practice for several years. In some cases, the traces were running on server well over the capactity they should have been at.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Profiler in PROD environment