June 4, 2013 at 8:35 am
Hello all,
I have been reading about batch requests/sec as a stat for measuring performance but what I fail to find is a way to determine what is a good level of Batch requests/sec.
Can someone point out what it can be compared against or is there a general number that indicates a bottleneck?
For instance if cpu utilization is pinned at 90% it is an indicator of a bottleneck. If batch requests/sec is at 2,000 during peak is that good or bad?
June 4, 2013 at 10:18 am
It's not about what's a good batch requests/sec. It's about what's a normal batch requests/sec for your server.
If normal for your server at a particular time of day is 1000 and you check one day and see it's at 20, there's something going on (maybe it's a holiday). Likewise if normal is 1000 and one day it's 10000, there's something really odd going on.
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
June 4, 2013 at 12:05 pm
Got it. So keeping a good practice of baseline measurements is essential for this measurement to be effective at identifying anomaly's.
Thanks Gila!
June 4, 2013 at 12:20 pm
Baseline measurements are essential for any form of performance monitoring. If you don't know what normal is, how can you identify abnormal?
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply