-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 We are ending a project with a client and have tuned their web server (2xPIII 700 Xeon, 1Gb RAM, CF Enterprise 4.5.1, Spectra 1.5) to within an inch of it's life. As far as we're concerned, the web server running the Spectra app now behaves beautifully under pretty much all circumstances.
However, there are occasions when the search facility on the site is run (a combination of Verity and direct SQL into the CODB) which causes problems at the DB server end (2xPIII 700 Xeon, 512MB RAM, SQL Server 2000) resulting in the CPUs maxing out and the SQL server locking up. At this point, the queued requests on the web server start spiking and everything goes pear-shaped at both ends. Can anyone offer some advice on appropriate practises/tasks for tuning the SQL server end, bearing in mind we are not confident the client has a SQL Server competent DBA available and we will have to do the work ourselves (me probably). I am no DBA, I am your classic code cutter. Steve ======================================================== Stephen Collins, Technical Consultant - ACIS (Australia) Allaire Certified ColdFusion 5 Developer Work : [EMAIL PROTECTED] Personal : [EMAIL PROTECTED] ICQ UIN : 56321783 Yahoo! : trib "Before I got into triathlon, I was a normal person." -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.5.8 iQA/AwUBO7OXQ365o/U9+lJVEQKcAgCgx0oVwb6DjEIHeRIOPmn6rS0/ms4AnirV YZW+/I61pE8GUK3mro0am5m5 =NDYV -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
