<div>
Part of the issue &quot;could be&quot; if there really is 36 GB of RAM in the server. &nbsp;Server 2008r2 which SBS 2011 is based on, has limit of 32gb of Ram. &nbsp; While a single partition is not the best configuration, it's not impossible. &nbsp;Is this a raid 1 or raid 5 partition? &nbsp;What kind of drive controller? &nbsp;yes a separate partition on a good controller could help. &nbsp;But the real key is running Perfmon to find the real culprit
</div>


Part of the issue "could be" if there really is 36 GB of RAM in the server.  Server 2008r2 which SBS 2011 is based on, has limit of 32gb of Ram.   While a single partition is not the best configuration, it's not impossible.  Is this a raid 1 or raid 5 partition?  What kind of drive controller?  yes a separate partition on a good controller could help.  But the real key is running Perfmon to find the real culprit

<div>
thanks Ryan. just moving email off the server was a tremendous improvement. &nbsp;Disabled the exchange services with no ill side effects. <br />
<br />
great info!
</div>


thanks Ryan. just moving email off the server was a tremendous improvement.  Disabled the exchange services with no ill side effects.

great info!

<div>
<div class="content wysiwyg-content">
I've inherited an SBS 2011 server. &nbsp; All services are installed on a single partition (C:) &nbsp;The the customer does heavy sql work using Thompson Reuters CS. &nbsp;This is a practice management solution for CPAs.<br />
<br />
With 36 Gb RAM, everything is hideously slow and 10 users have trouble accomplishing the simplest of tasks.<br />
<br />
Does it make sense to move the SQL instances to a separate RAID volume for better performance? (I know this is a broad\general question, but they are not on a budget that would allow them to replace the server with the correct environment.)<br />
<br />
Thanks,<br />
Craig
</div>
</div>


I've inherited an SBS 2011 server.   All services are installed on a single partition (C:)  The the customer does heavy sql work using Thompson Reuters CS.  This is a practice management solution for CPAs.

With 36 Gb RAM, everything is hideously slow and 10 users have trouble accomplishing the simplest of tasks.

Does it make sense to move the SQL instances to a separate RAID volume for better performance? (I know this is a broad\general question, but they are not on a budget that would allow them to replace the server with the correct environment.)

Thanks,
Craig

SQL Performance on SBS 2011

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

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.