Comments
Sort by recent activity
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 all, Preview support for PostgreSQL on Azure Flexible Server has just been released in Redgate Monitor version 14.0.34 (release notes):
Version 14.0.34 - November 19, 2024
Features
Preview support introduced for monitoring PostgreSQL instances running on Azure Flexible Server.
Kind regards, Alex / comments
Hi all,Preview support for PostgreSQL on Azure Flexible Server has just been released in Redgate Monitor version 14.0.34 (release notes):
Version 14.0.34 - November 19, 2024
Features
Preview suppor...
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 all, Just wanted to update again, as you have likely noticed it is no longer Q3 and the "PostgreSQL on Azure flexible server" is not out yet. This is still being worked on should be out this quarter (Q4 2024) barring any other delays or complications. I will update again when there is a release available or I get more information from the team. Kind regards, Alex / comments
Hi all,Just wanted to update again, as you have likely noticed it is no longer Q3 and the "PostgreSQL on Azure flexible server" is not out yet. This is still being worked on should be out this qua...
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 all, Edit: apologies completely missed a bit of your comment "PostgreSQL on Azure flexible server" is currently being worked on and looks like it should be available this quarter (Q3). I'll update here when I have any further information on this. Regarding "Cosmos DB for Postgresql" this is not currently planned I'm afraid. Kind regards, Alex / comments
Hi all,Edit: apologies completely missed a bit of your comment"PostgreSQL on Azure flexible server" is currently being worked on and looks like it should be available this quarter (Q3). I'll updat...