Activity overview
Latest activity by Alex B
Hi @DonFerguson, The team have managed to get a fix for this into the release that's just gone out 14.0.45 which you can download here: https://download.red-gate.com/checkforupdates/RedgateMonitorWebService/RedgateMonitorWebService_14.0.45.7193.exe Kind regards, Alex / comments
Hi @DonFerguson,The team have managed to get a fix for this into the release that's just gone out 14.0.45 which you can download here: https://download.red-gate.com/checkforupdates/RedgateMonitorWe...
Hi @mOhAmAdreZa0011, Redgate Monitor collects this query from the WMI performance counter class Win32_PerfRawData_PerfProc_Process, looking at the various SQL Server processes and getting the PercentProcessorTime property for that specific metric. The counter is a cumulative counter, and so the presented data is calculated from the sampled data by dx(PercentProcessorTime)/dt(SampleTime). The sample is stored in the repository as a point in time value of the cumulative counter with the sample time in ticks. It's a more complicated query than WMI can handle, I think, to get the value that is displayed, so you would need to do something like: SELECT PercentProcessorTime FROM Win32_PerfRawData_PerfProc_Process WHERE Name = 'sqlservr'And then run it again 15 seconds later and then calculate taking the difference of (second sample - first sample) / (second sample time - first sample time). And/or you can look at the equivalent perfmon counter and at the value every 15 seconds from when the Base Monitor service started to see if it matches up. Kind regards, Alex / comments
Hi @mOhAmAdreZa0011,Redgate Monitor collects this query from the WMI performance counter class Win32_PerfRawData_PerfProc_Process, looking at the various SQL Server processes and getting the Percen...
I'll feed it back to the team! / comments
I'll feed it back to the team!
Exactly what @ThomasBE said, when you install RGM, it is effectively a re-install of the product, so it will change the startup from Automatic (Delayed) to Automatic. / comments
Exactly what @ThomasBE said, when you install RGM, it is effectively a re-install of the product, so it will change the startup from Automatic (Delayed) to Automatic.
Hi Ben, That makes sense, please do make a suggestion on the Uservoice page for it! Kind regards, Alex / comments
Hi Ben,That makes sense, please do make a suggestion on the Uservoice page for it!Kind regards,Alex
Hi @BWar81, There is not a way to restrict the time frame for the "Backups" page I'm afraid, it contains all the history of the backups. For the SQL Agent Jobs page, you can restrict it to show the last day, week or month of data. For the "Disk usage", "SQL Server Configuration", "Installed versions" and "SQL Server licensing" pages, the intended use of those pages doesn't require a time frame to be selectable:
For the "Disk usage" page, it is showing currently values of free and used disk space, along with the current projects based on the historical data.
For the "SQL Server Configuration" page, it is showing the current configuration.
For the "SQL Server versions" page, it is showing the current versions of the entities.
For the "SQL Server licensing" page, it is showing the current licensing information.
If you have a specific use-case for being able to filter some or all of these differently, please raise a suggestion on the Redgate Monitor Uservoice page: https://sqlmonitor.uservoice.com/forums/91743-suggestions/filters/top Kind regards, Alex / comments
Hi @BWar81,There is not a way to restrict the time frame for the "Backups" page I'm afraid, it contains all the history of the backups.For the SQL Agent Jobs page, you can restrict it to show the l...
Hi @mdspain, This is a Windows environment variable, which can be set in a couple of ways. You can either run this on Base Monitor server from an elevated cmd prompt [System.Environment]::SetEnvironmentVariable('SQLMONITOR_ScriptAlertResponse','1', 'Machine') Or do it using the UI via Start > Run > "Edit the system environment variables" > Click Environment variables button near bottom right > set it in the System Environment variables section: [image] [image] [image] Kind regards, Alex / comments
Hi @mdspain,This is a Windows environment variable, which can be set in a couple of ways.You can either run this on Base Monitor server from an elevated cmd prompt[System.Environment]::SetEnvironme...
Hi @davidwatson, I can see from your internal ticket you're going to rework your query to try and get it in under the 5 minute timeout. Speaking to the team, since all of the custom metrics are run in a transaction, it seems this is the reason we have hard-coded a timeout, to avoid problems with very long running transactions in custom metrics impacting the target entities. The team may revisit this in the future, but for now it is going to be left as is. Kind regards, Alex / comments
Hi @davidwatson,I can see from your internal ticket you're going to rework your query to try and get it in under the 5 minute timeout.Speaking to the team, since all of the custom metrics are run i...
Hi @davidwatson, Ah, righto, I've dug a bit deeper into the code and it is actually using a hard coded value specifically for custom metrics. I'm checking with the dev team if there is a specific reason for this. Kind regards, Alex / comments
Hi @davidwatson,Ah, righto, I've dug a bit deeper into the code and it is actually using a hard coded value specifically for custom metrics. I'm checking with the dev team if there is a specific r...
Hi @davidwatson, In Redgate Monitor you can configure the connection and execution timeouts from the Configuration > Monitored servers page, by clicking on the three dots menu at the right of the row for the SQL Server instance in question [image] then choosing "Edit credentials" [image] and on the modal window that appears, choosing "Edit properties" [image] and on that modal, setting the option for Execution timeout as needed [image] However, as the above are the defaults (which mean don't timeout), it's likely the "Remote query timeout" from SQL Server itself is causing the problem, which you can find from SSMS by right-clicking on the instance and choosing properties at the bottom:[image] Then choosing "Connections" from the left sidebar [image] Kind regards, Alex / comments
Hi @davidwatson,In Redgate Monitor you can configure the connection and execution timeouts from the Configuration > Monitored servers page, by clicking on the three dots menu at the right of the ro...