Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL server process (sqlservr.exe) is being paged out

Status
Not open for further replies.

pie8ter

IS-IT--Management
Nov 14, 2006
24
US
We are running SQL 2005 SP2 x64 on Windows 2003 SP2 X64.

Server specs:
Quad Core, each core runs at 2.33Ghz.
4GB memory
OS and SQL on RAID 1 set
Transaction log on RAID 1 set
Databases on RAID 5 set

-The SQL service account is a domain account with the "lock pages in memory" rights.
-The min memory use for sql server is 3GB

For whatever reason, the sqlsrvr.exe process uses less physical memory and use more Virtual Memory (VM). When I look at the Task manager (TM), I see 157MB for Mem Usage column and 238MB for VM size column. Why would the SQL server process is being paged out? I have 3GB for it to use. Should be concerned about the my SQL server?

I didn't configure the AWE as MS doesn't recomment using it on x64 bit systems.

Thanks
 
AWE doesn't exist on the 64 bit OS.

Are you using SQL Server 2005 Standard or Enterprise?

Standard Edition doesn't support "lock pages in memory". Only Enterprise Edition supports the "locl pages in memory".

What are your min and max memory setting set to?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Ahh..didn't realize SQL Standard Edition doesn't support "lock page in memory".

We use SQL 2005 Standard

Min = 3000
Max = 2147483647

Here are my "dbcc memorystatus" results:

Memory Manager:
VM Reserved 4266144
VM Committed 138504
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0

Thanks
 
Change the Max memory to 3.5 Gigs. This may help. Currently you are letting SQL Server take all the memory that it wants forcing apps to use the page file.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
MrDenny,

Do you have a link to where it says Standard doesn't support the "Lock pages in memory"?

-SQLBill

Posting advice: FAQ481-4875
 
Ahhh, nevermind. I just found one that says it's not supported on SQL Server 2005 Standard 64 bit edition.

That threw me as everything I've seen said it is supported on Standard - but I'm guessing that's just for the 32 bit version.

-SQLBill

Posting advice: FAQ481-4875
 
I don't know where it's documented. Microsoft's PSS told us.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Okay...we've been using it on all our SQL Server 2000 and 2005 Standard installs and haven't seen any problems. But we aren't using x64. That's why I was asking.

-SQLBill

Posting advice: FAQ481-4875
 
Ah.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top