Monday, March 26, 2012

Need hardware suggestions for SQL 2000 server

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"czidak" <czidak75@.gmail.com> wrote in message
news:1115925307.753935.292720@.z14g2000cwz.googlegr oups.com...
> 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,

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.

> Chris|||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|||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

No comments:

Post a Comment