July 18, 2007 at 6:20 am
folks, I see my msdb database has grown suddenly to 1gb and i do not see any info. abt this in errorlog, I also see that no user tables exists. When i checked heavily used tables i could see sysdtspackages having older versions and i have removed all the older versions for the dts packages and reduced the table size from 600 mb to 200 mb but still my msdb size is 1gb.
I'm not sure why the size is not getting reduced, the backup and restore tables are not cleaned up yet but these does not contain that many history.
I want to know why this sudden growth and why the size does not decrease even after deleting from sysdtspackage tables....
But i could see from SQLAGENT.out file that having info. abt jobs that are been queued on agent subsystem and i suppose that it has reached the max worker threads which is why that info. is coming......
Let me know some inputs on sorting out this...
Murali.a
July 18, 2007 at 6:32 am
You need to free up space used by the database. Shrink the data file so that your unused space will be taken by the OS.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 18, 2007 at 6:34 am
TO add more info just removing rows from the table will not free up disk space as there might be file level and table level fragmentation. You need to defrag to get the unused space.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 18, 2007 at 6:49 am
Yes, I'm aware abt it. Once i delete the rows i checked used
dbcc updateusage but no scope, Checked by running optimization but still no hopes....
July 18, 2007 at 6:50 am
again, I'm too nervous in doing a shrink on a system db (msdb).
July 19, 2007 at 2:23 am
Nothing to be nervous just take a backup and then fire the shrink task. But remember to give some amount of free space at the end.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply