If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > space available for database 0.00MB

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: May 2004
Posts: 1
space available for database 0.00MB

Hi

Please help me in resolving the proble.

Database properties showing space available for database is 0.00mb
physical available space on HDD is around 32 GB... Db size is 5gb...but im bit worried about the size what is being displayed....
Settings in my database

General
1) Size of db: 14306.45MB
2) Space available: 0.00MB

Data Files
1) Automatically grow file
2) File growth By Percent: 10
3) Maximum file size: Unlimited file growth

Transaction log
1) Automatically grow file
2) File growth By Percent: 10
3) Maximum file size: Unlimited file growth

Options
1) AutoShrink
I'm worried about this "space available: 0.00MB". What kind of impact will it create?
If I set all settings to unlimited file growth, does it mean my database can grow as big as my physical harddisk space allows? Does this also means I do not have to worry about database allocation?

Please help me
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2003
Location: San Antonio, TX
Posts: 3,634
Don't use % for file growth.
Preallocate the data and log sizes based on estimated growth (that's a homework that developer and DBA need to do while planning the implementation) to minimize the impact on performance when additional growth is required.
Don't over-allocate because this will impact your backup size and duration.
Always set the limit to grow, otherwise you'll get a suspect status (at a minimum), or even worse, - server will not start, depending on what database runs to the disk limit first.
Autoshrink has issues related to SAN or very fast IO subsystem, so turn it off, you're not gaining anything having it on.
__________________
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On