Red Gate forums :: View topic - Editing Collection Schedules in Config File
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Editing Collection Schedules in Config File

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
thejrdba



Joined: 10 Jan 2012
Posts: 1
Location: Portland, OR

PostPosted: Wed Jan 11, 2012 12:45 am    Post subject: Editing Collection Schedules in Config File Reply with quote

Does anyone have any experience with editing the data collection schedules within the SQL Monitor base monitor service config file (C:\ProgramData\Red Gate\SQL Monitor 2\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config)? I am monitoring five production servers, and my repository DB grows by 1 or 2 GB per day. We cannot support this growth without purging the data very frequently, which obviously makes trending and analysis difficult because there is never any historical data available.

It looks like I am able to add my own <schedule> elements to the config in order to override the default 15-second collection frequency, but I have no idea how the qualifiedChannelName attribute works. The four qualifiedChannelNames that are commented out in the config are:
[Cluster].[Machine].[Process],
[Cluster].[SqlServer].[Database],
[Cluster].[SqlServer].[Database].[Table],
[Cluster].[SqlServer].[Database].[Table].[Index]

One could guess at which counters and data points these correspond to, and test them with trial and error, but I'd like to know if there is any documentation available. For example, I want to collect perfmon counters like CPU Utilization every 15 min, not every 15 sec. To accomplish this, I added a new schedule to the config for the [Cluster].[Machine].[Process] "channel name," and restarted the base monitor service. This seemed to affect the "top 10 system processes" section of the server overview page, but not the PerfMon counters, so I decided to add another schedule with a channel name of "[Cluster].[Machine]". This second schedule had no effect on anything - the counters were still being collected every 15 sec.

Is there a list somewhere of the available "qualified channel names"? And if I were to get ahold of said list, might it also tell me which data points and counters each channel name corresponds to, so I may customize my data collection and save space?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed Jan 11, 2012 6:26 pm    Post subject: Reply with quote

Hi,

We do not have this information available because any change in config may have adverse effect on alert and other data being shown on UI. However, I am emailing you some more information. Let me know if you have not received my email in next 1/2 hour.

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group