Hi,
Shoot whoever speced the server, then replace the server with one that will cope.

Regards N Mc Donald

P.S. If the client speced & supplied the server tell them everything will be chargeable from here on in, due to inadequate supply. This helps open the budget for the new server.

If you speced & supplied, you have a large problem.

>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