Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Cluster - [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed


SQL Server 2005 Cluster - [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

Author
Message
Prakash.Bhojegowda MCSE, MCSA...
Prakash.Bhojegowda MCSE, MCSA (SQL 2012)
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 602
yes, the service account that sql server services run on does have lock memory pages rights...

Prakash Bhojegowda MCSE, MCSA (SQL2012)
syed_h_ali2001
syed_h_ali2001
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 326
This is a tough problem I remember one of this should fix it. Change the network card speed from Auto to the speed of switch specifically and also make sure network card driver is updated one.
Hitesh-335315
Hitesh-335315
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 52
We too have the following error on our win 2k3 X64 cluster system using SQL2005 . Here is the cluster log leading to cluster failure as pointed out by earlier posters on this thread .

000008d0.00000610::2008/06/19-08:56:49.653 ERR SQL Server : [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

We plan to change following para in registry and eliminate the write cache on storage .

HKLM-->System-->CurrentControlSet-->Services--TCPIP-->Parameters
Change the following entries to 0 and reboot

EnableTCPChimney
EnableTCPA
EnableRSS


Will this solve the problem.

We have also increased the isalive and lookslive values from 5000 and 60000 to 6500 and 80000.

Does this looks ok .

We use VNC , at time RDP and performance logs monitoring . Further SQL memory is et to utilize max physical memory (physical memory - 8GB) .
thomas.halligan
thomas.halligan
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 35
We have resolved this issue on a couple of Clusters by setting the following in Registry on the nodes(After having updated service packs, driver, firmware and disabling TCP/IP offload)

1. Set TcpMaxDataRetransmissions to 30 (decimal);
http://technet2.microsoft.com/WindowsServer/en/library/7dac9001-3e55-4e9c-b0fa-52841ece2fdd1033.mspx

2. Set KeepAliveInterval to 25000 (decimal).
http://technet2.microsoft.com/WindowsServer/en/library/734570a2-06d6-450e-b765-ccfa7530af491033.mspx

It worked for us you mileage may.
dingle1975
dingle1975
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 42
Hi Thomas,

Many thanks for that. I'll certainly give it a try.

Cheers,

Dave.



MikeM-150936
MikeM-150936
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 119
Thomas --

We have had the same problem in our cluster environment for awhile now... and I tried these two additional reg-pokes you suggested.

We had been thinking it was disk issues up till point... we are going to get EMC involved sometime today.

Anyhow, I tried the pokes and they look to have worked... I have a process that would cause the error most every time... once I put these in, it wouldn't fail. I took them back out, and things started failing again. So... I'm proceeding with cautious optimism that this works for us...

BUT... not being very strong from a network perspective... how did you come across these reg-pokes and what exactly do they do and why would I need to be concerned about them on the cluster but not on our other non-clustered SQL servers? Just curious if you have answer..

Thanks!
Mike Metcalf
thomas.halligan
thomas.halligan
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 35
In my Organization we had this issue with a number of SQL2005 64 Clusters.

I went through every posting on the net.

We updated NIC drivers, disabled TCP/IP offload. We checked Storage adapters and SAN provider bugs. It was getting to the point where we were considering some rather drastic measures regards RAID layout when on the 5th or 6th call to Microsoft PSS a tech mentioned these settings as a possible resolve.

As we were getting to the point where we might have to ask the client to blow away their LUNS to test a theory, we thought we would give the registry edits a try. They worked and continue to work. I got to thinking about all the hours of trolling through online postings I did and decided to post the info so someone else’s life could be more fulfilling.

Hope it works out for you. On the upside I now know more about SQL architecture than I ever really wanted to know (I am an OS guy primarily)

BTW what process would you use to generate the error?
MikeM-150936
MikeM-150936
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 119
Funny thing is that in crept into our main cluster about a few months ago... but at that time, it wasn't impacting anyone... but It's gotten progressively worse... We have gone through the same exact motions you did... except considering rebuilding the LUNS. :-)

We have sent off this info to Microsoft (we have an ongoing open case about this) to get some more clarification as to why this would work... and we're still going to work with our SAN vendor 'just to be sure'... but my team and I were talking, and to us it is PLAUSIBLE that maybe it really is a network/disconnect thing... and the reason for the spike in disk activity is secondary... i.e. a disconnect forces SQL Server to commit or rollback... potentially momentarily causing a disk spike.. (a thought anyway).

How we replicated the error... hmmm.. well.. we are getting a new/upgraded system in here, and last week, they went through a mock conversion. One part of the process runs a stored procedure that creates/runs dynamic SQL against the server.... so, it was running against a node in the cluster... and get kept failling for most of the day... until it finally ran clean -- it took about 2 hours. I took the database to another newly-made node, re-did my test, and it failed every time. I applied the poke, and it ran cleanly off the bat. I removed the poke, and the proc failed... then SQL profiler started getting disconnects, and even another query window I was using to query the status of the running proc. Put the poke back in, and the node was happy. I'm not sure if I could tell you how to make a generalized script/test out of it... if you're interested I'll see what I can do.

-- Mike
dingle1975
dingle1975
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 42
Hi Mike,

....'We have sent off this info to Microsoft (we have an ongoing open case about this)....'

Could I ask that you post whatever MS comes back with? I'd be very interested to know what they say. Smile

Many thanks,

Dave.



Hitesh-335315
Hitesh-335315
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 52
Thomas / Mike ,

Thanks for ur all valuable contributions . Here are my 2 cents to the discussions . We too had similar problems . What I noticed our SQL server instance was configured to use maximum memory virtually unlimited . I set the same to little lesser than OS memory (7 GB for 8 GB ), And now it works fine without any errors.

I'll also try the reg setting suggested herein .
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search