System table locks : 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.

Please reply.


-- Anonymous, September 08, 1998


Re: System table locks


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

Moderation questions? read the FAQ