The path to the Executables, the path to the Website, or the path to the WebService?

The path to the executables is the easiest.  Go to the services applet,...

For most client-server applications, the server's port is fixed (such as port 80 for web servers, or by default 1433 for SQL Server).  The port that the client picks is...

You can also set up an Event Session.  In SSMS 2014, there is a function for this (before, you had to work your way through the scripting).  You can set...

Are the networks (1 and 2) connected to separate physical switches?  If not, both serves would have detected both networks down,and considered themselves islands without quorums.

Let it grow.  I have no real figures to back this up with, but a 20 GB tempdb with a 1 TB user database seems very low to me.  I...

First thing I would do is cap the server max memory (MB) parameter in sp_configure.  Right now SQL Server will take up to a few megabytes less than the amount...

On the surface, it looks like you are having a lot of physical disk reads.  This is not too surprising immediately after a restart of the instance.  How large is...

Is there a MSDTC (Distributed Transaction Coordinator) running on the new SQL Server?  Check to make sure it is allowing XA transactions:

Better info here:  https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions

Dang it, dang it, dang it.  Got it wrong.  And I even played around with this a few weeks ago.

Nice twist on it.

OK.  PREEMPTIVE_COM_GETDATA usually (at least from what I have seen) means the process is having problems getting enough CPU cycles for the OLEDB driver to deal with the data.  Is...

That is what I thought as well, Luis.  After a bit more testing, I found that the money datatype is the only one that exhibits that sort of behavior.  All...

I would guess the conversion routine simply drops all thousands separators, and then converts to a numeric type:
declare @var money
set @var = ',1,00,00.99'
select @var

Does the new server experience slowness to other resources (backups, file shares, etc.).  If so, it could be someone misconfigured the virtual network card.

Also, check in sys.dm_exec_requests as...

The problem is that for security, the master key of any database is encrypted by the server master key.  You can synchronize the Server Master Keys by backing up the...

On the surface, I don't see anything in the query that would cause inconsistencies.  Have you run the query directly on the Oracle database to see if the table is...