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 query
You can Query to sys.dm_os_memory_clerks DMV to find out Memory utilization by SQL server. To see how see the following query
select name,type, sum(single_pages_kb+multi_pages_kb) as MemoryKB from sys.dm_os_memory_clerks group by name,type order by memorykb desc
By
using SQL Reports:
Right Click on SQL
Server–>reports–>Standard Reports–> Memory Consumption
See the Following image.
No comments:
Post a Comment