Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    220

    Angry Unanswered: SQL 2K Memory Usage Problem

    Howdy,

    I have W2K Advanced Server & SQL 2000 Enterprise. Not in cluster.

    My RAM on the W2K box is 2.4GB, but SQL 2K is only seeing 1.8 GB of this. SQL is configured to use all memory dynamically etc.

    Any suggestions why its not using all the RAM?

    Thanks,

    SG.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Capture the H/w counters like Memory, Physical disk, Process, Processor and SQL Server to asses the information.

    ALso from Task manager see what other applications accessing the box at the same time.

    BTW, any performance issues so far?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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