Post reply

What is your total query processing time per day?

  • December 16, 2011 at 8:06 am

    #264879

    Hello, just wanted to gauge my sql instance query processing time against others here in the forum. The database is about 200GB in size, running on a server with 24 CPU and 64GB of RAM. Our average transactions per second during business hours is about 2000. Total processing time is between 6 and 7 hours per day. Can anyone post replies with their processing time?

  • December 16, 2011 at 8:28 am

    #1422554

    Thats around my average per second value.

    Avg: approx 2000 tps

    Peak: approx 12000 tps

    Peak time is normally mid to late afternoon and low time is very early morning.

  • December 16, 2011 at 8:28 am

    #1422555

    Forgot. Biggest DB is 4TB and an average DB size is around 300GB

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

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