<< SQLCLR - AppDomain State | SQLCLR - Tasks >>

SQL - Memory Usage

By at October 12, 2007 07:12
Filed Under:

select 
    type,
    sum(virtual_memory_reserved_kb) as [VM Reserved],
    sum(virtual_memory_committed_kb) as [VM Committed],
    sum(awe_allocated_kb) as [AWE Allocated],
    sum(shared_memory_reserved_kb) as [SM Reserved], 
    sum(shared_memory_committed_kb) as [SM Committed],
    sum(multi_pages_kb) as [MultiPage Allocator],
    sum(single_pages_kb) as [SinglePage Allocator]
from 
    sys.dm_os_memory_clerks
group by type

Tags:

Comments (12) E-mail Kick it! DZone it! del.icio.us Permalink Post RSS

Comments

2/26/2010 4:25:14 PM #

Should I get a VPS? At the moment I am using shared hosting but they keep disabling my account because of high server overload. Im getting about 4,000 unique views a day. What brand should I get?

Fatcow Reviews | Reply

3/2/2010 2:01:36 PM #

WoW Mobiles is awesome! I get free mobile service with t-mobile because I refered 3 people to wow. You can too!

wow mobiles | Reply

3/14/2010 6:49:46 AM #

Hvala vam za dobar post puno hvala

general electric cooktop | Reply

3/17/2010 4:33:35 PM #

Thank you so much for this article. I am sure it will help me in the future.

Chapel Hill Real Estate | Reply

3/20/2010 11:42:58 PM #

I am sure it will help me in the future.

cheap prom Dresses | Reply

4/27/2010 1:45:43 PM #

I would like to thank you for the endeavors you have made in publishing this article. I am trusting the same best work from you in the future as well. In fact your fanciful writing abilities has inspired me to start my own blog now. Genuinely the blogging is spreading its wings rapidly. Your write up is a fine example of it.Thanks again for sharing this free online

How to get ripped | Reply

5/10/2010 5:33:10 AM #

In the aftermath of investing many hours online eventually We've identified an individual whom actually does know what they are speaking about thanks a lot so much really great post.

Article Directory | Reply