AlwaysON,  DBA

AlwaysON SQL server database blocking SSISDB Active Operations

Advertisements

AlwaysON SQL server database blocking

I had two blocking case on one of my alwaysON databases.

  1. Backup is third party tool and it got blocked by each other sessions.
  2. SSIS package deployed in SSIS folder and it run long and had blocking as well.

 

The first one, tried to kill the session ID, it went in to rollback state and it took more than half day, no response.

Fix: Just suspend the database in the primary AG this will remove the killed SPID.

The second one, we can look into the Active Operations of packages.

Integration service catalog – right click SSISDB – Active Operations

 

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 51 = 55