Posts
Sort by recent activity
Partition differences innacurate
We have a database in two different environment with a large partitioned table. The table has 5 indexes on it, 4 which are partitioned on one field, 1 which is partitioned differently. This was d...
SQL Server Base Monitoring service using excessive resources
We're having an issue where SQL monitor is continually consuming more and more memory, up to the max of 16 GB of the server. It takes about 15 minutes from start of the hosting machine to consume ...
Instance overview not reporting drive information correctly
I have several instances on a cluster and trying to monitor them through Red Gate Monitor. Each instance has a separate drive LUN assigned to them (i.e. inst 1 - M:, inst2 - N:. inst3 - O:, etc.)....
Instance not connecting
I have an instance the monitor is trying to connect to and is not making the connection. If I go under Configuration > Monitored Servers and look at the instance connection, it says "Attempting to...
Blocking spid?
I'm new to the tool and have been poking around with some of the alerts. When blocking processes occur, where can I find the blocking spid id? I can find the blocking process name, but when I hav...