|
|
|
SSC Veteran
 
Group: General Forum Members
Last Login: Thursday, March 18, 2010 3:09 PM
Points: 205,
Visits: 274
|
|
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
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, March 18, 2010 3:01 PM
Points: 113,
Visits: 376
|
|
| 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.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, March 18, 2010 3:09 PM
Points: 205,
Visits: 274
|
|
|
|
|
