Creating Missing Index on MSDB database

Question

question

leo 1 asked Dec 10, '11

Creating Missing Index on MSDB database

Hi, I just run the missing index query on MSDB database and I am getting highly impact on Backupset and RestoreHistory Table. I never done creating index on system databases. Is that safe to create the index? Do you have any suggesting on that? Thanks

sql-server-2008 sql indexing

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-12-10T13:10:28Z

Tim answered Dec 10, '11

I wrote a blog post referencing indexes that I create on MSDB for backup history. If you want you can read up on it [here]( http://timradney.com/2010/10/19/checking-backups/). A great blog I found later about the subject that includes all the indexes you need for backup history on MSDB written by Geoff Hiten can be found [here]( http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx). Chances are many of the indexes are the same. My advice is to run Geoff's.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

leo 1 commented · Dec 10, 2011 at 01:43 PM

Thanks TRAD. Just applied Geoff script on MSDB.

0 ·

question