JC-3113
SSCrazy Eights
Points: 8371
More actions
October 23, 2009 at 12:53 pm
#212877
HI Folks
I came across a document about adding indexes to MSDB regarding backup tracking tables
Has anyone addedd indexes like these and a better question is, should I ?
the document is at:
http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx
titled "MSDB Performance Tuning"
Any feedback is appreciated
Thanks
Jim
George M Parker
SSCertifiable
Points: 5412
October 23, 2009 at 1:17 pm
#1070236
Yes, I've added many of the same indexes to solve the same problem with deleting backup history data from msdb. Without the indexes, it took forever. With them, it ran significantly faster. I never had any issues because of the indexes being added.
October 23, 2009 at 1:31 pm
#1070242
Thanks George
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply