Checked isolation level at that hasn’t changed

Checked the server logs and there are no errors at all. Is there any other way I can check the SAN is ok?...

the database grows by 1Gb a day and has done for the last couple of years, so nothing new on that front. The server isn't virtualised.

It doesn't even seem...

I posted this morning after being up all night trying to resolve the issue.

My mistake, my apologies

I posted this morning after being up all night trying to resolve the issue.

My mistake, my apologies

It's mostly

RESOURCE_SEMAPHORE

and a few are

PAGEIOLATCH_SH

average row cont in sys.dm_io_pending_io_requests

is 80-90

I usually run this routinely

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

req.cpu_time,

req.total_elapsed_time / (60*060*60 *60) as [hours]

FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

order by req.total_elapsed_time desc

usually there are maybe 2-3...

Hi All,

Thanks for you comments so far. The TempDB is fine and there is plenty of disk space on the server. Yep i'm using 2005.

The only thing I...