Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / March 2007

Tip: Looking for answers? Try searching our database.

Memory issue on windows 2003 SP1 cluster node with sql 2005 Ent. 64 bits SP1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Geoffrey - 05 Sep 2006 10:35 GMT
Since the beginning of the week, we get strange errors in our event
log:

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]TCP Provider: An existing
connection was forcibly closed by the remote host.
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]Communication link failure
[sqsrvres] OnlineThread: QP is not online.
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message
= [Microsoft][SQL Native Client]Communication link failure
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message
= [Microsoft][SQL Native Client]Communication link failure
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message
= [Microsoft][SQL Native Client]Communication link failure
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message
= [Microsoft][SQL Native Client]Communication link failure
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message
= [Microsoft][SQL Native Client]Communication link failure
Login failed for user 'xxxuser'. [CLIENT: xx.xx.xx.xx]
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]TCP Provider: An existing
connection was forcibly closed by the remote host.
...

It has done this 2 times. The first time, the sql server service
stopped and restarted. The second time there was no restart.
The cluster has an active/active configuration. It is always the second
instance that gives the errors.  I think it has something to do with
memory consumption.
On node 1 there are 20 databases, on node 2 there is only one.
But when I have a look into the cached plans, I can see that the total
of cached plans on instance1 is around 20000 and on instance2 it is
around 40000.

Our cluster consists of two nodes with each about 8GB of RAM. There are
2 AMD Opteron Processors inside of each node.
The VM size, I've set it on an initial size of 6GB with a maximum of 10
GB on both nodes.
SQL server is configured to use a maximum of 6GB on both nodes.
OS installed:Microsoft Windows Server R2, Enterprise x64 Edition,
Service Pack 1

I don't know if it is a coincidence, but the previous week, they did a
windows update on both nodes (express update). Following has been
installed:
Security Update for Microsoft .NET Framework, Version 2.0 (KB917283)
Security Update for Windows Server 2003 x64 Edition (KB921398)
Security Update for Outlook Express for Windows Server 2003 x64 Edition
(KB920214)
Security Update for Windows Server 2003 x64 Edition (KB917422)
Security Update for Windows Server 2003 x64 Edition (KB922616)
Security Update for Windows Server 2003 x64 Edition (KB920683)
Security Update for Windows Server 2003 x64 Edition (KB920670)
Cumulative Security Update for Internet Explorer for Windows Server
2003 x64 Edition (KB918899)
Security Update for Windows Server 2003 x64 Edition (KB921883)
Security Update for Windows Server 2003 x64 Edition (KB917537)

All clients have been patched too with the latest security updates.

The sqlservr process now uses 3,6GB of memory, with a peak of 5,6GB, VM
size is 6.3GB.

If anyone should have a solution or tips for that, it would be very
helpfull.

Kind Regards
Geoffrey
tootsuite@gmail.com - 08 Sep 2006 21:37 GMT
Your configuration sounds suspiciously like ours. As it turns out,
there's a bug in 64-bit clustered systems. The bug is a failure to
properly release cached memory. You can lock down memory usage by using
the same number for min and max memory. This stops dynamic memory
allocation, which is what is being recommended by others having this
problem. They say the problem will be fixed with SP2.

Meanwhile, there is a DBCC command that can be run to manually release
the cache, thus stopping the memory from getting too large and shutting
down the machine.

DBCC FREESYSTEMCACHE ('All') with MARK_IN_USE_FOR_REMOVAL

I don't know if this applies to your problem at all. Good luck.

Here's a thread that discusses this problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=448560&SiteID=1

> Since the beginning of the week, we get strange errors in our event
> log:
[quoted text clipped - 72 lines]
> Kind Regards
> Geoffrey
Geoffrey - 12 Sep 2006 10:55 GMT
Hi tootsuite,

tx for your response.
I have a strong feeling that this will do the fix!
I'll let you know if it's solved.

Kind Regards
Geoffrey

tootsuite@gmail.com schreef:

> Your configuration sounds suspiciously like ours. As it turns out,
> there's a bug in 64-bit clustered systems. The bug is a failure to
[quoted text clipped - 91 lines]
> > Kind Regards
> > Geoffrey
Lisa Nicolai - 26 Sep 2006 20:11 GMT
I am having a problem that sounds just like this.  I did not do the
install SQL 2005 or SP1.  That was done by someone else.  Before I go
back to my client and propose these changes I have a really stupid
question.

How do I identify whether the 32 bit version or 64 bit version is
installed?
Ezhil Nanjappan - 07 Mar 2007 18:18 GMT
We are facing the similar error and cluster node restarts automatically.
Can you please let me know what was the fix.

We are runing SQL 2005 SP1 64bit on Windows 2003 SP1
VEN KAT - 29 Mar 2007 19:02 GMT
Hi ,
we have the same can you let me know how this problem was fixed.

Thanks
V
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.