I'm in a situation with a company that used to have a single server environment, so the SQL server is also a PDC. We're in the middle of upgrades, but I need to milk this server for another 6 months and performance is really suffering. I'm converting to a RAID 10 with faster drives that will definitely help some. But I'm also considering, since I've installed other controllers, demoting the server at the same time. I know I risk breaking SQL, IIS, or other services with the demotion. So my question is, from your experience, is the performance increase I'm going to get my demoting the server worth the risk ?
It's a 2003 std server (32 bit) running sql 2008.