SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server not using memory
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2019 Posts

Posted - 05/22/2013 :  13:32:30  Show Profile  Visit jackv's Homepage  Reply with Quote
Could you check a) the start up account for the SQL Server Instance b) check to see if that account is using Lock Pages in Memory .
If the start up account is a Local Administrator , than by default it gets lock pages in memory. If the SQL Server is using lock pages in memory , it doesn't show all memory in Task manager.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

andykn
Starting Member

12 Posts

Posted - 05/22/2013 :  17:09:09  Show Profile  Reply with Quote
quote:
Originally posted by jackv

Could you check a) the start up account for the SQL Server Instance b) check to see if that account is using Lock Pages in Memory .
If the start up account is a Local Administrator , than by default it gets lock pages in memory. If the SQL Server is using lock pages in memory , it doesn't show all memory in Task manager.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com


It looks like the SQL Server Service does have LPIM right through Group policy.
Go to Top of Page

andykn
Starting Member

12 Posts

Posted - 05/22/2013 :  17:13:01  Show Profile  Reply with Quote
Perhaps what I need is a query that can be run on any vanilla SQL server with master/Model/Temp dbs that will take some time and use that to benchmark the performance so I can be sure the suspect SQL server is using memory OK and I need to look again at my application.

Edited by - andykn on 05/22/2013 19:48:57
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000