Skip to Content
1
Oct 30, 2019 at 03:08 PM

Blocked Sessions after Upgrading to SQL Server 2017

328 Views

After upgrading to SQL Server 2017 I am experiencing Blocked Sessions on NRIV and ARFCSSTATE. SAP says to buffer NRIV and to disable page level locking on ARFCSSTATE. I have also had a couple of blocked sessions on my BW system on a BPC table. The curious thing is that in the 12 years I've worked here I have never had issues with Blocked Sessions until I upgraded to SQL Server 2017. Just curious if anyone has had similar issues.