Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2007-02-26 : 14:26:46
|
| Hi,In November our database size was 15 GIG I was advised to switch Auto Shrink DB settings off as this could have adverse impact on the performance on SQL Server. Now I find that the DB Size has grown to 27 Gig. Unused space in the datafile is around 4 Meg. Remaining space is all allocated. should i run dbcc re-index to reallocate space more efficiently within the data file ? Is there any other strategy apart from Shrink File to reduce the database size ?Thanks |
|
|
miranwar
Posting Yak Master
125 Posts |
Posted - 2007-02-26 : 14:28:00
|
| sorry I duplicated this : http://sqlteam.com/forums/topic.asp?TOPIC_ID=79697 |
 |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-02-26 : 14:40:24
|
| If you think the size of the database includes 'Empty space' then look at DBCC commands for shrinking the database and/or database files. These will reduce your disk space if there is empty space in them.If you are concerned about the indexes then DBCC also has commands to rebuild or reindex them. Reindex keeps the current index space and just reorganizes the information. Rebuild - drops and recreates the indexes. Rebuild should be used when the indexes are more than 30-40 percent fragmented I think.Both of these should be part of a maintenance check/plan along with updatining statistics.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|
|
Database size issue