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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-06-18 : 09:01:55
|
| I have implemented Performance counters on the productions DB. What is the effect of these counters on the server performance?Is there a counter for this also? How to monitor this ...?------------------------I think, therefore I am |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-18 : 09:06:52
|
| No there isn't a counter for this. There really isn't any overhead unless you've enabled other trace flags not normally on. There would be the overhead of writing them to a file, running the perfmon tool, etc. I prefer to run performance monitor from another box if I'm actually looking at it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-18 : 12:40:51
|
| Definitely run this from a client machine and not on the server being monitored. It is highly NOT recommended that you run this on the same machine that you are monitoring. When you do this, you are negatively impacting performance and also your collection of data is skewed.Tara |
|
|
|
|
|
|
Performance counters