January 27, 2010 at 1:57 pm
im setting up perfmon to gather a few counters, along with a server side trace that rolls over every 1GB or so.
Im unsure of what polling time i should use. If i use something like 15 mins interval i could easily miss spikes in cpu and other such activity, but if i log too often i will be logging too much data. whats a good starting point for a polling interval?
January 27, 2010 at 10:48 pm
It really depends on the performance counters being logged.
Some only need to be logged daily, and some would be better to log every minute. Sometimes those that should be logged daily might need to be logged more frequently. Other variables might be time of day. If you know that during certain times of day nobody uses the system - you don't need to log so frequently.
I would lean to the logging of the counters every minute though.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply