We went from a backup and restore Reports database to a transactional Replicated DB.
I have a job overnight that creates a table, the jobs took about an hour, now on the replicated copy of the DB the job take 12+ hours
The job does do a bunch of updates .
I tried adding SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in the stored procedure with no better results.
What about Snapshot Isolation?
Not sure how to use or if it will help.
Any ideas or where I can read would be appreciated