SQL free space

[tran008]

running the sp_spaceused the following return:
db size 48426.75 MB
unallocated space 8098.20 MB.

My question is will the db size continue to growth if I add more data, and leave the unalloactaed space alone or the new data will used the unalloacted space? If not, what % would you recommend on leaving the free space if shrink database is run.

thanks

 

[ptheriault]

If you right click on the database and select properties. Click on the files page.
1. Is Autogrow turned on?
2. what is the growth % or MB.

It will always keep that % or MB free in your datafile.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

It will always keep that % or MB free in your datafile.

I beg to differ of this point. SQL will use all the page in the data file, then when it fills the file it will extend the file by the amount (or percentage) which the autogrow is set to.

As Paul asked...

1. Is Autogrow turned on?
2. what is the growth % or MB.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

>>SQL will use all the page in the data file, then when it fills the file it will extend the file by the amount (or percentage) which the autogrow is set to.

My mistake.

- Paul

- If at first you don't succeed, find out if the loser gets anything.