Hi Lynn/Grant

I'm seeing an unusually high Log Harden Time which coincides with the slowdown. I don't think the I/O error posted has anything to do with this as it mentions a completely different database, though perhaps I'm wrong.

The SQL query posted is for a table tracking who's online, it's incredibly simple with just an ID (PK), username (nvarchar), datetime (datetime) & url (nvarchar). I don't believe this table is causing the problem, rather it's always the first one executed on page load and so a momentary slowdown with the database will affect this query first.

I'm seeking help as to which other performance counters I can look at to determine if the problem is disk I/O on the principal or mirror, network latency/bandwidth between the servers or something else.

What other information can I provide to help?

EDIT: Grant, I've checked and no statistics were updated around the time of the slowdown this morning.

Many thanks,

Marcus