why is the time difference between metric data not consistent
abhishek813
Posts: 4 New member
I am trying to collect the metrics captured by SM. I am using the /Analysis/Graphs/GraphDataMultiple and /Analysis/Graphs/ExportCsv API to get the metrics. I have the 7.0.7.7367 version of SM running on IIS 7.5 and NET 4.6.1. The time difference between the entries is not consistent. It is consistent on SM version 6.0.10.5815 running on IIS 8.5 and NET 4.5.2.
When i say consistent i mean, the difference between the timestamps is not the same, say 15 seconds or 30 seconds.
Is there a configuration that i can change to make this work?
When i say consistent i mean, the difference between the timestamps is not the same, say 15 seconds or 30 seconds.
Is there a configuration that i can change to make this work?
Answers
Some of the metrics that are collected have the same interval but others are collected at various different intervals ranging from 15s to the fragmented index which happens once a week depending on the resource intensity of the collection and the stability of the metric. Most are around 15s but some are 1 or 5 minutes or more.
You can see what the defaults for the different collections are by using the included Configuration File editor.
First, locate the configuration file on the machine where the SQL Monitor Base Monitor service is hosted. Location: C:\ProgramData\Red Gate\SQL Monitor
File Name: RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config
Make a copy of this file and name it something useful like RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config_backup
This will act as a backup of the configuration file so that your changes can be reversed.
Next, run the SQL Monitor Configuration Editor as an administrator (right click > Run As):
C:\Program Files\Red Gate\SQL Monitor\BaseMonitor\Tools\ConfigurationFileEditor.exe
You will be prompted to "Load a configuration file". Find the .config file detailed in step 1.
You will be presented with a list of all the configuration options available. These relate to each item in the polling schedule. Any check box which is un-checked automatically uses the default - to check what the default is you can check the box, but not make any changes and the value shown will be the default value.
If you make any changes, once complete, click "Save Changes" and restart the SQL Monitor Base Monitor service. If you have any unexpected results then please delete your edited configuration file and rename the copy (then also restart the service). If you are not making changes, just close without saving.
I hope that helps clarify things and how to check the default values!
Kind regards,
Alex
Have you visited our Help Center?
As you can see the entries are not at a fixed interval apart. This is what i was talking about. How do i make sure that these entries are at a fixed interval apart.
-Abhishek
I do think the SQL Server Processor Time metrics relates to "[Cluster].[SqlServer].[Process] - SQL Server Windows service statistics" however the image you have shown there is the export from Machine:Processor time for a machine called "SQL Server".
Regardless of that - I think part of the issue you are seeing with the export values could be related to the graph only showing 500 data points - so there is aggregation of values when you zoom out to a certain point (i.e. samples every 15 seconds fill 500 data points in 2 hours and 5 minutes) - do you have it set to something like 1 hr or more than this? If you try to set it to 1hr or 15 minutes do you see the timings correctly?
Though having said that, it looks like of the intervals are 7 seconds and some are 20+ another thing to consider is if there are any collection errors or delays in actually sampling the values; the schedule may be to try it every 1 minute (or 15 seconds) but the actual collection could take longer than expected and cause the time to vary.
Kind regards,
Alex
Have you visited our Help Center?