Thanks Jeff. I just needed you to kick my a** to do it :-))) Michael
>>> [EMAIL PROTECTED] 07/18/02 10:42AM >>> You're probably right; why dink around with it. Just bite the bullet and reinstall the OS. In the time you have taken to read and respond to posts regarding this issue, you could have had the OS reinstalled and the web server back up and running. :-) -Jeff -----Original Message----- From: Michael Cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 10:35 AM To: [EMAIL PROTECTED] Subject: [sambar] Increasing dbms Performance {07} I have 2 volumes, and I am only using 30% on each volume. I would suspect that a badly fragmented disk would cause overall system degradation. But my previous e-mail describes that only the dbms component of Sambar is experiencing poor performance. Without even doing the SQL through a dbms STM script, the ISQL utility in Sambar shows that throughput never exceeds 3.5k/sec. I have MDAC 2.6 installed. Another PC with the same OS, Sambar version/build and MDAC is lighting fast. I think I'm looking at a re-install of the OS and Sambar :-(( Michael >>> [EMAIL PROTECTED] 07/18/02 10:14AM >>> Make sure you have adequate space available on all volumes. The NT-based OSes begin to degrade badly when you dip below 15-10% free space. Run a chkdsk /f on the volumes to make sure they are clean. Run a third-party defrag utility (e.g. Perfect Disk, Diskeeper) - fragmentation is a killer. Are you using the most current MDAC? (2.7 RTM 2.70.9001.0) http://www.microsoft.com/data/ -Jeff ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/ ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
