|
-
Hi,
The number of RBS for OLAP should be high and the size of RBS should be less.
For DSS, the number of RBS should be less but the size of the RBS should be large enough to hold the transaction without extends and wraps.
Better if you know that larger transaction assign them to a RBS of larger size. Set the optimal size of the RBS to 5 times greater than the size of (initial+next) extents to avoid too many shrinks.
If you need a script to detect RBS shrinks and wraps mail me,and I'll send it to you.
Best of Luck
[email protected]
I love dba job
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
|