User profile for Alex B

Hi all, We have seen this issue before where the MSCluster namespace is present on a standalone server. Please perform the WBEMtest described on this page under Testing WMI connections manually > "Testing a WMI Connection using WBMETest" but in step 5 connect to the \\YourServerName\root namespace and in step 7 use this query: </code><pre class="CodeBlock"><code><code>SELECT Name FROM __Namespace See if MSCluster is returned in the list of namespaces. If MSCluster is returned and the entity is NOT a cluster (as seems to be the case) then it will need to be removed and I will provide directions to do so. As for why when you have added the server there is not a card on the dashboard, it is because there is a problem discovering the SQL Server entities and there is only a card on the global dashboard for each SQL instance. Kind regards, Alex / comments

Hi all,We have seen this issue before where the MSCluster namespace is present on a standalone server.Please perform the WBEMtest described on this page under Testing WMI connections manually > "Te...

0 votes

Hi @Jlew, If table B and C each have different columns that are in table A, then you should be able to make a view in db2 with the columns from them that you can then compare with table A. However if B and C are both the same and the same as A then you would need to have two separate projects A->B and A->C. Kind regards, Alex / comments

Hi @Jlew,If table B and C each have different columns that are in table A, then you should be able to make a view in db2 with the columns from them that you can then compare with table A. However i...

0 votes

Hi @..., The SSH key auth was added in SQL Monitor 13.0.11 (release notes), so you'll need to update one more [image] You can get 13.0.11 here: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_13.0.11.15736.exe Kind regards, Alex / comments

Hi @...,The SSH key auth was added in SQL Monitor 13.0.11 (release notes), so you'll need to update one more You can get 13.0.11 here: https://download.red-gate.com/checkforupdates/SQLMonitorWeb/S...

0 votes

Hi Paul, Currently you will need to create a separate summary tile for each entity separately or "Everything" as you have stated. These tiles can all be on the same report though (i.e. if there are 5 entities in a group, you would create a "Summary tile > Job failures" report tile for each of those 5 entities on the same overall Report). I would suggest raising a suggestion on the SQL Monitor Uservoice forum here: https://sqlmonitor.uservoice.com/forums/91743-suggestions/filters/top Kind regards, Alex / comments

Hi Paul,Currently you will need to create a separate summary tile for each entity separately or "Everything" as you have stated. These tiles can all be on the same report though (i.e. if there are...

0 votes

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...

0 votes

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...

0 votes

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...

0 votes

Hi @..., Yes, unfortunately that is the case currently - Postgres on Windows is not currently supported. I have fed this back to the team and they are keeping track of different types of Postgres in order to inform future work, though I'm not sure where Postgres on Windows sits there - I only know Aurora is high on the list planned for sometime in Q3. Kind regards, Alex / comments

Hi @...,Yes, unfortunately that is the case currently - Postgres on Windows is not currently supported.I have fed this back to the team and they are keeping track of different types of Postgres in ...

0 votes

Hi @TiborKaraszi, Thank you for raising that- I have internally mentioned this forum post in relation to that request now. Kind regards, Alex / comments

Hi @TiborKaraszi,Thank you for raising that- I have internally mentioned this forum post in relation to that request now.Kind regards,Alex

0 votes

Hi @scubakuba and @TiborKaraszi The traceflag 1222 is for the older Deadlock sampler which is not used by default now, the newer iteration (Deadlock (extended events)) uses extended events. The steps to disable samplers are as follows using the ConfigurationFileEditor.exe: Navigate to C:\Program Files\Red Gate\SQL Monitor\BaseMonitor\Tools (by default, or wherever you have installed it) and start the ConfigurationFileEditor.exe as an administrator (right click > run as administrator). When it starts click on "Load configuration file" button in the middle, choose the RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config file and click open. Then on the screen that appears, scroll down to the appropriate entry click the dropdown box that says Interval and choose Disabled e.g. here for the DeadlockTraceFlag sampler (you can disable this one and I believe it will prevent SQL Monitor from enabling the trace flag):[image] For the SQL Process sampler it is [Cluster].[SqlServer].[SqlProcess] For the Top Queries sampler it is [Cluster].[SqlServer].[TopQueries] For the Deadlock (extended event) sampler it is [Cluster].[SqlServer].[ExtendedEvents] Then click the Disk icon at the top right to save the configuration change And lastly restart the SQL Monitor Base Monitor service. This will disable the samplers you have chosen to disable. To note, this will remove a large portion of functionality from SQL Monitor as the Top X queries section (Top queries sampler) on the server overview will no longer have data nor will there be SQL User process data or long running queries or blocking process alerts (SQL Process sampler), or deadlock alerts (Deadlock XE sampler). For your request about anonymizing clear text data @tibor@TiborKaraszi please raise a suggestion on the SQL Monitor Uservoice forum https://sqlmonitor.uservoice.com/forums/91743-suggestions/filters/top Kind regards, Alex / comments

Hi @scubakuba and @TiborKaraszi The traceflag 1222 is for the older Deadlock sampler which is not used by default now, the newer iteration (Deadlock (extended events)) uses extended events.The step...

0 votes

How can we help you today?

Alex B

Comments