Hi,
I think you forgot to tell us that it is only an SATA drive. With a database of this size you will be experiencing bottlenecks on both the CPU & HDD especially if you run a lot of intensive queries which I think is the case.

Your problem is going to compound at an ever increasing rate, until you upgrade the hardware.

Minimum Specs to future proof are:
Quad Xeon Intel Motherboard - use hyperthreading if possible i.e. 8 way OS
Raid 10 - for performance reasons
1GB NICS

In a nutshell you can't run a database of this size on an entry level server.

You may have won the job by under spec'ing the hardware, this is why you are paying the price now.

Regards N Mc Donald

P.S. Don't use the server for anything else except the database i.e. No word processing, email etc

>The Indexes work fine. I have used the Index tuning wizard. The SQL server just seems to hang when many people are using it. If we reebot and start again it works then after about an hour it goes slow and stops responding. This happens especially when there are many writes to the Server. When not many people are using it the same queries execute without a problem and the performance is very good. Could there be a Limit on number of users on SQL Server ? how can we improve multi user performance
>
>The Database is about 25 GIG and the Log is about 9 gig
>The system is runing a P4 2.8 on Windows server 2003
>
>
>>Are you using SQL stored procedures to access the data? How about the SQL Server indexes... are they tuned correctly?
>>
>>>Hi Guys,
>>>I have one database with about 60 tables. One table has over 20 Million records and groing at 600,000 per month. I have another 5 tables with about 5 million records in each. The Sql Server is currently running on a dell Server 1 GIG Ram and 256BG HDD. No Raid. Using VFP connecting with ODBC. The System is struggling at the moment when we run queries or if there is a lot of writing to the database some of the machines running VFP freezes.
>>>
>>>Is it possible to make it faster by
>>>1. increasing the number of CPU's or RAM
>>>2. Split the Database into two and have them sitting on different servers. How would I do my queries with databases sitting on 2 different servers.
>>>
>>>How can I make it work faster ?
>>>The client are losing their patience.Can anyone help me.
>>>
>>>TIA