Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2009-04-12 : 08:44:28
|
| Dear all,We have a sql 2k5 along with SP2 also we have performed logshipping of various databases .But it has been observed that cpu utilisation for sqlserver.exe remains between 75 to 90 % on the system and it is very critical.Also i have got the output of sp_who2 active in which i found that most of the cpu is taken by LAZY WRITER and LOG WRITER processes.Please help me to find the way out. |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2009-04-12 : 09:36:39
|
| Please help its really urgent.......................... |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-04-12 : 10:37:14
|
| Steel, there can be several reasons for this is this all and sudden you are getting this spike in cpu utilization? in order to resolve your issue we need some more information (have you rebuild indexes lately, are statistics are up to date?)You can run sql profiler or server side trace to narrow down on reasons..? |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2009-04-12 : 11:35:10
|
| Yup checked all indexes.also checked the trace and tunned the same with tunning advisor but no performance improvement. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-12 : 12:00:43
|
| Check these articles out for finding problematic queries.http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/What's your disk utilisation like? (check Physical Disk:Avg sec/read, Physical Disk:Avg sec/write and Physical Disk:% idle time in perfmon). What's the disk layout? (Raid level, number of arrays, files on arrays, etc)Lots of waits on Lazy writer and log writes suggest disk bottlenecks.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
cpu utilisation very high