Saw a recent issue with SQL2008 sp 1 where SQL Server Management Studio (SSMS) appeared to hang when a DBA expanded the database users tab of a database… ie like this :- When we looked at the waittype of the SSMS session - via sys.dm_os_waiting_tasks...