PASS 2006 - Application partitioning
This mornings first session was an interview with the
SQLOS developers. This was a great session and a real eye opener into the work
that has gone into the SQLOS in SQL 2005, to support NUMA.
One aspect of NUMA that I was unaware was the ability to partition server to
different applications. What does this mean. Well you can assign a TCP port to a
NUMA node and then get your application to connect to SQL using that port. Your
application will then only use the resources for that node.
That means you can have dedicated resources for each application that uses
your server.
This is the BOL page that explains how to do it.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/07727642-0266-4cbc-8c55-3c367e4458ca.htm
You of course have to have a NUMA box to be able to do this.
-