Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Performance problem
Message
De
29/03/2004 16:34:47
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00890132
Message ID:
00890601
Vues:
31
Hi Fred,

You must not seen my correction message. "Please do not send the logs to me".
To give you an idea, our current server log counter file is 20GB in size for a one week period. A file this big would stop our email server and get me killed ļ . I recommend that you create a log counters database so you can analyze the data with statistical process to summarize the data into core areas of processor, memory, hard drive performance, and network access. Then based on actual data, make controlled changes to the server and monitor the corresponding results. This way you can recommend / implement intelligent changes (both hard ware and software) to the system. Another great idea is investigating what services are performed on this box. I believe Dan LeClair mention this.

IF you want some assistance with understanding, the logs after they are create just email me at AndyE@usrisk.com and we will look at the individual counters.


Andy
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform