Need hardware suggestions for SQL 2000 server

[czidak]

I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box
currently. It is slow. I am going to be ordering 2 new servers, 1 for
ePO and 1 for SQL Server 2000. Anybody have any suggestions for the
SQL Server's hardware specs. Thanks,
Chris

[Greg D. Moore \(Strider\)]

Re: Need hardware suggestions for SQL 2000 server


"czidak" <czidak75@gmail .com> wrote in message
news:1115925307 .753935.292720@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box
> currently. It is slow. I am going to be ordering 2 new servers, 1 for
> ePO and 1 for SQL Server 2000. Anybody have any suggestions for the
> SQL Server's hardware specs. Thanks,[/color]

Not w/o knowing a lot more.

Where's your bottleneck? I/O? CPU? Not enough memory?

Have you checked the code? Using cursors? etc.

[color=blue]
> Chris
>[/color]

[czidak]

Re: Need hardware suggestions for SQL 2000 server

Currently whenever I Navigate through ePO to make changes or apply
changes it hangs. Checking Task Manager the following processes are
hogging processor and memory.

mmc.exe (epo app) Processor - 50% Memory -28 MB
sqlservr.exe Processor - 1% - 50% (only high for a second at the end
of a transaction Memory-1.5GB currently (starts off at 60 MB when
server is 1st booted up.)

The server has 2 GB of RAM and the virtual memory settings are set at
2046 - 4096

Thanks,
Chris

[czidak]

Re: Need hardware suggestions for SQL 2000 server

Also, the ePO application does not run any better right after a reboot,
so I don't think the issue is the amount of memory that sqlservr.exe
can use.

Hope this helps,
Chris