question

niall5098 avatar image
niall5098 asked

linked server query cause sql server crash

HI There, i have a sql server 2012 installation that i was running a simple select count from to a linked oracle server. this simple select causes the instance to crash. I was running sql server 2012 rtm and applied the latest patch as there was a known issue around linked servers and the RTM version. however i thought the patch would fix that. has anyone else encountered this issue? Thanks in advance,
sql-server-2012linked-servercrash
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

niall5098 avatar image niall5098 commented ·
thanks for the response. i seen that link but i don't think it applies as all i ran was a select count(*) from linkedserver.object.
0 Likes 0 ·
sp_lock avatar image sp_lock niall5098 commented ·
Are you able to toggle in the "Allow inprocess" option within the link server?
0 Likes 0 ·
niall5098 avatar image niall5098 commented ·
yeh i tried that but the crash re-occurred
0 Likes 0 ·
sp_lock avatar image sp_lock niall5098 commented ·
OK. What level did you patch to (run select @@version)? Also did you get the minidump details? I wont be able to help at that point, but you may want to engage with MS support to investigate.
1 Like 1 ·
niall5098 avatar image niall5098 commented ·
yeh i have opened a call with MS as the instance is patched to the latest. i will put an update here when i have one.
0 Likes 0 ·
teojaimes avatar image
teojaimes answered
OP, did you ever find a solution for this SQL server instance crashing issue? Last post you mentioned working with M$. Also experiencing similar issue here. Thanks, Teo.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

niall5098 avatar image
niall5098 answered
Hi Teo, no resolution yet. they asked me reboot the server and try to replicate the issue. not something you really want to do with a live server. i will update this thread if i get an answer.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.