-
Figuring out peak TPS rates
What is a good way to go about calculating "peak" transactions per second hitting a database?
Yes, a statspack report gives you that information. But it is averaged out over the time period (15 minute or whatever) of the snapshot ids. Obviously this number could be significantly skewed. Say you have 100 transactions hitting the database over 1 minute, and 0 over the next 14 minutes - statspack will report TPS as 100 / (15x60)..which is significantly lower than the number that I'm looking for - peak = 100 / (1x60).
Running statspack snapshots at 1 minute intervals doesn't seem practical either.
Not sure how to go about this..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|