I put in a support request a while back regarding very slow application import speed and was referred to the article noted below which basically said to change the isolation level in the db to READ_COMMITTED_SNAPSHOT. I tried doing so by running the query in MSSQL:
ALTER DATABASE <DB NAME> SET READ_COMMITTED_SNAPSHOT ON;
The query never finished executing, I let it run for 2 days but it would never successfully execute the query. I created an empty test DB and ran the same command and it instantly executed the query.
I then tried running:
ALTER DATABASE <DB NAME> SET ALLOW_SNAPSHOT_ISOLATION ON;
executed successfully within a few minutes. Tried altering the DB again to read_committed_snapshot and again it just hung.
The application I am trying to upload it only 250MB, last time I tried importing it said it would take over 200 hours to import.
I tried again today and same thing. Not sure what is going on. Attached are the PegaRules log. Any help is greatly appreciated.
The db setting may not be related to import performance (it does eliminate deadlocks related to readonly lock). One thing to check is that how many nodes in your environment when you import your RAP? The recommendation is to import with one single node running if possible. Once complete, you can bring up other nodes.