Memory Question

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Memory Question

Memory Question

Rate Topic

Display Mode

Topic Options

Author

Message

robert.nesta123

Posted Saturday, February 16, 2013 8:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 23, 2013 1:09 PM
Points: 9, Visits: 19

Quick one I probably should know this but....

Scenario

1 SSRS server with 16b GB mem.
SQL set to MAX 10GB
SSAS set to a MAX of 80%.

task manager shows mem running @ 98%.
Within TAsk Manager SQL is only using 0.5GB
SSAS using 3.5 GB

So my question is even though SQL is not using it's maximum limit. Does it reserve the memory and not allow any other processes to use it.

Post #1420894

GilaMonster

Posted Saturday, February 16, 2013 11:36 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

Don't use Task Manager to check SQL Server's memory usage. It will often display completely incorrect values.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1420910

robert.nesta123

Posted Saturday, February 16, 2013 12:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 23, 2013 1:09 PM
Points: 9, Visits: 19

I thought taht was only for Virtual Servers, I normally use Target Server Mem and Total Server mem. But recently have read many conflicting interpretations of the values returned.

What is the best way to see what mem SQL is currently using.

DBCC Memorystatus?

Post #1420915

GilaMonster

Posted Saturday, February 16, 2013 1:04 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

No, nothing to do with virtual servers at all. How SQL allocates and what Task Manager doesn't show

Best way - target and total server memory

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1420921

robert.nesta123

Posted Saturday, February 16, 2013 1:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 23, 2013 1:09 PM
Points: 9, Visits: 19

I think this will do the trick
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 [SinlgePage Allocator]
from sys.dm_os_memory_clerks
group by type
order by 8 desc

Post #1420924

opc.three

Posted Monday, February 18, 2013 7:15 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:47 PM
Points: 6,694, Visits: 11,708

Or is you just want to know the total memory used, like what you were looking for in Task Manager:

SELECT  cntr_value AS [Total Server Memory (KB)]
FROM    sys.dm_os_performance_counters
WHERE   counter_name = 'Total Server Memory (KB)';

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1421210

« Prev Topic | Next Topic »

Permissions