admin管理员组

文章数量:1567023

SQL Error log/Event ID(17890): A significant part of sql server process memory has been paged out. This may result....

When you are using SQL2005, maybe you'll meet the SQL error log like is

A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 921 seconds. Working set (KB): 2486348, committed (KB): 14694960, memory utilization: 16%%.

It may meet several times/ tens times each day and it lasts day by day.

SQL also write the error into event viewer as an information with the same information and ID is 17890.

 

As checked some document from MS. We can find the issue happened both SQL2005 32bit and 64bit version.

Here are some suggestions:

A, To assign the Lock pages in memory user right, follow these steps:

  1. Click Start, click Run, type gpedit.msc, and then click OK.

    Note The Group Policy dialog box appears.
  2. Expand Computer Configuration, and then expand Windows Settings.
  3. Expand Security Settings, and then expand Local Policies.
  4. Click User Rights Assignment, and then double-click Lock pages in memory.
  5. In the Local Security Policy Setting dialog box, click Add User or Group.
  6. In the Select Users or Groups dialog box, add the account that has permission to run the Sqlservr.exe file, and then click OK.
  7. Close the Group Policy dialog box.
  8. Restart the SQL Server service.

B, Enable AWE for SQL.

　1.　Enable AWE on SQL

   2.   Set min/max server memory

Although 64bit SQL can hand all memory automatically, but actually, we still suggest we set up memory for SQL manually.

When you take B-2 item, you should consider your total memory and all application included multi SQL instance on your server.

Please allocate memory as your application and insure that no one application exhaust all memory.

 

A and B done, our 64bit SQL hasn't reported the issue again.

 

Of course, you can refer some document:

 

http://blogs.msdn/slavao/archive/2005/04/29/413425.aspx

http://support.microsoft/kb/918483

 

 

 

posted on 2010-03-30 16:10 Jacky Xu 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://wwwblogs/JackyXu1981/archive/2010/03/30/1700716.html

本文标签： EventidsqlErrorlog

版权声明：本文标题：SQL Error logEvent ID(17890): A significant part of sql server process memory has been paged out. T... 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.elefans.com/dianzi/1725721123a1038387.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。