I have the complicated stored procedure which reads the data from Oracle database and writes into SQL Server tables. The procedure working time was increase more than 3 times. Number of processed records more or less the same.
How to find the weak point? How to identify which part of the procedure creates the problems now?
I am not familiar with DBA tools for performance analysis. I have only SQL Server Management Studio.