Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Performance problem
Message
From
29/03/2004 16:34:47
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00890132
Message ID:
00890601
Views:
32
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform