January 25, 2011 at 9:58 am
Hi,
My environment looks like -
Server A
Windows 2003 64-bit
SQL 2005 Std edition
SP 3 installed
32 Gb RAM - 26Gb max memory for SQL
Server B
Windows 2003 64-bit
SQL 2005 Std edition
SP 3 installed
16Gb RAM - 12Gb max memory for SQL
The 2 servers both have databases that are mirrored between them, with the largest - busiest database living on A. Each server has ran out of memory at various points over the last few weeks. Sometime A will page SQL server out, other time B will page SQL serv out, sometimes both at once. Sometimes it happens during the maintenance window, sometime it doesn't. Litespeed is used for the backups. I have looked at DBCC MEMORYSTATUS, but not in-flight, I'm not convinced that it is an issue within SQL. During the issues the system cache does take memory from SQL, but SQL recovers eventually without any intervention. I was planning on applying CU 4, which allows the 'locked pages in memory' for std edition to be configured. But I suspect this will not resolve the issues.
Has anyone experienced anything similar?
regards
M
January 25, 2011 at 11:13 am
Is anything else running on the servers? If not, it's SQL Server that is probably causing the issue. Do you have monitoring set up so you can observe the behaviors over the times in question? Capture the metrics & evaluate. If you get trace events set up you should be able to correlate any process calls with the memory outage.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply