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.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2010-04-13 : 07:11:06
|
| Hi allmsdb data file has grown upto 25GB in the production instance. I tried to get the objects that caused this growth. But none of the table sizes are more than 250MB and I used sp_spacesued to get this info. Is there any thing that I need to check ?I tried to shrink the data file but it can only relieve 2GB out of 25GB. Please let me know how to find an object in the msdb database which is consuming huge amount of space.Thanks. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-13 : 07:15:04
|
Just guess:Have a look at the database properties and pick up the size value by right clicking on the database name in Object Explorer.Maybe you are looking at the wrong mdf?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2010-04-13 : 07:28:08
|
| I have done that. The file size is shown as 25GBThanks. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-04-13 : 08:27:21
|
| Recycle old log files and Backup history. |
|
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2010-04-13 : 08:41:43
|
| I have found some internal tables created due to Service broker. How to query the internal tables or how to get the size of internal tables.Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-13 : 10:06:27
|
| The tables that store history of Backups are SYSTEM so may not show up in your normal query?Some details here (but related to SQL 2000, I think the MS provided SProc in SQL2005 is fixed so it doesn't take WEEKS (literally!) to delete the old data)http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36201 |
|
|
|
|
|
|
msdb datafile size has become very big in prod