dbTalk Databases Forums  

Need hardware suggestions for SQL 2000 server

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Need hardware suggestions for SQL 2000 server in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
czidak
 
Posts: n/a

Default Need hardware suggestions for SQL 2000 server - 05-12-2005 , 02:15 PM






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


Reply With Quote
  #2  
Old   
Greg D. Moore \(Strider\)
 
Posts: n/a

Default Re: Need hardware suggestions for SQL 2000 server - 05-12-2005 , 11:22 PM







"czidak" <czidak75 (AT) gmail (DOT) com> wrote

Quote:
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.


Quote:
Chris




Reply With Quote
  #3  
Old   
czidak
 
Posts: n/a

Default Re: Need hardware suggestions for SQL 2000 server - 05-17-2005 , 10:48 AM



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


Reply With Quote
  #4  
Old   
czidak
 
Posts: n/a

Default Re: Need hardware suggestions for SQL 2000 server - 05-17-2005 , 10:52 AM



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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.