none
Performance counter to show Selects per second

    Question

  • anyone know of a sql server performance counter to show the number of select statements being run per second?  I found the transaction writes per second counter, but a selects/sec would be great too!
    Tuesday, October 19, 2010 7:10 PM

Answers

  • Hello,

    To my knowledge, that performance counter does not exists.

    Batch/requests per second may give you an idea, but a batch could mean updates, deletes, inserts also.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, October 20, 2010 1:57 AM
    Moderator