Dear All,

Can some one help me out please

Please find the some more information.

-------------------------------------------------------

CPU Usage -- 100 % and Physical memory -- 89% and Nework utilization -- 0.06%.

OS -> Microsoft(R) Windows(R) Server 2008, Enterprise without Hyper-V

SQL Server edition---> Microsoft SQL Server2005 Standard Edition

No of processors on the server---> 8 Processors [Intel(R) Xeon(R) CPU E5405 @ 2.00GHz,1995 Mhz,4 core(s),4 logical Processor(s),Intel(R) Xeon(R) CPU E5405 @ 2.00GHz,1995 Mhz,4 core(s),4 logical Processor(s)]

Min memory and Max memory settings- AWE enabled , Min Server memory 10240 MB and Max Server memory 30720 MB

Max Degree of Parallelism - 0

Max worker threads --- > 0

Note: Tlog backups were failing at certain time( ERROR No: 12291).

Your prompt reply is much appreciated.

Thanks and Regards,

Ravichandra.