<div>
Resource govenor does not handle instances.<br />
Therefore I would recommend the same instance, resource govenor for handling resources and different san luns for the oltp / olap databases.<br />
The key is going to be CPU and this can be controled with resource govenor.<br />
<br />
Regards Marten
</div>


Resource govenor does not handle instances.
Therefore I would recommend the same instance, resource govenor for handling resources and different san luns for the oltp / olap databases.
The key is going to be CPU and this can be controled with resource govenor.

Regards Marten

<div>
Need further assistance, or clarifications?<br />
<br />
Regards Marten
</div>


Need further assistance, or clarifications?

Regards Marten

<div>
<div class="content wysiwyg-content">
I am setting up a SQL 2008 R2 two node cluster for an existing database server that currently supports 6 databases (30-35 gb total), most of which are OLTP type databases supporting front end web based apps that receive about a million hits a year. One of the databases is an OLAP type and I am wondering if by creating two SQL Instances, one for OLTP and one for OLAP, I might better manage resource allocation between the OLTP and OLAP databases. Priority would be given to the OLTP databases, which are more critical to operations. Additionally, I am wondering if this approach would work for a given OLTP database that required priority access to resources. As I also have the opportunity to configure the SAN from scratch I would be able to allocate dedicated disk resources to the individual instances.
</div>
</div>


I am setting up a SQL 2008 R2 two node cluster for an existing database server that currently supports 6 databases (30-35 gb total), most of which are OLTP type databases supporting front end web based apps that receive about a million hits a year. One of the databases is an OLAP type and I am wondering if by creating two SQL Instances, one for OLTP and one for OLAP, I might better manage resource allocation between the OLTP and OLAP databases. Priority would be given to the OLTP databases, which are more critical to operations. Additionally, I am wondering if this approach would work for a given OLTP database that required priority access to resources. As I also have the opportunity to configure the SAN from scratch I would be able to allocate dedicated disk resources to the individual instances.

Using SQL Instances to manage resources for a combined OLTP/OLAP server

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

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.