Perhaps the backup was a red herring!

It turns out a DBCC CHECKDB was occurring on the database that was struggling to perform.

I've nuked the maintenance plan and replaced it with...

OK it would appear the differential backups (weeknights) and the full backups (weekends) are failing on one particular database, although it doesn't give much away as there are no error...

Hi Dave

You are right something very strange indeed is occuring.

I've just enumerated a list of backup jobs for the database server in Commvault.

It appears whenever everything has ground to a...

No I don't have enterprise edition running on this instance.

Dave,

Would you classify this as a general performance issue? Once a day, I get a load of locking chains with the PAGE IO LATCH tag, something isn't right there -...

Hi Dave

I'm not sure if you've compared the two separate graphs (the first two).

The first one was taken when there were no performance issues (with BACKUPIO and BACKUPBUFFER present).

The second...

Hi Dave

I think I am getting somewhere.

I have compared the SQLNexus reports for both traces (one stable, one unstable/locked).

I think the graphs will speak for themselves, although I don't know...

Hi

It is a SQL server issue because I have multiple web servers and none of them can function whilst there is a deadlock.

Guys,

I've had another deadlock this morning at 6AM reported in IIS.

SharePoint performance on particular web application has almost completely ground to a stop.

I'm taking a 15 min trace with SQLDiag/PerfStats...