Page file usage

Question

Page file usage

gary1

SSC-Insane

Points: 21152
More actions
May 7, 2010 at 3:19 pm

#218662

Hi,
We have SQL server 2005 EE x64 with SP3 and has a/a/p cluster setup. On node1, 1 sql instance and on node2 3 sql instances and node3 is passive.
RAM = 16 GB
Max Memory = 12 GB
Min memory = default
Page file size = default= 2046 MB on C drive (OS drive)
Please see the attchement. From the attchmnet, is page file usage is high?
Thanks

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

There is no attachment.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Carl Federl One Orange Chip Points: 25384 More actions · Answer 2

If these servers are dedicate to running SQL Server, you should be seeing very little paging.

A few questions:

Have the SQL Server service accounts been granted the "lock pages in memory" privilege ?

Have you restricted the size of the windows system cache?

See this KB article for some additional information: http://support.microsoft.com/kb/918483

SQL = Scarcely Qualifies as a Language

gary1 SSC-Insane Points: 21152 More actions · Answer 3

sorry,

Here is the attchment! and lock pages in memory is enabled.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

That measure is a bit out of whack. You only have a 2GB pagefile and 16GB of physical memory. The line graph is showing you the physical memory usage not your pagefile usage.

What are your Max Memory settings for SQL Server?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

gary1 SSC-Insane Points: 21152 More actions · Answer 5

What are your Max Memory settings for SQL Server?

RAM = 16 GB

Max Memory = 12 GB

Min memory = default

Lock pages in memory is enabled.

Page file size = default= 2046 MB on C drive (OS drive)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Then it all looks to be fine.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events