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 |
|
sureshmanian
Starting Member
26 Posts |
 Posted - 2014-05-20 : 10:16:03
|
| HiWe do face the problem in our sql server 2008 server 100% cpu usage by sql server.exe always, hence the Application is very slow. I have found that the issue because of (SPID = 10) which is the Background process -- CHECKPOINT. How to solve this issue, is there way to kill/stop the particular SPID 10.Thank you.RegardsSSM |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-20 : 14:08:23
|
| How did you determine the checkpoint is the culprit? Have you looked at I/O in PerfMon, specially Avg Writes and Reads/sec? Are you seeing averages be over 12ms sustained?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-05-26 : 03:58:10
|
| How many CPUs on the server?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
CPU 100% usage