Windows Server 2000/2003 Thread, SQL Server Express 2005 Memory Limit per instance? in Technical; Is the 1GB buffer pool limit imposed by SQL Server Express 2005 on a 'server wide' basis (ie. the limit ...
30th April 2010, 08:17 AM #1
SQL Server Express 2005 Memory Limit per instance?
Is the 1GB buffer pool limit imposed by SQL Server Express 2005 on a 'server wide' basis (ie. the limit applies to all instances, so they all share a 1GB buffer pool) or is it per instance (so each instance gets a 1GB buffer pool)?
I've yet to find a site with clear advice on this particular issue.
IDG Tech News
30th April 2010, 01:27 PM #2
I had always assumed that it was per instance, did some checking and that does appear to be the case. This is why my web filtering and app servers run multiple instances.
MS-SQL Express 2005/2008 multi instance CPU and memory utilization - Stack Overflow
Securing Your SQL Server 2005 Express Edition Server
Installing an independent instance
During setup, if you set the instance name to your own value, the installation program creates an entirely independent version of SQL Server Express. This instance has its own Master database, its own files, DLLs, and memory footprint and its own SA password. Each independent instance starts a separate SQL Server service (program) that consumes CPU cycles, in addition to any other instances that might be installed. While this approach gives you more security in the sense that only those granted access to this instance can see the databases it manages, it's more expensive to implement and maintain. That's because each instance duplicates DLLs, caches, and other in-memory structures.
Thanks to SYNACK from:
localzuk (30th April 2010)
By UkDraxion in forum Wireless Networks
Last Post: 10th November 2009, 10:37 AM
By Heebeejeebee in forum MIS Systems
Last Post: 7th April 2009, 03:19 PM
By techie08 in forum Windows Server 2000/2003
Last Post: 12th February 2009, 11:06 PM
By contink in forum Windows
Last Post: 14th May 2008, 02:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread