SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Senior Member
    Join Date
    May 2001
    Posts
    265
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    SQL Server Memory Usage.

    One thing I recently learned is that SQL Server is designed to take as much memory (eventually) as available to it which is 2GB max for sql2000 std edition.
    I ran some test and shared results with one of our clients and they noticed that all the test we ran the DB server memory stayed at 2GB start to finish with very minor differences (looking at global OS counter memory commited etc).
    My question is that are we hitting the SQL memory usuage limitation which is suppose to be 2GB, or how do we find out if all the memory SQL has aquired is actually is in use. When I look at sql memory counters ()
    Memory Grants Pending: The current # of process waiting for a workspace memory grant.
    (shows 0)
    Target Server Memory (KB): The total amount of memory that SQL Server can consume. (shows 1.6GB)
    Total Server Memory (KB): The total amount of memory that SQL server is using.(reaches to 1.6GB in 5 minutes)
    Memory Commited bytes (reaches 2 GB in 5 minutes)

    Do we have a problem?
    Environment: We are using SQL2000 Std Edition. OS MS Windows Server 2003 Standard Edition with 4 GB Ram.

  2. #2
    Senior Member
    Join Date
    Dec 2000
    Location
    Phoenix, AZ
    Posts
    371
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL Server Memory Usage.

    I'm not exactly clear on your situation but my first instinct is that you may be looking at the total amount of memory that is allocated for SQL Server to use.

    In other words ..... SQL Server can use "up to" 2GB of memory if needed but it is probably not currently using all of it initially.

    The Memory Commited bytes would be correct at 2 GB because this memory on the server is committed to SQL Server.

    Hopefully I just didn't cause more confusion.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 12.50%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 04:10 AM.

Copyright BetaSoft Inc.