+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,096
    Thank Post
    511
    Thanked 2,310 Times in 1,786 Posts
    Blog Entries
    24
    Rep Power
    803

    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.

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,691
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    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.

  3. Thanks to SYNACK from:

    localzuk (30th April 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 10th November 2009, 10:37 AM
  2. Install SQL 2005 Full over 2005 Express (other instances)
    By Heebeejeebee in forum MIS Systems
    Replies: 4
    Last Post: 7th April 2009, 03:19 PM
  3. SQL Server 2000/2005
    By techie08 in forum Windows Server 2000/2003
    Replies: 6
    Last Post: 12th February 2009, 11:06 PM
  4. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •