Total Server Memeory & Total Target server memory

Question

Total Server Memeory & Total Target server memory

rambilla4

SSCrazy Eights

Points: 8715
More actions
July 27, 2009 at 10:04 am

#156025

Hi,
We have SQL Server 2005 EE 64 bit on Windows 2003 EE 64 bit and it is a Active/Passive cluster. We 16 GB Memeory and I have configured 12 GB as max memory. We have running only sql server with Antivirus. No other applications on this cluster.
Now I have setup performance counters to see how memory is utilizing. I always getting Total Server Memeory & Total Target server memory equal to 12582912 KB (12 GB). Is this means any memory pressure on my SQL Server?
What should be the relation between Total Server Memeory & Total Target server memory?
thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

It doesn’t necessarily mean that you have memory pressure. You need to check other counters such as page life expency, page reads/sec, page write/sec (all of them are under sqlserver-buffer manager), physical disk – avg disk queue length. There is a good chance that other posters will suggest some additional counters.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

Hi Rambilla,

Your SQL Server is experiencing memory pressure.

If Total Server memory is far below Target server memory then it means that the server is NOT experiencing memory pressure and vice versa.

Thank You,

Best Regards,

SQLBuddy

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 3

I agree that Total Server Memory > Total Target Server Memory indicates memory pressure, but what I've read is that if they are equal there is probably no memory pressure.

You need to look at indicators such as buffer page lifetime to make a more informed decision.

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 4

I'm setting up Perfmon counters for clustered sql server instance.

Node1: SQL1

Node2: SQL2

Virtual Server: SQLVS

Now, in perfmon, when adding counters should I select SQL1 OR SQLVS?? Please see the attachment..

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 5

My guess would be you want to monitor the active node specifically.

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 6

Our active node is SQL1. So do I need to select SQL1 OR the Virtual server name SQLVS?

which one you guys select in setting up perfmon counters? Virtual server name OR Active node?

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 7

Hi Rambilla,

AFAIK, you should select your node name for the option " Select counters from computer" and then you can select the counters related to the Virtual SQL Server instance by using the option " Performance Object". Once you select the required performance object, you can then select an appropriate counter.

i.e.

Select counters from computer : SQL1

Performance Object: MSSQL$SQLVS:Databases etc.,

Thank You,

Best Regards,

SQL Buddy