![]() ![]() KBA: Masking SQL Server - Hangs, Blocks and Deadlocks (KBA6319).This will consume additional resources on the SQL Server. There needs to be enough space tempdb. ![]() This is an ALTER DATABASE command (permissions are needed and it will affect all SELECT statements).There are two key warnings - please consult your DBA before running the command: Then use this ALTER DATABASE command which will set READ COMMITTED SNAPSHOT:ĪLTER DATABASE SET READ_COMMITTED_SNAPSHOT ON ĪLTER DATABASE SET READ_COMMITTED_SNAPSHOT OFF The workaround is to limit the affected tables to a separate job. Database blocks (the masking job becomes unresponsive).Data read issues (Phantom Reads, masking key columns, filter clauses on masked columns).Examples of the root causes that this KBA provides: On MS SQL Server, the SELECT and UPDATE might need to access the same Database objects and this could cause data read errors or blocks. This solution can also be used to resolve Negative rows Remaining in the Job Monitor (caused by Phantom Reads). This usually affects In-Place (IP) masking jobs, seen as a hung job. This article provides a possible workaround to some specific Masking issues, such as Blocks and Deadlocks on MS SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |