after monitoring the above server for several weeks and with the addition of the monitoring i placed, this problem wasnt as easy or as straight forward as simply saying upgrade hard ware on the database server.

The problems were beyond the scope of the database, and we realised there were other IIS related issues also. So as it stands the occassional restart of services for seibel and also the database and IIS resolves issues temporarily.

IIS is 5.0 and the way that the app is written querying data via cursors it is just so badly written that i'm lost for words.

I've suggested the company consider migrating data to a new CRM package. but as they are using a custom made bespoke application management are not supporting this call.

I dont think anyone out there can advise. but its certainly been an interesting road for beefing up my perfmon skills.