SQL SERVER target memory vs total memory

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL SERVER target memory vs total memory

SQL SERVER target memory vs total memory

Rate Topic

Display Mode

Topic Options

Author

Message

sql.lanka

Posted Wednesday, October 24, 2012 4:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:21 PM
Points: 3, Visits: 414

Hi All,

I ran this query
SELECT object_name,counter_name,instance_name, (cntr_value/1024) as Memory_in_MB, cntr_type FROM sys.dm_os_performance_counters

WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')

some servers Total server memory = target server memory --- is this normal ?

Or Total server < target server ,please let me know which values are preferrable

Post #1376706

GilaMonster

Posted Thursday, October 25, 2012 1:46 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:38 AM
Points: 37,677, Visits: 29,931

Target = total, stable memory allocation
Target > total, SQL's still allocating memory and building up the caches.

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 #1376825

« Prev Topic | Next Topic »

Permissions