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


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.

Thanks!!

Demoting 2003 PDC with SQL

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.