+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, SIMS and SQL Express in Technical; So MS SQL Express only uses 1G of memory ( plus the program and some bits and pieces ) so ...
  1. #1

    Join Date
    Jan 2008
    Posts
    48
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13

    SIMS and SQL Express

    So MS SQL Express only uses 1G of memory ( plus the program and some bits and pieces )
    so has anyone got any idea why ours is at 1,490,000 and slowly climbing ?

    Ta

    M

  2. #2
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,040
    Thank Post
    22
    Thanked 175 Times in 121 Posts
    Rep Power
    51
    Is 1,490,000 the size of the mdf file on the hard disk or the amount of RAM the SQL service is using?

  3. #3

    Join Date
    Jan 2008
    Posts
    48
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13

    SIMS and SQL Express

    the size of the sql process in memory

    M

  4. #4


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,657
    Thank Post
    350
    Thanked 789 Times in 710 Posts
    Rep Power
    344
    1 GB RAM: The 1 GB RAM limit is the memory limit available for the buffer pool. The buffer pool is used to store data pages and other information. However, memory needed to keep track of connections, locks, etc. is not counted toward the buffer pool limit. It is therefore possible that the server will use more than 1 GB in total, but it will never use more than 1GB for the buffer pool. This limitation prevents the use of Address Windowing Extensions (AWE) with SQL Server Express.
    Link

    Maybe this helps explain?

SHARE:
+ Post New Thread

Similar Threads

  1. VS 2K8 Express Editions
    By PiqueABoo in forum Coding
    Replies: 1
    Last Post: 25th November 2007, 11:40 PM
  2. SIMS SQL upgrade. To Express or not to Express?
    By woody in forum MIS Systems
    Replies: 5
    Last Post: 16th October 2007, 04:34 PM
  3. Domain Express
    By Andi in forum Jokes/Interweb Things
    Replies: 2
    Last Post: 4th May 2007, 07:40 AM
  4. Anyone recommend Smoothwall Express?
    By OverWorked in forum *nix
    Replies: 15
    Last Post: 26th January 2006, 11:37 AM
  5. Outlook Express mailstore.
    By Dos_Box in forum Windows
    Replies: 3
    Last Post: 1st July 2005, 01:58 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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