Comments
Sort by recent activity
We've raised MP-2662 internally to track this. Unfortunately we can't provide any ETAs, our current focus is net 5, but its been added to the list. / comments
We've raised MP-2662 internally to track this. Unfortunately we can't provide any ETAs, our current focus is net 5, but its been added to the list.
If you rename the %programdata%\Red Gate\SQL Monitor folder and then rerun the installation it should work. I'm not sure what is causing this yet I'm afraid, but I've seen it a few times. / comments
If you rename the %programdata%\Red Gate\SQL Monitor folder and then rerun the installation it should work. I'm not sure what is causing this yet I'm afraid, but I've seen it a few times.
You can't change the email that comes out I'm afraid, but you can create a Report tile on a custom metric, which is what I'd suggest in this case. / comments
You can't change the email that comes out I'm afraid, but you can create a Report tile on a custom metric, which is what I'd suggest in this case.
Logging does indeed seem to not be working at the moment, bear with me I am looking into it. / comments
Logging does indeed seem to not be working at the moment, bear with me I am looking into it.
Under normal circumstances you would install sql monitor on a standalone machine (this machine can run in the cloud but it would have to be a VM), and then you add the server you want to monitor to it. Installing a monitoring service on the same machine you want to monitor isn't a great idea, because as you've mentioned if that server goes down you're in trouble. You can run SQL Monitor in HA if that allays any fears: https://documentation.red-gate.com/sm/installation-and-setup/installing-sql-monitor-with-high-availability, but ultimately you would do the above. A standalone install (can be virtually anywhere) monitoring the server you care about. / comments
Under normal circumstances you would install sql monitor on a standalone machine (this machine can run in the cloud but it would have to be a VM), and then you add the server you want to monitor to...
You're welcome, if you do have any other questions just get in touch! / comments
You're welcome, if you do have any other questions just get in touch!
Could you just clarify what you mean please? Do you mean as an application as a service, for example? Or that you want to monitor a single server, but not install it on that server? / comments
Could you just clarify what you mean please? Do you mean as an application as a service, for example? Or that you want to monitor a single server, but not install it on that server?
Hi, Unfortunately, this is a case of the query causing the deadlock, and it's not something we can fix. Reading table metadata requires taking out a schema stability lock (Sch-S) so that you can't drop a table while its metadata is being read. Whereas dropping a temporary object (either explicitly or at the end of a query running) requires a schema modification lock (Sch-M); thus these two locking modes aren't compatible: (https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver15#lock_compatibility), which leads to deadlock since someone has to give. It's one of those things that's necessary for SQL Server to maintain internal consistency. We are working on lowering deadlock priority of Monitor queries, but there are downsides to doing this - such as decreased accuracy of monitoring which can lead to gaps on graphs - but we haven't finalised this at all yet. / comments
Hi,Unfortunately, this is a case of the query causing the deadlock, and it's not something we can fix.Reading table metadata requires taking out a schema stability lock (Sch-S) so that you can't dr...
Yes that makes sense then. This looks like its SRP-12937, which was fixed in 10.0.9. Are you able to upgrade? I can provide a link to that exact version if you specifically want it, otherwise you should be able to get the latest release here https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_10.2.3.31956.exe (this requires server 2012 R2 or higher though). / comments
Yes that makes sense then. This looks like its SRP-12937, which was fixed in 10.0.9. Are you able to upgrade? I can provide a link to that exact version if you specifically want it, otherwise you s...
Hi Nath, can you confirm the version of Monitor you're running please? This looks like an old bug we fixed a while ago. / comments
Hi Nath, can you confirm the version of Monitor you're running please? This looks like an old bug we fixed a while ago.