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
 Other SQL Server Topics (2005)
 Database Grow Very Fast

Author  Topic 

next9984
Starting Member

2 Posts

Posted - 2011-01-24 : 03:50:32
I use Microsoft SQL Server 2005 in my company and we have several branch that use the same application. I have noticed that the database of one branch is growing very fast compare to other branches. I don't know why! the data storing in the database is similar. So is there anyway or tool to check why it grow very fast?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-24 : 04:42:23
Is it the data file that's growing or the log file?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

next9984
Starting Member

2 Posts

Posted - 2011-01-24 : 20:09:35
It's data file (*.mdf)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-24 : 20:11:09
Check the table sizes over a few days to narrow it down. Compare those percentages/numbers to a database for another branch.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -