SQL Server Hang and Consume Physical RAM

Question

Post reply

SQL Server Hang and Consume Physical RAM

jbhsyed.p10

SSC Journeyman

Points: 88
More actions
February 27, 2018 at 2:02 am

#343735

We are facing issue on the SQL Server , SQL Server fetching data from Oracle 12c through linked server but at the time of fetching data from oracle then we receive preemptive_com_getdata wait type then sql server consume all available physical RAM and then hang and then restart , In normal production time windows server also hang , task manager not responding
Total vCPU : 28
RAM : 132 GB
Vmware
What will be the cause of this ?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Joe Torre SSChampion Points: 10248 More actions · Answer 1

Try integration services instead of a linked server.

Sue_H SSC Guru Points: 90860 More actions · Answer 2

jbhsyed.p10 - Tuesday, February 27, 2018 2:02 AM
We are facing issue on the SQL Server , SQL Server fetching data from Oracle 12c through linked server but at the time of fetching data from oracle then we receive preemptive_com_getdata wait type then sql server consume all available physical RAM and then hang and then restart , In normal production time windows server also hang , task manager not responding
Total vCPU : 28
RAM : 132 GB
Vmware
What will be the cause of this ?

One of the reasons could be just from having alot of data coming back from Oracle and/or the linked server is used with joins with SQL Server objects. Openquery can sometimes work to improve things but it really depends on your query.

Sue

jbhsyed.p10 SSC Journeyman Points: 88 More actions · Answer 3

What we will do to find the root cause of this issue ?

Sue_H SSC Guru Points: 90860 More actions · Answer 4

jbhsyed.p10 - Tuesday, February 27, 2018 11:56 PM
What we will do to find the root cause of this issue ?

By testing, looking at any components that could be a factor and looking at your code.
You need to evaluate the query, check the amount of data going across the wire with the linked server, if filtering the oracle data do it in Oracle using openquery, if you are using it for joins and it's a ton of data, look at a SSIS to pull the needed data across to a table, etc.
It could also be an issue with network latency as you are waiting on the data. But we don't know anything about the volume of data, what the query is, etc so all we can do is guess at things it could be.

Sue