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