We have recently introduced Redgate Monitor (14.0.78) and monitor two SQL servers. While we are learning to use the messages and statistics we now run into a problem with one of the servers. The CPU disk activity is low, but the server has several waits in queue that prevent other processes from running. For now we have suspended monitoring for this server - attached a screenshot of the SQL server performance report showing the waits - what do we need to do to clear this?
We have recently introduced Redgate Monitor (14.0.78) and monitor two SQL servers. While we are learning to use the messages and statistics we now run into a problem with one of the servers. The CPU disk activity is low, but the server has several waits in queue that prevent other processes from running. For now we have suspended monitoring for this server - attached a screenshot of the SQL server performance report showing the waits - what do we need to do to clear this?
