Donna

Unregistered less info
11 reputation
2
bio website
location
age
visits member for 1 year, 8 months
seen Dec 7 '12 at 22:50

Jan
30
awarded  Popular Question
Nov
19
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
I think I figured it out with the help of Brent Ozar's contact named Jeremiah. I found that the only time the data file was growing over the last 2 month's was during the re-indexing job. I am 'not' using sort-in-tempdb which means SQL will use space in the data file to complete the re-index process and since some of those indexes are rather large, it exceeds the 40GB free.
Nov
19
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
When I look at the Disk Usage report, I see a huge amount of space labeled - unallocated. According to the MSDN site, this is space available for use. I am associating this space with free space. Dang it, why won't it allocate it then.
Nov
19
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
I have already examined the default trace files and it appears that the data file has only autogrown 1 time in the last month. So, my issue is not that it is growing, my concern is that it isn't using the free space it already has before growing. If it doesn't use the 40ish GB it has, I am going to have to add space, but being respoinsible, I don't want to add space if something is wrong here. All my other databases use free space first....this is weird. I must be missing something unique about this database.
Nov
19
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
name fileid filename filegroup size maxsize growth usage LargeDB_Data 1 G:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\LargeDB.mdf PRIMARY 19667641‌​6 KB Unlimited 1048576 KB data only LargeDB_Log 2 H:\MSSQL10_50.MSSQLSERVER\MSSQL\Data\LargeDB_1.ldf NULL 5128704 KB Unlimited 512000 KB log only
Nov
19
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
Here is the sp_helpfile output.
Nov
19
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
As requested, the results of the query above are:File Group Currently Allocated Space (MB) Space Used (MB) Available Space (MB) PRIMARY 192066.81 150394.63 41672.19
Nov
16
comment SQL Server 2008 R2 Database - Why is the database not using free space before growing again?
Thanks for the response. There is only 1 filegroup and the free space is all in the same file group.
Nov
16
awarded  Student
Nov
16
asked SQL Server 2008 R2 Database - Why is the database not using free space before growing again?