Creating Missing Index on MSDB database


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?


more ▼

asked Dec 10, 2011 at 12:51 PM in Default

avatar image

leo 1
66 2 2 5

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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. 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. Chances are many of the indexes are the same. My advice is to run Geoff's.

more ▼

answered Dec 10, 2011 at 01:10 PM

avatar image

40.9k 39 95 168

Thanks TRAD. Just applied Geoff script on MSDB.

Dec 10, 2011 at 01:43 PM leo 1
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 10, 2011 at 12:51 PM

Seen: 2363 times

Last Updated: Dec 10, 2011 at 12:51 PM

Copyright 2018 Redgate Software. Privacy Policy