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

check the physical memory in use by sql Expand / Collapse
Author
Message
Posted Wednesday, August 15, 2012 7:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:36 PM
Points: 108, Visits: 1,087
HI


I use sys.dm_os_process_memory in sql server 2008 for checking the physical memory in use
Is there any way I could script to check the physical memory in use by sql for the server running sql 2005?
Post #1345249
Posted Wednesday, August 15, 2012 7:08 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:28 AM
Points: 5,850, Visits: 12,596
query sys.dm_os_performance_counters

---------------------------------------------------------------------

Post #1345251
Posted Wednesday, August 15, 2012 7:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:36 PM
Points: 108, Visits: 1,087
Thanks

but it does not show large_page_allocations_kb and locked_page_allocations_kb
if they are available.
Post #1345257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse