Solved

Table unresponsive - urgent

Posted on 2013-11-14
6
449 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql query 107 61
Getting max record but maybe not use Group BY 2 27
sql server select date from a datetime column 10 25
Loop through SQL parameters and insert to temp table? 4 38
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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