Hi Nicholas - The locking/blocking is associated with couple of tables only. These table serve as unique id generator and are highly transactional

I have recorded no deadlocks during the slowdown.

The...

I will reply to David's and Young's queries.

1. The db is 100 GB+

2. The log backup are taken every 5 minutes

3. No maintenance jobs run during day time

4. the updates...

William - Thanks for your reply.

Current memory settings are

SQLInstance1 : (instance with problems)

Min Memory - 30 GB

Max Memory - 40 GB

Max Degree of //sm - 1

SQLInstance2:

Min memory-...

Hi - The awe option is enabled. I used win perfmon to look for SQL Server:Memory Manager--> Total Server memory (KB) counter.

Hi - The hotfix is already applied.

Thanks

Thanks Shawn for the reply , is "procedure cache" the memory place where execution plan's for stored procedures are saved?

The log files are not that large (max 160 MB log backup size ) , what is the best way to find if server is low on memory?

Regards