![]() When working with SSMS, have you run into a situation where you try to expand the list of tables and SQL Server came back with this nice message? Here, I show how DBCC OPENTRAN can also be used to quickly narrow down the specific problem below. Then DBCC INPUTBUFFER may be used with SessionID and RequestID to get the SQL specifics. ![]() ![]() Although I explain the process for table expansion, the troubleshooting steps to find any blocking session is to run sp_who2 and look at the BlkBy column to get the session id that is blocking a session (assuming you can identify sessions from the information in the other columns) and examine the blocking session. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |