Not sure I get this? SQL Server will use as much memory / CPU as it needs to regardless of instances.
Remember each database is essentially an "instance" but the Server itself is global and that memory cannot be managed. If you want separate instances you will want separate boxes and separate licenses for SQL. -----Original Message----- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 12:20 To: CF-Talk Subject: SQL Server Instances and CF 7 I have a database that multiple sites are going to use and contains a substantial amount of data. Is there any way in SQL server you can make an instance of the database and allow different sites to hit the different instances keeping the sqlserver.exe from taking up too much cpu and memory? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216468 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
