Post reply

number of queries served

  • September 8, 2010 at 11:13 am

    #142680

    Is there a way to find out how many queries does a specific sql server instance serves in a day? month ? etc

  • September 9, 2010 at 3:58 am

    #1218466

    I'm not sure, check it custom reports in sqlserver 2005 and above version

    Thanks & Regards

    Balaji.G

  • September 9, 2010 at 4:45 am

    #1218486

    You can run a trace for a period of time and count up the queries. You can save perfmon counters, specifically the Batch_requests per second I think would be a good one.

    It's not something that SQL tracks and saves, so you won't be able to get historical data without something already running.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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