Thanks Jeff.

I appreciate your tips.

Please see the view.

 SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW vw_ORDTun
AS
SELECT b.ID AS OrgID
      ,b.OrgCd
   ...

Jeff,

Thank you for your response and suggesting about other details, i am totally agreed with you.

i have link for the plan, please see the following link if you don't mind.

Thank you JO.

I checked Execution plan and one recommended index also created.

Execution plan mostly having Index seek, Index Scan (for PK).

It is in break down for each Insert and Update...

Thanks for your views and suggestions and completely agreed with both of you!

Thanks Jeff.

I am totally agreed with you as it's temporary but any suggestions which i can follow so we don't have to carry unused stored proc into migration process.

Thanks Steve.

I am using different script to find out which procedure have the latest cache date and converting into Stored proc and during that time i am loading into table...

Thanks Grant.

I will try with Powershell as it should be little convenient.

Thanks Jeffery,  I will try it out.

Thanks Grant for your help!

Thanks Everyone for your help!

Thanks Grant.

we are also running DBCC Check so doesn't looks like any corruption but having restoring on another server will be good idea.

It's waiting on RESOURCE_SEMAPHORE for DBCC TABLE CHECK.

CPU...

Thanks Sue.

Yes,  I have already checked and nothing blocking or no any other running that can impact, even databases are also small.

It's a Sharepoint DB.

Thanks.

I tried to restore the full Backup Copy_only DB and Transaction Log backups, Restored successfully.

but having issue when i tried to Join the DB as i am getting following error:

"Remote...

Any thoughts for above>

Greatly appreciated your guidance!

Thank you so much for your detailed answer.

For #1 ==> I am using SSMS => (see attached image)

Always ON high Availability => Availabilty Groups => New Availabilty Group Wizzard =>

Specified...