December 1, 2008 at 1:01 pm
By any chance is this happening while you are "COPYING" files across the network ?
* Noel
December 1, 2008 at 2:49 pm
Not to my knowledge
Plus, the fact that it used to happen every 30~40 mins, and now 60-90 mins (after changing MIN/MAX memory settings) seem to be not network-copy related. Wouldn't coincide with TLOG backup with these weird times either 😛
This is gonna be my "never figure out" problem, I know it 🙁
December 2, 2008 at 11:09 am
It has been my experience that this things happens *A LOT* with the Standard Edition (no lock pages in memory) when other than SQL Server Apps are running on the server OR when files (backups usually) are copied across the network.
* Noel
December 2, 2008 at 3:03 pm
Hi
have you read this?
http://support.microsoft.com/kb/918483
and here is our beloved PSS engineers response as well
http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx
hope this helps
December 2, 2008 at 3:15 pm
CoetzeeW (12/2/2008)
Hihave you read this?
http://support.microsoft.com/kb/918483
and here is our beloved PSS engineers response as well
http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx
hope this helps
Yes (you'll notice my Query came from the KB) and Yes, and many others Google provided.
I wish it's a simple ON/OFF of a setting, but it doesn't appear to be that way, or even SQL Server related
There is no other application running on this server, so it's very very strange to see paged out when available memory was plenty
My Page Life Expetancy also lowered substantially compared to original perf counters (before MIN/MAX memory change), while Memory Utilization can go to 90%. So first symptom is bad, 2nd symptom is good? I am confused...
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply