Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Lock table in db; need restart server

Author  Topic 

mmean
Starting Member

1 Post

Posted - 2014-11-26 : 09:29:46
How could thoroughly investigate and manage settings for lock on the tables in the database?

Often happens to me that the server that has two bases, the first 150 GB, 180 GB of second, happens to one request lock entire database.
After that, a simple query can not be released, and the server must be restarted.
After that, the processing can be executed.
I guess that happens lock over the tables.

I wonder how I could explore and configure the base?
How to Prevent it?

I'm working on SQL Server 2012, with Windows Server 2012.

Thank you

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-11-27 : 07:02:38
Answer to same question by same OP has been given here https://social.msdn.microsoft.com/Forums/sqlserver/en-US/10eebff5-f8ae-485d-a20b-6e6bad0bb820/lock-table-in-db-need-restart-server?forum=sqlkjmanageability

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -