Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Table unresponsive - urgent

Posted on 2013-11-14
6
Medium Priority
?
508 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

773 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