How can we help you today? How can we help you today?

Excessive Waits created on Redgate Monitor

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?
image

kherrmann
0

Comments

1 comment

Sort by
  • Alex Bartley
    Official comment

    Hi kherrmann ,

    The query shown is the SQL Database Sampler which runs every 15 seconds.
     
    Based on https://www.sqlskills.com/help/waits/preemptive_os_lookupaccountsid/ it looks like the wait is likely occurring due to the SUSER_SNAME(db.owner_sid) [owner] which is associated with the PREEMPTIVE_OS_LOOKUPACCOUNTSID wait.  It seems this can be related to performance issues with the DC's or potentially round trip time to the servers.

    Kind regards,

    Alex

    Alex Bartley

Add comment

Please sign in to leave a comment.