Multiple Instances of SQL Server
An option to virtualization is multi-instancing. With multi-instancing, multiple copies of SQL Server can be run concurrently in a single instance of an OS. Multi-instancing for SQL Server 2008 can take place both in a virtual environment or in a physical environment. Although multi-instancing offers a relatively high degree of isolation between copies of SQL Server 2008, this isolation takes place at the application level (instead of at the OS level).
In SQL Server 2008, the Workgroup and Standard Editions now allow you to run any number of instances of the server software in one physical or virtual operating system environment on the licensed server. Previously, only the Enterprise Edition of the server license ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
