Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Sunday, July 17, 2016 9:28 PM
Points: 110, Visits: 1,187
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: Friday, July 15, 2016 5:25 AM
Points: 6,134, Visits: 13,619
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: Sunday, July 17, 2016 9:28 PM
Points: 110, Visits: 1,187
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