Home > IT Answers > Business Intelligence > How to calculate my DataBase size
VADCHACHO
5 pts.
 How to calculate my DataBase size
Data modeling, Database design
Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please

Software/Hardware used:
ASKED: July 20, 2008  1:24 PM
UPDATED: July 22, 2008  12:21 PM
RELATED QUESTIONS
Answer Wiki:
If the database already exists, you can simply right click on the database and select properties. This will show you the space used, and the free space. Subtract the two and you'll get the space used. If it's for a new database, there is an <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1289528,00.html">article</a> over on SearchSQLServer.com which shows how to calculate the space needed. It's based on SQL Server, but the process is the same for all platforms.
Last Wiki Answer Submitted:  July 21, 2008  10:58 pm  by  Balouchi   75 pts.
All Answer Wiki Contributors:  Balouchi   75 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.
 

The size shown by right click on database may not be the actual size consumed by the database, it will be including the white space occupied which could be marginal to considerable.

Jaideep Khanduja
 8,200 pts.