I've only done extremely simple read-only SQL Server through VFP, but details like that never stopped me before...

So the situation degrades over time.
Are you confident that it is at the SQL end of things?... If so, I'd be looking for something that is failing to 'release' resources in a timely fashion. Do connection handles add up? Are you never COMMITting transactions?

Good luck

>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 using SQL 2000.
>
>>Fred,
>>
>>What CPU speed is in the box? What O/S? What SQL release? I can check on Monday with our DBAs and see what class of machines we use, but I think the min is a dual CPU. I know we have at least one 8-CPU box running on one of our larger hit systems.
>>
>>Have you looked at the tuning wizard and see if it's recommending any indexes to be added? Have you looked at the Query plans for your slower queries to see if lots of table scans are being used?
>>
>>>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.