Archive for October, 2011

Finding out how much memory SQL Server is utilizing?

Many time for a new DBA  hard to find how much My Server utilising memory? Here is explained a number of ways to find the memory utilized by SQL server.

By Using Performance monitor:

 Go to Start–>Run and type perfmon . You will find the following screen where you can see the total memory used(the pages/sec) by your box.

By Using DMV:
You can Query to sys.dm_os_memory_clerks DMV to find out Memory utilization by SQL server. To see how see the following link.

http://www.sqlservercentral.com/Forums/Topic1188221-391-1.aspx

By using SQL Reports:

Right Click on SQL Server–>reports–>Standard Reports–> Memory Consumption

See the Following image.

Advertisements

Leave a comment