D
Dmitri Levin
Guest
For smaller (<10 GB) databases everything goes. 
Make it all variable. For more serious consideration let's consider AI and BI separate. The fixed size BI guaranties that you have the space already allocated. There is nothing wrong with having variable BI as long as you are 200% sure you will not run out of space on the file system. And the best bet for that is 1) have BI on a file system separate of everything else 2) to have much more space then you need. Like if your average BI is size X. Have 10 * X available. 3) Monitor BI area size and growth with alerts if it is unusually big. I would have AI always variable. Same space requirements here. You should have space for disaster, meaning probably enough for one week of AI growth. I assume some kind of database replication in place.
Continue reading...
Make it all variable. For more serious consideration let's consider AI and BI separate. The fixed size BI guaranties that you have the space already allocated. There is nothing wrong with having variable BI as long as you are 200% sure you will not run out of space on the file system. And the best bet for that is 1) have BI on a file system separate of everything else 2) to have much more space then you need. Like if your average BI is size X. Have 10 * X available. 3) Monitor BI area size and growth with alerts if it is unusually big. I would have AI always variable. Same space requirements here. You should have space for disaster, meaning probably enough for one week of AI growth. I assume some kind of database replication in place.Continue reading...