Solved

Table unresponsive - urgent

Posted on 2013-11-14
6
428 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
Comment Utility
Hello
  Maybe this table is Lock.
0
 

Author Comment

by:johnson1
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:johnson1
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
Thank you for your help.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now