100％CPU使用率 [英] 100 % CPU Usage

问题描述

嗨


我对SQL Server的CPU使用率有一个真正的问题，而且与查询不良有关的不是
。


我有一个客户数据库，我正在调查一些问题

with。在我使用该应用程序执行标准任务后，

结果已返回给应用程序，cpu使用率仍为

100％。

即使应用程序完全关闭了cpu使用情况

仍为100％。没有其他事情发生。


我完全失去了如何继续调查

这个问题（我一直在寻找这个问题）超过一周使用SQL

服务器工具和性能监视器，并消除各种其他

的可能性）


我下载了Process Explorer，并查看

sqlservr.exe的主题，特别是有一个消耗所有的

cpu时间：


MSVCRT.DLL


我在以下机器上运行SQL Server 2000 SP4：


Windows 2000 SP4

Pentium 4 3Ghz（注意这被视为2个处理器，因此报告的cpu

使用率为50％）

1Gb内存


我还有大约20Gig的可用磁盘空间。


另外一件事，

进程资源管理器的性能选项卡上报告的页面错误超过300万。这是在运行

申请大约10分钟之后。


请有人建议任何可能有用的建议吗？对不起

这里没有太多的信息，但是我还没有能够找到任何有用的东西！


非常感谢提前。


Paul

Hi

I am having a real issue with CPU usage by SQL Server, and it is not
related to a poor query.

I have a clients database that I am currently investigating some issues
with. After I perform a standard task using the application, and the
results have been returned to the application the cpu usage remains at
100%.

Even once the application has been completely closed down the cpu usage
remains at 100%. Nothing else is happening.

I am at a complete loss as to how to proceed to with investigation of
this issue (i have been looking at this for over a week using SQL
Server tools and Performance Monitor, and eliminating various other
possibilities)

I downloaded Process Explorer, and looking at the threads for
sqlservr.exe there is one in particular that is consuming all of the
cpu time:

MSVCRT.DLL

I am running SQL Server 2000 SP4 on the following machine:

Windows 2000 SP4
Pentium 4 3Ghz (Note this is seen as 2 processors so the reported cpu
usage is 50%)
1Gb Memory

I also have about 20Gig of free disk space.

One other thing, the page faults reported on the Performance tab of
Process Explorer exceeds 3 million. This is after running the
application for around 10 minutes.

Please can anybody suggest anything at all that might help? I''m sorry
there is not too much information in here but I have not been able to
find out anything useful!

Many Thanks in advance.

Paul

推荐答案

Paul（pa * ********* * @ hotmail.com）写道：

Paul (pa***********@hotmail.com) writes:

我对SQL Server的CPU使用率存在实际问题，并且它与穷人无关查询。

我有一个客户数据库，我正在调查一些问题
。在我使用应用程序执行标准任务后，
结果已返回到应用程序，cpu使用率保持在100％。

即使应用程序已完全完成关闭cpu使用率
仍为100％。没有其他事情发生。

我完全不知道如何继续调查这个问题（我已经使用SQL查看了一周以上
服务器工具和性能监视器，并消除各种其他可能性）

我下载了Process Explorer，并查看了sqlservr.exe的线程，特别是有一个是消耗所有的cpu时间：

MSVCRT.DLL

I am having a real issue with CPU usage by SQL Server, and it is not
related to a poor query.

I have a clients database that I am currently investigating some issues
with. After I perform a standard task using the application, and the
results have been returned to the application the cpu usage remains at
100%.

Even once the application has been completely closed down the cpu usage
remains at 100%. Nothing else is happening.

I am at a complete loss as to how to proceed to with investigation of
this issue (i have been looking at this for over a week using SQL
Server tools and Performance Monitor, and eliminating various other
possibilities)

I downloaded Process Explorer, and looking at the threads for
sqlservr.exe there is one in particular that is consuming all of the
cpu time:

MSVCRT.DLL

听起来不错。


我会查看SQL Server错误日志，看看是否有任何

消息。


如果这种情况反复发生，我会考虑用微软打开一个案例

，因为这听起来像是SQL Server中的一个问题。

那个或者一些硬件问题。


你当然也应该确保sp_who2没有

活动进程。特别是，观看CPUTime专栏，看看是否有任何嫌疑人。

-

Erland Sommarskog，SQL Server MVP， es **** @ sommarskog.se


SQL Server 2005联机丛书
http://www.microsoft。 com / technet / pro ... ads / books.mspx

SQL Server 2000联机丛书
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sounds bad.

I would look in the SQL Server error log, to see if there are any
messages.

If this scenario is happen repeatedly, I would consider open a case
with Microsoft, as this sounds like it could be a problem in SQL Server.
That or some hardware problem.

You should of course also make sure with sp_who2 that there are no
active processes. Particularly, watch the CPUTime column, to see if
there is any suspect.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

