Video Screencast Help

9sp2 stored procedure

Created: 07 Jul 2013 • Updated: 07 Jul 2013 | 2 comments
GertjanA's picture
This issue has been solved. See solution.

I am seeing this sp spu_JournalDelete_SoftUndelete, or better, the sql admin sees, takinh huge amounts of sql processing time. This causes issues with archiving. It seems to be related to mailarchiving only. This may ormmay not be due to mailarchciving using sharing, whereas journal does not. Anyonenknows what this stored procedure does? Thx. Gertjan

Operating Systems:

Comments 2 CommentsJump to latest comment

JesusWept3's picture

The only time it gets called is from the VAC when you go to an archives deleted item tabs and hit restore

It changed the indexseqno in the save set table, updates the index and removes the journaldelete entry

But again it should only be trigged through that restore items button

Look at indexes on journaldelete and saveset

GertjanA's picture

thanks JW

Thank you, Gertjan, MCSE, MCITP,MCTS, SCS, STS