|
-
Originally posted by reydp
The point that I want to made is that If all your rbs have more than 1 XACTS most of the time then this surely means that you need to add more rbs.
you must be joking?
a rbs supports more than one transaction, actually the extents inside a RBS supports more than one transaction, XACTS means active transaction going in each RBS, if I have 40 extents in a RBS I can perfectly have more than 1, 2, 3, 40, 80 or even more transactions concurrently depending on transaction size
If we base on strategy in a system with 200 concurrent transactions we would have to create 200 RBS?
If you see values > 0 in WAITS then you may consider adding more RBS but from the statistics pasted the wait is minimal
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
|