Q

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.
This was first published in August 2007

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close