SQL Server 2005 instance

[cbhildebrand]

I am building new database and attempting to find out the pros and cons of creating a separate instance for each application or to add each database application into the same instance and use 1 instance. Also is their a limited of the number of instance that should be on single server?

[rmiao]

Single server shouldn't have more than 16 sql instances. With multiple instances, you have to make sure each instance has proper server resources. You can use one instance to host multiple dbs in most cases.

[Island1]

Other considerations include general server population and network matters, security (of course), wheter the server can host multiple apps (with number of connections to the DB per app a consideration, too), whether using Virtual Server, etc.

Maybe we can point out more specific stuff with a little more detail ...

Thanks.

Bill

[MAK]

try to consolidate similar and related databases to gether in every instance. One database per instance is a lot of waste in resources.