Inconsistent DB Size

Discussion in 'Databases' started by wellpointvi, Dec 5, 2011.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. In Management Studio, our DB size shows 1654.25 MB. In the Control Panel’s MS SQL Manager, however, it shows the DB size Used Space as 1,430 MB.

    Why is such a big difference between the two?

    Which one is more reliable?

    Is this a DB issue or a server issue?

    If there’s an issue with the DB (such as fragmentation), how can it be resolved so the two methods show the same DB size?
     
  2. Once I ran Shrink Database, DB size shown on Management Studio went down and matched DB size on Control Panel's MS SQL Manager. So apparently, DB size shown on Control Panel doesn't account for fragmentations and therefore the size shown in Mangement Studio is more accurate than the size shown in Control Panel.
     
  3. That's because Management studio has auto growth feature enabled (by 3MB).

    Control panel's SQL tool shows the actual DB disk space usage while Management studio or any other DB tool that has auto growth feature enabled shows different size.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page