Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory Usage of the SQL SERVER 2005 Expand / Collapse
Author
Message
Posted Friday, August 16, 2013 3:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 26, 2013 8:17 AM
Points: 7, Visits: 13
Hello Everyone,

I'm trying to get the Memory Usage of the SQL SERVER (Total Memory Usage) and available free memory of the system using the query which I got on the internet. The query seems to work for SQL SERVER 2008 but doesn't work on SQL SERVER 2005. The reason being "dm_os_sys_memory" and "dm_os_process_memory " are not available in SQL SERVER 2005.

Note: This should be achieved through queries only, as I don't have permission on machine to use permon and other features provided by windows.

The below mentioned query works in SQL SERVER 2008, please suggest if there is an alternate way

select A.total_physical_memory_kb/1024 as Total_Memory,
A.available_physical_memory_kb/1024 as Free_Memory,
B.physical_memory_in_use_kb/1024 as SQLServer_Memory
from master.sys.dm_os_sys_memory A, master.sys.dm_os_process_memory B;

Regards,
Prakasha N
Post #1485053
Posted Tuesday, August 20, 2013 11:18 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:38 PM
Points: 522, Visits: 240
You can achieve this by using DBCC commands. Please refer post below:

How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005
http://support.microsoft.com/kb/907877
Post #1486377
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse