Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 What's causing the DB Size huge?

Author  Topic 

dbaman
Starting Member

46 Posts
Posted - 2010-05-19 : 10:13:45
I have SQLServer 2005 database with Recovery Model Set to Simple. This database has 18 user tables. I looked for the size of each table and didn't find any huge table. Still the MDF file of this database is 67GB.
What could be causing the database file (MDF) to be this big?

This is what I got when I ran the SQL to get each table size info.

Name,Rows,Reserved,data,index_size,unused
-----------------------------------------
COUNTRY,236 ,32 KB,16 KB,16 KB,0 KB
STATE,66 ,16 KB,8 KB,8 KB,0 KB
ORDERINFO,2 ,24 KB,8 KB,16 KB,0 KB
D_ENTRY,4 ,16 KB,8 KB,8 KB,0 KB
SAL_DELVR,4 ,16 KB,8 KB,8 KB,0 KB
SAL_FMDWL,2 ,16 KB,8 KB,8 KB,0 KB
dtslog,0 ,0 KB,0 KB,0 KB,0 KB
SAL_OP,2 ,16 KB,8 KB,8 KB,0 KB
SAL_RG,23 ,16 KB,8 KB,8 KB,0 KB
SAL_PP,3 ,48 KB,16 KB,32 KB,0 KB
sysds,1 ,72 KB,48 KB,24 KB,0 KB
V_ADDRESS,1274 ,208 KB,152 KB,8 KB,48 KB
PAID_FEE,2614 ,528 KB,472 KB,8 KB,48 KB
SAL_AD,21 ,16 KB,8 KB,8 KB,0 KB
SAL_ADVL,2 ,16 KB,8 KB,8 KB,0 KB
CASE_ON,7000 ,2064 KB,2024 KB,8 KB,32 KB
WH_RCL,386953 ,346200 KB,344080 KB,1896 KB,224 KB
ST_AD,0 ,24 KB,8 KB,16 KB,0 KB


R

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2010-05-21 : 17:46:00
What does SP_SpaceUsed Show for unused space? Has someone deleted million of rows?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-05-21 : 17:46:48
Have you rebuilt the clustered indexes?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site