Sleeping session creating blockage RRS feed

  • Question

  • Hi All,

    I have SQL Server 2012 and we have many SSRS reports in our project. After a SSRS report is executed, report server creates sleeping sessions that don't die easily. This sometimes creates deadlocks in the sql server. 

    Please tell how to fix these sleeping session issue.

    Wednesday, January 22, 2020 11:03 AM