var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL 2K Memory Usage Problem
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?
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?