January 15, 2005 at 11:54 am
I've been through the forum and read a number of threads on people's DBs not growing and the answer usually is they don't have auotmatically grow data file. Unfortunately I have this on, but when I look at the properties of the database it reports the space available is 0.00 MB? Up until about two weeks ago I was showing appx 48% space utilization. When I ran an SP to show growth, it tells me that it was expanded by 20% yesterday, but SQL Server is still telling me the space available is zero.
The log file is also set for auto growth. The DB is 14.5 GB in size and the drives still have around 92 GB of space.
Has anyone experienced this before? Any ideas? Does anyone know of an SPs that can give me detailed info on internal data file size compared to stated size (i.e. wasted space in data file)? Is SQL Server doing something funny in the way it is seeing the database or data files individually? Any help is appreciated.
January 15, 2005 at 12:24 pm
Look up DBCC UPDATEUSAGE in Books On Line.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 16, 2005 at 1:16 pm
Thanks Kathi, I checked this out and it sure looks like what I need. I plan on running it tonight to see if it does the trick. So if there is a problem in the sysindex, any guess as to what might have happened? Seems like you've heard of this happening before, do you know what the issues were during those incidents? I just want to make sure one of my developers isn't running something that will create this problem again.
Thanks, I'll keep you posted on how it worked.
January 17, 2005 at 7:14 pm
Sorry, don't know why this happens.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 17, 2005 at 7:24 pm
Thanks, that did the job. Now it shows size appropriately. Thanks again for all your help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply