I am having SQL Reporting Server 2008. Database Engine and reporting services are on different servers. Users are complaining from several days that reports are executed slowly.
When I run sp_who2 I saw that there are blocked process and all are related to connections to ReportServer database, no blocked processes to other databases.
On of the day I killed some of the processes and it's seem that this
Any idea why this has happen and how to proceed?
you can try to move your SSRS db to another server -- not with user
also it is known issue
Blocking in SSRS ReportServer Database
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…