SQL 2000 Vs IIS

[SilviaS]

Situation:
Have a server running windows 2000 iis 5.0 and sql 2000.
They are on a internal network running a helpdesk application connectiong to the sql database.
All installed on single partition with Raid 5.
The system keeps grinding to a halt every couple of days.
I am going to running some tests with performance monitor ut in general can the current set up be improved
ie: add another partition for the databases to be sat on etc?
or is the current config ok?
cheers

 

[compuveg]

Theoretically there shouldn't be any problem having all that on one logical RAID partition. However, I've seen it recommended, for a number of reasons, that your OS files, application files, and data files all reside on different logical volumes. This is regardless of what OS you're running.

My personal reasoning for this is to give me the opportunity to have a mirror drive that I can rotate a drive out of. That way if I patch in the daytime, I just pull one drive, patch the other, and if it blows up I can immediately swap drives and its like nothing happenned. Its also an easy, if not expensive, backup.