Improve company productivity with a Business Account.Sign Up

x
?
Solved

Table unresponsive - urgent

Posted on 2013-11-14
6
Medium Priority
?
542 Views
Last Modified: 2013-11-15
Hello,
A table in sql 2008 has become unresponsive. All other tables work well.
Is there something I can do? This is quite urgent. I appreciate your help
Greetings,
0
Comment
Question by:johnson1
  • 3
  • 2
6 Comments
 
LVL 4

Expert Comment

by:rshq
ID: 39648807
Hello
  Maybe this table is Lock.
0
 

Author Comment

by:johnson1
ID: 39648843
I tried to run
exec sp_lock but I do not have permission. There is not an office hour at the service provider.
Under what circumstances would it lock? Can you tell me what it mean? Is there something else that could be wrong?
This happened after i had been updating a lot of data to this table.
0
 
LVL 2

Expert Comment

by:burdit
ID: 39648894
You can lock a table when you are updating it so that people cannot access partial or updating/changing rows. In SSMS run activity monitor by right-clicking on the SQL Instance:
Activity MonitorNext expand 'processes' and sort by 'Block By':
Blocked ByThis will tell you what is blocking your access to the table, you should be able to trace the process, Block By ID = 98 so go to process 98, process 98's block by ID is 41 so go to process 41, process 41 has no block by ID so right-click kill process and everyone should follow in order.
This method can have consequences, but if the table is artificially locked (no rows are actually changing) then you will probably be ok.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 

Author Comment

by:johnson1
ID: 39648935
Thank you for your instructions. I tried this but I got the message that I did not have permission. There are many websites running on this server.
Can it be locked without me giving that order?
Is there some other explanation?
0
 
LVL 2

Accepted Solution

by:
burdit earned 2000 total points
ID: 39648972
You will have to be able to kill a session ID. Example here on another way to get to it.
0
 

Author Closing Comment

by:johnson1
ID: 39650585
Thank you for your help.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question