Try adding in these indexes:

http://weblogs.sqlteam.com/geoffh/ar...ce-Tuning.aspx

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Chris Wood" <anonymous@microsoft.com> wrote in message
news:OaF3pkBkIHA.1168@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> We run maintenance plan created SSIS packages to backup our databases. The
> final step is the cleanup of the jobhistory. We see the occasional
> deadlock coming from sp_maintplan_delete_log.
>
> Now I know that msdb backup tables have no indexes. We are looking at
> implementing Geoff Hiten's suggested indexes
> http://weblogs.sqlteam.com/geoffh/ar...ce-Tuning.aspx
>
> Will this our deadlocks?
>
> Thanks
>
> Chris
>