SQL server 2000 increase database auto-grow
Home > IT Answers > SQL Server > SQL server 2000 increase database auto-grow
ITKE
10345 pts.
0
Q:
SQL server 2000 increase database auto-grow
SQL Server 2000, Auto Grow, Database Sizing
Does it matter to
increase database auto-grow from 10MB to 250MB? We expereience some
bottleneck at database size of 36 GB for a reporting database. But the
physical disk has 100 GB free disk space, CPU usage is not high.
Occasionally has some COM error Not sure what the problem it is

Software/Hardware used:
Sql server 2000
ASKED: Sep 8 2009  1:32 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You should manually grow out the database so that it is as big as it will need to be. SQL 2000 writes 0s to the file when it grows so large autogrow events will take time to complete.

10 MB is definitely to small. This will cause autogrow events to kick off quite often which will impact performance.
Last Answered: Sep 9 2009  8:11 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0