您好Erland，感谢您的回复。


每次都会出现此问题。我刚刚再次复制了它，sp_who2的

结果如下：

SPID状态登录HostName

BlkBy DBName命令CPUTime DiskIO LastBatch

ProgramName SPID

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

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

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

1背景sa。

。 NULL LAZY WRITER 246172 0 11/23 10:48:41

1

2睡觉sa。

。 NULL LOG WRITER 31 0 11/23 10:48:41

2

3背景sa。

。 NULL LOCK MONITOR 0 0 11/23 10:48:41

3

4背景sa。

。大师SIGNAL HANDLER 0 0 11/23 10:48:41

4

5背景sa。

。大师TASK MANAGER 0 131 11/23 10:48:41

5

6背景sa。

。大师TASK MANAGER 0 0 11/23 10:48:41

6

7睡觉sa。

。 NULL CHECKPOINT SLEEP 0 0 11/23 10:48:41

7

8背景sa。

。大师任务经理0 159 11/23 10:48:41

8

9背景sa。

。大师TASK MANAGER 0 0 11/23 10:48:41

9

10背景sa。

。大师TASK MANAGER 0 45 11/23 10:48:41

10

11背景sa。

。掌握TASK MANAGER 0 117 11/23 10:48:41

11

51睡觉FWPS \PWragg

BHX-WS0292-2K。掌握AWAITING COMMAND 109 290 11/23

10:49:12 MS SQLEM 51

53 RUNNABLE sa

BHX-WS0292-2K。掌握SELECT INTO 359 824 11/23

11:05:42 SQL查询分析器53

对于格式化很抱歉。正如您所看到的，唯一可运行的进程是sp_who2命令。并且该应用程序的用户不在登录列表的

中，因此它不能与应用程序相关。我今天早上启动了

实例时，错误日志中确实有这条消息：


2005- 11-23 10：48：54.00 spid51启动数据库''msdb''。

2005-11-23 10：49：11.92 spid51错误：15457，严重性：0，状态：1


但是，我认为这是一个无关的错误，因为这不会出现

任何其他时间都发生这种情况（我已经检查了这个）。顺便说一句，这确实发生在我尝试过的另一台机器上，所以我认为它不是硬件

问题。


也许我应该尝试向微软提出这个问题，除非你能想到其他任何东西吗？


谢谢


Paul

Hi Erland, thanks for the reply.

This problem occurs everytime. I have just reproduced it again and the
results of sp_who2 are below:

SPID Status Login HostName
BlkBy DBName Command CPUTime DiskIO LastBatch
ProgramName SPID
----- ------------------------------ ----------------------
------------- ----- ------ ---------------- ------- ------
-------------- ------------------ -----
1 BACKGROUND sa .
. NULL LAZY WRITER 246172 0 11/23 10:48:41
1
2 sleeping sa .
. NULL LOG WRITER 31 0 11/23 10:48:41
2
3 BACKGROUND sa .
. NULL LOCK MONITOR 0 0 11/23 10:48:41
3
4 BACKGROUND sa .
. master SIGNAL HANDLER 0 0 11/23 10:48:41
4
5 BACKGROUND sa .
. master TASK MANAGER 0 131 11/23 10:48:41
5
6 BACKGROUND sa .
. master TASK MANAGER 0 0 11/23 10:48:41
6
7 sleeping sa .
. NULL CHECKPOINT SLEEP 0 0 11/23 10:48:41
7
8 BACKGROUND sa .
. master TASK MANAGER 0 159 11/23 10:48:41
8
9 BACKGROUND sa .
. master TASK MANAGER 0 0 11/23 10:48:41
9
10 BACKGROUND sa .
. master TASK MANAGER 0 45 11/23 10:48:41
10
11 BACKGROUND sa .
. master TASK MANAGER 0 117 11/23 10:48:41
11
51 sleeping FWPS\PWragg
BHX-WS0292-2K . master AWAITING COMMAND 109 290 11/23
10:49:12 MS SQLEM 51
53 RUNNABLE sa
BHX-WS0292-2K . master SELECT INTO 359 824 11/23
11:05:42 SQL Query Analyzer 53

Sorry about the formatting. As you can see the only runnable process is
the sp_who2 command. And the user for the application is not in the
list of Logins so it cannot be anything related to the application. I
do have this message in the error log though from when I started up the
instance this morning:

2005-11-23 10:48:54.00 spid51 Starting up database ''msdb''.
2005-11-23 10:49:11.92 spid51 Error: 15457, Severity: 0, State: 1

However, I think this is an unrelated error as this does not appear for
any of the other times this has happened (and I have checked for this
on other newsgroup postings). Incidentally, this does occur on another
2 machines I have tried it on and so I do not think it is a hardware
problem.

Maybe I should try and raise this with Microsoft unless you can think
of anything else?

Thanks

Paul

