Kbase P78661: Should BI and AI on their own disk
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/01/2005 |
|
Status: Unverified
GOAL:
Should BI and AI on their own disk
GOAL:
Should the BI and AI be on separate disk
GOAL:
Should BI and AI be on individual disk
FIX:
For the best possible performance, the bi log should be on its own drive.
Ai logs extents should be alternated across /two/ separate drives for best
performance. That way you can archive the previously filled extent without
affecting the writing of the current one.
BUT:
Separate drives is sometimes overdoing it. Not everyone always needs the best possible performance, and not every database has enough update load to max out on bi log writing.
Not everyone wants to spend the extra money
When you run multiple databases on the same server, having separate drives for bi logs is even more money to spend.
Depending on the load you have, you should either put multiple bi logs on one drive, or put them on the same drive that has the data extents.
Striping and mirroring data and bi together can be a reasonable compromise, especially when there are many databases running on one server.
ai logs must be always be separated from data and bi or you lose most of the benefit of using ai.