MS SQL uses 100% of my 2 CPU machine

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 NetherlandsUnder 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@.chello.nl> wrote in message news:<3EFC0E13.5010809@.chello.nl>...
> 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|||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@.chello.nl> wrote in message news:<3EFC0E13.5010809@.chello.nl>...
> 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|||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

MS SQL 7 CPU Usage Problem

Hi all,

We have a VB App and MS SQL 7 driven web site running on a dual processor
server.

Lately, we've been suffering a problem whereby MS SQL Server seems to
consume all available CPU power. The web application grinds to an unusable
slow speed when this happens, and we tend to reboot the server in an attempt
to fix.

We have experimented with moving SQL Server onto just one processor and
turning off the option 'Boost SQL Server priority on Windows NT'. This did
not seem to help - so I have moved SQL Server back on to two processors.

We are running Windows 2000 Service pack 3. Any advise on how to manage CPU
usage with MS SQL Server and a VB web app on the same box would be much
appreciated.

Cheers,
Jerome.

jerome@.lonres.comHi Jerome,

exceessive CPU usage by MSSQL usually indicates one or more inefficient
Queries being run. Try to track down these Queries and see whether they
can be optimized (maybe another Index could help?).

Second, in your App, make sure that frequently used Queries are
parameterized. MSSQL tends to create execution plans for every single
ad-hoc Query which puts quite a load on both Memory and CPU.

hth
GB

MS SQL 2005: Performance – normal CPU vs CPU DUO/4 CORE

Hello,Is performance of web application (ASP.NET + SQL Server 2005 Wrg edition + Win Server 2003 Web edition) running on server with one core duo/4 CPU generally comparable to the performance of the same application running on the same server with 2/4 physical CPU's?Thank you for your ideas!Jan

Hi Jan,

Of cource on a multiple core CPU, the ASP.NET and SQL Server performance will be better than a single core CPU.

Because the IIS and SQL Server will optimize the performance according to the core units. In this case, better performance is gain.