Problem solve Get help with specific problems with your technologies, process and projects.

SQL Server 2000 memory settings that work

Having trouble monitoring memory usage in SQL Server 2000? Apply these memory settings through SQL Server Performance Monitor.

How can I find thedetermine the memory usage of SQL Server 2000? Every time I query the sysperfinfo table in the master database, I get the ctr value on the Target Memory and Total Memory similar to what I configured in the SQL properties maximum memory settings. For example, I have set my SQL Server Dynamic memory to use 6144 MB, but how can I tell that it is really using that memory?
When Address Windowing Extensions (AWE) is enabled on your SQL Server, Windows does not report back the correct amount of memory used. You can monitor the memory usage of your SQL Server in Performance Monitor by monitoring the SQLServer:Memory ManagerTotal Server Memory (KB) performance counter.

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.