how to read the data from blocked process threhold report? I have enabled blocked process threshold in one of my server. Can someone tell me how to do it?
The script is working fine. But the table is keep on updating without any new logon event occurs. Also, it is not working for add_role_member server event.
I just ran the sample script provided in the article. But i am not seeing the effect of row-versioning. I have enabled LLOW_SNAPSHOT_ISOLATION & READ_COMMITTED_SNAPSHOT also.
I just did the same way as roy suggested. I turned ON row-level versioning. But it was not working the way he said. Do i need to restart my instance...