CPU百分之百 [英] CPU hundred percent

问题描述

我的生产服务器（SQL SERVER 2008 R2）CPU使用率经常达到100％。



任何人都可以提供帮助。

Hi,

My production server(SQL SERVER 2008 R2) CPU usage frequently went 100%.

Can anyone help on this.

推荐答案

获得更快的计算机，减少SQL的负担，更改数据库布局或正在执行的查询，或升级到服务器场。检查你的硬盘和内存：页面交换会导致高CPU负载。



我们无法给你任何具体的建议：你需要看看发生了什么和找出CPU使用率高的原因。我们不能为你做到这一点！

Get a faster computer, reduce the load on SQL, change the database layout or the queries you are executing, or upgrade to a server farm. Check your HDD and memory: page swapping can cause high CPU loads.

We can't give you any specific advice: you need to look at what is going on and work out why the CPU usage is high. We can't do that for you!

这篇关于CPU百分之百的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！