praneethydba (3/5/2014)
HI,I am checking the memory utilisation from task manager.
My concern is how to & where to check the problem, as my db server memeory is increasing gradually..
Thanks
Praveen
Check this
DBCC MEMORYSTATUS
--Host wise
select hostname,count(spid) as Total_Connections,sum(isnull(memusage,0)) as MemUsage from sys.sysprocesses
group by hostname order by count(spid) desc
----------
--Database wise
select db_name(dbid) as DatabaseName,count(spid) as Total_Connection,sum(isnull(memusage,0)) as MemUsage from sys.sysprocesses
group by db_name(dbid) order by count(spid) desc
--------
http://www.mssqltips.com/sqlservertip/2304/how-to-identify-microsoft-sql-server-memory-bottlenecks/
--
SQLBuddy