Does Encryption Affect Seeing Statements in Deadlock Graphs?

Home / SQL Server 2012 / Does Encryption Affect Seeing Statements in Deadlock Graphs?

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:

Then I’ll execute things in the following order. From one connection this query:

From a second connection, my stored procedure:

Then, back on the first connection, this query:

That will generate a deadlock. It’s a straight-forward classic deadlock. I’m using extended events to capture the deadlock graph and the output looks like this:

Note, the statement offset is crazy, but that’s because it’s coming from an encrypted stored procedure. But the short answer is, yes you can (at least in this test).

3 Comments

OK, fine, but what do you think?