Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Performance problem
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
SQL Performance problem
Divers
Thread ID:
00890131
Message ID:
00890131
Vues:
52
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
Fred Besterwitch, MCP

The harder you work. The luckier you get.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform