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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2010-12-21 : 09:02:19
|
| Guys,The CPU on the SQL 2008 sp2 64bit box is always at 70% utilization which is causing queries to time out especially the ones which have sorting operationslike 'DISTINCT' and 'ORDER BY' clause. On further investigation from performance monitor we found that one of the SQL processes was consuming most of the CPU. We looked for the the processid in the sysprocess and found that cmd check point was the related processid consuming the resources.spid kpid status hostname cmd DB Name11 1948 background CHECKPOINT master When the CPU is normal with < 10% utilization interspersed with spikes, the sorting queries comeback in 0 secs.Below are the env variablesSystem: Windows 2008 R2 Standard 64bitSQL Server: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64)DB Size: 3gbNumber of DBSon the instance: 2DB Modes: Stand by/read only since these are destination log shipping databases with logs restored every night.Any suggestions and inputs would help.Thanks |
|
|
|
|
|
High CPU on SQL 2008 64BIT