R
Rob Fitzpatrick
Guest
There could be advantages to using fixed-size AI extents in a database with very high transaction volume, owing to avoiding extend operations. With sizes less than 10 GB, I wouldn't worry about that at all. With BI I tend to create two extents: one fixed extent that is 4x the largest cluster size I intend to use, and one variable. With DBs this size, keeping things variable will minimize administration work from managing extents. Also, use the AIMD to manage AI archiving. I wouldn't expect users to see any noticeable performance impacts. I assume, with new servers, that you will have decent hardware. I always use 8 KB DB block size, in all OSes. Touch wood, I've never had a problem with doing that.
Continue reading...
Continue reading...