SQL Server Instancing: Should I use multiple instances or databases?

Posted by Spence on Server Fault See other posts from Server Fault or by Spence
Published on 2009-07-11T11:38:03Z Indexed on 2010/03/12 1:17 UTC
Read the original article Hit count: 342

Filed under:

sql-server

|

instances

|

Performance

I have a reasonable server connected to a SAN which will be running SQL servers for multiples of the same application.

There are no security issues with one application being able to read anothers database.

We are unfortunately in 32 bit windows as well.

I'm of the opinion that it would be better to use one instance on the server, enable AWE so that the server instance can use almost all of the ram we have and then run each of the databases in the one instance.

However I've been overruled by the gods of the IT department on this one, so I'm really curious to hear your thoughts on this. From a performance point of view, am I incorrect that one instance of SQL is better than two?

I know that we could do some failover stuff, but doing that on one blade only seems like overkill to me..

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about instances

Recreating OMS instances in a HA environment when instances on all nodes are lost

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle highly recommends deploying EM in a HA environment. The best practices for HA deployments, backup and housekeeping of your Enterprise Manager environment are documented in the Oracle Enterprise Manager Advanced Configuration Guide. It is imperative that there is a good disaster recovery plan… >>> More
creational pattern for instances depending on multiple subclass instances

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a problem, for that I was not able to identify a suitable design pattern. I want to create instances depending on a given type that has been passed to a factory method. What I am doing until now is the following: T create(SuperType x) { if (x instanceof SubType1) { // do some stuff… >>> More
Purging SOA Instances

as seen on Oracle Blogs - Search for 'Oracle Blogs'
All, If your running Oracle SOA suite in a high thoughput environment you'll probably discover that your dehydration store will get large, and larger if you dont manage it properly. There are many strategies in manging how to purge this, and this document recently released by Oracle details them… >>> More
Name a Byobu session?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Is there a way to create identifiable Byobu sessions so that when I've got multiple sessions running, the byobu-select-session menu gives me a list of sessions I can recognize, as opposed to non-descript tmux port numbers? In an ideal world, it would be great to be able to both start a session giving… >>> More
2nd instance of Firefox does not obey GTK2 customizations

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Hi On Ubuntu 10.10 I started a 2nd instance of Firefox using the command: $ firefox -ProfileManager -no-remote & Created a new profile and everything works smoothly except for the fact that this instance of FF does not obey by GTK2 customizations that I have placed in ~/.gtkrc-2.0 Moreover… >>> More