Shrinking the file is an important first step, and it will definitely help your immediate need. I want to reiterate, however, that it is not a long-term solution. ...

Well, the database size isn't going to change unless you shrink the database, but the amount of free space may have change. Do another right click on msdb >...

That is an informational message that is the result of the WITH ROLLBACK IMMEDIATE. If the command can't be run, it rolls back any pending transactions first. Chances...

AndrewSQLDBA (8/11/2010)

---

Since it is NOT a SSIS Server, then why are you storing all those SSIS packages in the MSDB database?

Remove them, that will free up a few Gigs...

Another google find:

To completely obliterate the messages without attempting delivery use ALTER DATABASE [msdb] SET NEW_BROKER WITH ROLLBACK IMMEDIATE;. It is very important that you attempt this only if you...

Now we're getting somewhere. I goggled "sysmitqueue", and this is the most intelligible response I found in a short amount of time. Feel free to google it yourself,...

Try running this and posting the results:

USE [msdb]

SELECT object_name(i.object_id) as objectName,

i.[name] as indexName,

sum(a.total_pages) as totalPages,

sum(a.used_pages) as usedPages,

sum(a.data_pages) as dataPages,

(sum(a.total_pages) * 8) / 1024 as totalSpaceMB,

(sum(a.used_pages) * 8) / 1024 as...

Well isn't that just the definition of irony? Your msdb database is too big and can't allocate space, either because you've limited the size or the hard drive is...

As I understand it, most DBAs disable parallelism for a single queries because there are concurrency issues that Microsoft has not truly resolved. I was thinking more along the...

Adiga (8/7/2010)

---

dsohal (8/6/2010)

---

I get this info,

dbo. sysssispackages # of records = 20 Data 9544 KB

dbo.sysmail_attachments # of records = 18 Data 4064 KB

dbo.sysjobhistory # of records = 1000 Data =...

I think you should go where where you can benefit the company most. Typically that is the path to the most money. Job titles and average salaries definitely...

So your top tables are measured in megs? Are you sure you're reading it right? I can't think of much other than a table that would take up...

In SSMS, right click on the msdb database. Click Reports > Standard Reports > Disk Usage by Top Tables. That should tell you what's taking up so much...

I don't think that dynammic SQL will be your bottleneck as much as accessing 5 linked servers will be. It's not likely you can do anything about the linked...

Ken@Work (8/5/2010)

---

Perhaps when I get the calcualtion finished I'll be back for your help.

Honestly it's a bit lengthy and hard to follow just giving you the list of tables.

This does...