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.*********@chello.nl> wrote in message news:<3E**************@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