Hi all,
I read this post , and wanted to know how I can change my exisiting database to grow by 20MB instead of the default 10%?
Copy of post:
Wayne,
I suspect that when you created you database, you went by the defaults. RMS by default adds to the database by percentage, 10% if you didn't change it. So in your case, when the database needs to grow, it adds ~200MB. When you get to 3GB, it will add 300GB at a time.
So the SQL Server sees a transaction comming and needs to grow, it has to add 200MB before posting the sale.
We always change the default to grow by 20MB becasuse its quickly done, even on slow machines.
To the guy that installed SP4 and is slow, (sorry this stupid forum will not show all posts when replying) make sure that you are not running 2.0.0151 as it was as slow as hell. It was also called SP4 before it was pulled from CustomerSource after about a week.
*This post is locked for comments
I have the same question (0)
