Re: 100 % CPU Usage

> This problem occurs everytime. I have just reproduced it again and the
> results of sp_who2 are below:
>...
>
> 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.

Hm, there is a lot of CPU on the Lazy Writer given the login time.
Could that be a token of something? (I'm just thinking aloud.)

> 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

15457 is change of configuration option.

> Incidentally, this does occur on another 2 machines I have tried it on
> and so I do not think it is a hardware problem.

Interesting indeed.

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

I would definitely open a case for this. This smells very fishy to me.
If this indeed is a bug in SQL Server, you should be refunded anything
you are charged initially. Of course, if there is indeed something bad
in your environment, you will have to pay.

OK, one idiot check before you call: you are not using compressed drives
are you?


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Massive Log Files
    ... command with the TRUNCATE_ONLY option, you can find more info in books ... Co-Author SQL Server 2000 Programming by Example ... > We have a problem with huge log files for our SQL Server databases. ... > We've been digging through Books Online and trying various esoteric ...
    (microsoft.public.sqlserver.tools)
  • Re: database optimization
    ... Isn't there a single command that will take care of the whole database ... certain fragmentation level. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)