x

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
more ▼

asked Dec 10 '11 at 12:51 PM in Default

leo 1 gravatar image

leo 1
66 2 2 3

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

1 answer: sort oldest
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 '11 at 01:10 PM

Tim gravatar image

Tim
35.5k 32 41 138

Thanks TRAD. Just applied Geoff script on MSDB.
Dec 10 '11 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x673
x122

asked: Dec 10 '11 at 12:51 PM

Seen: 1284 times

Last Updated: Dec 10 '11 at 12:51 PM