Solved

Table unresponsive - urgent

Posted on 2013-11-14
6
439 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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 3 49
Generate Weekly Schedule 15 19
Sql query 107 33
Find data in a column which is not in  a date format 29 20
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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

864 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

19 Experts available now in Live!

Get 1:1 Help Now