limit/restrict default monitoring area
iberserk
Posts: 2
Hello,
A simple question, maybe i'm just a bullet but i cannot choose/limit the counters/montoring area.
I explain: i want to limit the performance impact of SQLMONITOR on my production server.
I have a lot of database on it and some unwanted monitoring are taking 10 seconds of cpu time each minute...
Is it possible to deactivate some default counters or top queries stats etc?
Best regards
A simple question, maybe i'm just a bullet but i cannot choose/limit the counters/montoring area.
I explain: i want to limit the performance impact of SQLMONITOR on my production server.
I have a lot of database on it and some unwanted monitoring are taking 10 seconds of cpu time each minute...
Is it possible to deactivate some default counters or top queries stats etc?
Best regards
Comments
There isn't a standard way to disable / reduce frequency of data collections. Can you provide some more details on the production server (how many databases is a lot, spec etc) and which collections seem to be causing the issue? If you prefer to respond to the support ticket that was opened for you in case of sensitive data that works as well.
Kind regards,
Alex
Have you visited our Help Center?