嗨Erland，谢谢你的回复。


每次都会出现此问题。我刚刚再次复制了它，sp_who2的

结果如下：

SPID状态登录HostName

BlkBy DBName命令CPUTime DiskIO LastBatch

ProgramName SPID

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

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

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

1背景sa。

。 NULL LAZY WRITER 246172 0 11/23 10:48:41

1

2睡觉sa。

。 NULL LOG WRITER 31 0 11/23 10:48:41

2

3背景sa。

。 NULL LOCK MONITOR 0 0 11/23 10:48:41

3

4背景sa。

。大师SIGNAL HANDLER 0 0 11/23 10:48:41

4

5背景sa。

。大师TASK MANAGER 0 131 11/23 10:48:41

5

6背景sa。

。大师TASK MANAGER 0 0 11/23 10:48:41

6

7睡觉sa。

。 NULL CHECKPOINT SLEEP 0 0 11/23 10:48:41

7

8背景sa。

。大师任务经理0 159 11/23 10:48:41

8

9背景sa。

。大师TASK MANAGER 0 0 11/23 10:48:41

9

10背景sa。

。大师TASK MANAGER 0 45 11/23 10:48:41

10

11背景sa。

。掌握TASK MANAGER 0 117 11/23 10:48:41

11

51睡觉FWPS \PWragg

BHX-WS0292-2K。掌握AWAITING COMMAND 109 290 11/23

10:49:12 MS SQLEM 51

53 RUNNABLE sa

BHX-WS0292-2K。掌握SELECT INTO 359 824 11/23

11:05:42 SQL查询分析器53

对于格式化很抱歉。正如您所看到的，唯一可运行的进程是sp_who2命令。并且该应用程序的用户不在登录列表的

中，因此它不能与应用程序相关。我今天早上启动了

实例时，错误日志中确实有这条消息：


2005- 11-23 10：48：54.00 spid51启动数据库''msdb''。

2005-11-23 10：49：11.92 spid51错误：15457，严重性：0，状态：1


但是，我认为这是一个无关的错误，因为这不会出现

任何其他时间都发生这种情况（我已经检查了这个）。顺便说一句，这确实发生在我尝试过的另一台机器上，所以我认为它不是硬件

问题。


也许我应该尝试向微软提出这个问题，除非你能想到其他任何东西吗？


谢谢


Paul

Hi Erland, thanks for the reply.

This problem occurs everytime. I have just reproduced it again and the
results of sp_who2 are below:

SPID Status Login HostName
BlkBy DBName Command CPUTime DiskIO LastBatch
ProgramName SPID
----- ------------------------------ ----------------------
------------- ----- ------ ---------------- ------- ------
-------------- ------------------ -----
1 BACKGROUND sa .
. NULL LAZY WRITER 246172 0 11/23 10:48:41
1
2 sleeping sa .
. NULL LOG WRITER 31 0 11/23 10:48:41
2
3 BACKGROUND sa .
. NULL LOCK MONITOR 0 0 11/23 10:48:41
3
4 BACKGROUND sa .
. master SIGNAL HANDLER 0 0 11/23 10:48:41
4
5 BACKGROUND sa .
. master TASK MANAGER 0 131 11/23 10:48:41
5
6 BACKGROUND sa .
. master TASK MANAGER 0 0 11/23 10:48:41
6
7 sleeping sa .
. NULL CHECKPOINT SLEEP 0 0 11/23 10:48:41
7
8 BACKGROUND sa .
. master TASK MANAGER 0 159 11/23 10:48:41
8
9 BACKGROUND sa .
. master TASK MANAGER 0 0 11/23 10:48:41
9
10 BACKGROUND sa .
. master TASK MANAGER 0 45 11/23 10:48:41
10
11 BACKGROUND sa .
. master TASK MANAGER 0 117 11/23 10:48:41
11
51 sleeping FWPS\PWragg
BHX-WS0292-2K . master AWAITING COMMAND 109 290 11/23
10:49:12 MS SQLEM 51
53 RUNNABLE sa
BHX-WS0292-2K . master SELECT INTO 359 824 11/23
11:05:42 SQL Query Analyzer 53

Sorry about the formatting. As you can see the only runnable process is
the sp_who2 command. And the user for the application is not in the
list of Logins so it cannot be anything related to the application. I
do have this message in the error log though from when I started up the
instance this morning:

2005-11-23 10:48:54.00 spid51 Starting up database ''msdb''.
2005-11-23 10:49:11.92 spid51 Error: 15457, Severity: 0, State: 1

However, I think this is an unrelated error as this does not appear for
any of the other times this has happened (and I have checked for this
on other newsgroup postings). Incidentally, this does occur on another
2 machines I have tried it on and so I do not think it is a hardware
problem.

Maybe I should try and raise this with Microsoft unless you can think
of anything else?

Thanks

Paul

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