Page FIle high

• Sharon Kumar

  Ten Centuries

  Points: 1193

  More actions

  September 10, 2010 at 12:28 pm

  #227643

  My productions server is showing that page file utilization is very high,

  I check the processor in taskmanager pagefile is showing nearly above 80%,

  Can any one suggest wat to do if page file is high in this situation,

  What are the reasons for high usages of pagefile..??

  Thanks for your help...:)

• Mahonie007

  Grasshopper

  Points: 15

  More actions

  September 13, 2010 at 3:30 am

  #1219915

  Hey,

  I did a quick search on the website and found this:

  http://www.sqlservercentral.com/Forums/Topic461044-5-1.aspx

  I hope it will help.

  Cheers.

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 13, 2010 at 3:34 am

  #1219917

  How many page/faults per second are you seeing ?

  Is sqlserver having memory swapped out to disk ?

  ---

  
  Clear Sky SQL
  My Blog[/url]

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  September 14, 2010 at 7:50 am

  #1220683

  1) I really don't understand exactly what this means: "I check the processor in taskmanager pagefile is showing nearly above 80%". Can you give more detail?

  2) have you set a maximum memory for SQL Server?

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service