>Larry, did you test a slow machine with SQL Server 2000?
>If I place 128 or more can this server also do IIS as Web Server?
>
>>>I am running SQL Server 7.0 on NT4.0 with a Pentium Pro 200 64MB of Ram. This is for test purposed only.
>>>
>>>Can this machine be upgraded with SQL Server 2000?
>>>If not what is the minimum equipment?
>>
>>You need more memory. The processor power is enough. Upgrade to at least 128Mb; more if you can get it cheap enough.
As Alex said, memory is the key.
My test machine has NT 4 SP5 runnning IIS4 and SQL Server 2000. All this is running on a Pentium MMX 150 MHz with 128 MB RAM. Once I put the memory in, most of my problems went away. I was getting Low Memory messages 4 or 5 times a day. SQL Server 2000 has been running for about 4 months. Before that, SQL Server 7 and the rest was running for 2 years.
BTW. this machine also runs Proxy Server and I have no complaints about response time.
Regards.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao