Post reply

SQL Lock Requests/Min

  • April 21, 2011 at 7:25 am

    #145258

    Hi,

    Is there a threshold value for Lock Requests/Min?

    Also, what should be the ideal number of Lock Requests/Min?

    Thanks,

    Vinod

  • April 22, 2011 at 5:23 am

    #1314839

    I'm not sure that I'd worry too much about that. I'd focus on Lock Timeouts/sec and Lock Wait Time. Those are better indications of issues with locking than simply getting counts of the number of locks.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply