System table locksgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Some of the system tables were blocked, all client applications freezed and can not use E.M. can query through ISQL on user databases, but not on 'master' database.
What would be the problem for 'tempdb'/master database blocking? Our system is running on 1GB RAM with 960 MB alloted to SQL Server. Is it odd setting.
-- Anonymous, September 08, 1998
Enterprise Manager might be unable to connect due to tempdb blocking. Enterprise Manager uses tempdb.
Check for blocking using sp_locks from an isql window.
Hope this helps.
-- Anonymous, September 11, 1998