MS SQL uses 100% of my 2 CPU machine

[P Verbakel]

Hello,

I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.
I do NOT load the DB in any way with queries. Obviously this leads to
all kinds of software not working well anymore. Does anyone know how to
lower the CPU power used? Please help!?

regards,

Pierre Verbakel
The Netherlands

[PG Newhart]

Re: MS SQL uses 100% of my 2 CPU machine

Under the server properties in EM (right-click server name), under the
processor tab you can control the priority (to some degree), also you
can control how many processors SQL Server uses. I had a similar
problem with memory on an older server with only one processor. SQL
Server is notorious for being a memory hog regardless of how many
queries or users are on the system. For more of the advanced control
options related to memory tweaking and usage you need the high-end
versions of NT server and SQL Server. Although, I think that most low
to mid-size companies get by with the Standard Edition. I recommend
running only SQL Server on the server, not mixing other products like
IIS or or other applications.

HTH

P Verbakel <p.verbakel3@ch ello.nl> wrote in message news:<3EFC0E13. 5010809@chello. nl>...[color=blue]
> Hello,
>
> I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
> with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.
> I do NOT load the DB in any way with queries. Obviously this leads to
> all kinds of software not working well anymore. Does anyone know how to
> lower the CPU power used? Please help!?
>
> regards,
>
> Pierre Verbakel
> The Netherlands[/color]

[Simon Hayes]

Re: MS SQL uses 100% of my 2 CPU machine

If you have 100% CPU use on a fresh install, one possible reason is
the SQL Slammer worm. You don't mention if you've installed any
servicepacks, but if not, then you should update your installation as
a first step. If that resolves your issue, and you suspect that
Slammer is the cause, then you should investigate other MSSQL
installations on your network (including MSDE) to see if they are
infected - Microsoft has some tools to help.

But if you have everything already patched and up to date, then
perhaps you can give some more information about the server? In
particular, does it have other applications installed, or is it
dedicated to MSSQL? Do you have an antivirus scanner on the server
that might be continuously scanning the DB files?

Simon

P Verbakel <p.verbakel3@ch ello.nl> wrote in message news:<3EFC0E13. 5010809@chello. nl>...[color=blue]
> Hello,
>
> I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine
> with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.
> I do NOT load the DB in any way with queries. Obviously this leads to
> all kinds of software not working well anymore. Does anyone know how to
> lower the CPU power used? Please help!?
>
> regards,
>
> Pierre Verbakel
> The Netherlands[/color]

[Mystery Man]

Re: MS SQL uses 100% of my 2 CPU machine

It is really very easy.

1. Startup Enterprise Manager
2. Right click the machine that is running SQL and select the
properties menu option
3. Select the memory tab. I would probably recommend still using the
dynamic option but set a maximum