SQL Server Performance

SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Apr 4, 2008.

  1. Anonymous New Member

    This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if there isn’t any resource contention (from your pre-installation testing &amp; analysis) and there is enough of each resource to go around, then there is usually no reason to set any restrictions on the server resource. The Operating System and SQL Server will share the available resources without any problems. However, if there is any resource contention, then depending on the resource...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2008/04/04/3961.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3961" width="1" height="1">

Share This Page