check the physical memory in use by sql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » check the physical memory in use by sql

check the physical memory in use by sql

Rate Topic

Display Mode

Topic Options

Author

Message

mah_j

Posted Wednesday, August 15, 2012 7:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:07 AM
Points: 85, Visits: 973

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

george sibbald

Posted Wednesday, August 15, 2012 7:08 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 5,266, Visits: 11,197

query sys.dm_os_performance_counters

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

Post #1345251

mah_j

Posted Wednesday, August 15, 2012 7:15 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:07 AM
Points: 85, Visits: 973

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 »

Permissions