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 |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2010-04-12 : 15:07:43
|
| How much of a performance hit would running SQL Profiler on a Production Database be? What if you are only capturing events that happen infrequently (like once a second)? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-04-12 : 16:33:45
|
| It does consume quite a bit of CPU. You should run server side traces instead of profiler on production..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2010-04-14 : 10:53:19
|
| Thank you. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Profiler slowing down Server
Tara Kizer