it's your site

Web Site Go

You are here :

Article Details

Finding locks on a Table

We are working on an application and which had got login screen as an entry page. One day all the developers were getting time out error from the development database when they launch the application.

Ok fine. But we were able to connect to the Sql server without any issues. So Server availability was not an issue. We were able to query all the tables without any issue except the UserInfo table. UserInfo was the table which had got user credentials.

The select statement took so much of time and received time out error after some time.

There was a lock applied on the table and which was not released.

Ok. Now let’s see the solution for this problem.

Finding locks and Killing unwanted on the tables

Get the id of the object UserInfo by using the following statement

SELECT OBJECT_ID('UserInfo') –Gets id of the object UserInfo

Find the applied locks on the object UserInfo

sp_lock 2105058535 -- 2105058535 ID of the object UserInfo

Now we need to find out the sleeping processes or unwanted processes which have applied locks on the table object UserInfo

kill 52 --52 is the process id

That’s it this resumed our development work J.

I hope you may find this useful.

Written By: Kumaravel
Date Posted: 2/18/2009
Number of Views: 1033

Comments

cheap north face cheap north face Says:

1/2/2012 7:22:56 PM

Nike Air Max is a shoe by Nike that was introduced in 1987 as the first example of Air Max-branded technologies. Designed by Tinker Hatfield, the Nike Air Max shoe uses a large air cushioning unit which is visible at the side of the midsole in most models. Especially sought after models include the 1987 (Air Max I), 1990 (Air Max III), 1991 (Air 180), 1993, 1995, 1997, and to an extent, air max pas cher 2003.

In addition cheap handbags to lose hope. Help is surrounding the spot which there's help by using Hermes Duplicate clutches. For those who have placed your own cardiovascular system about the louis vuitton handbag Birkin you'll be able to still the item, definitely not taking into consideration a person's standard bank sense of cheap designer handbags balance.

ugg boots sale Says:

6/7/2011 12:34:39 AM

ugg boots sale are believed to accept been aboriginal developed in Australia or New Zealand, although the exact date is uncertain-they accept been, at altered times, articular with pilots in World War I who are said to accept beat them for amore in unpressurized planes, shearers in rural Australia during the 1920s, surfers and aggressive swimmers who wore them in the 1960s and 1970s for befitting balmy while out of the water. In the aboriginal 2000s, uggs on sale they became a appearance trend in the United States, arch to added all-around sales.
ugg amberlee
ugg amelie sandals
ugg annabelle
ugg bailey button triplet
ugg evera
ugg highkoo
ugg kensington
ugg knightsbridge
ugg mayfaire
ugg raya
ugg retro Cargo

ugg boots sale Says:

6/7/2011 12:34:21 AM

lu juan Says:

4/5/2011 5:22:13 PM

My favorite part of the suite is Microsoft Office 2010 . You can use it like a fancy clipboard, but Office 2010 is much more powerful and useful.So, I'm forced to pay for an upgrade to Microsoft Office that I did not want.For the price, you can't go wrong with Outlook 2010 Home & Student. And, I may or may not be able to use the Product Key on the package I purchased to activate only Word, Excel, Microsoft outlook 2010PowerPoint and OneNote, the programs I thought I was buying. The only answer was to go to MS Office, or have everyone else in the world switch to Office 2007 .The instructions on the Microsoft website for activating Office imply that the full Microsoft Office 2007 Professional suite is the only version eligible for proper licensing.

a a Says:

12/22/2010 10:25:39 PM

Microsoft Office
Office 2010
Microsoft Office 2010
Office 2007
Microsoft Office 2007
Office 2010 key
Office 2010 download
Office 2010 Professional
Microsoft outlook
Outlook 2010
Windows 7
Microsoft outlook 2010

li meng Says:

11/11/2010 8:18:44 PM

You must be logged in to submit a comment.

Return