Clearing out a Mysterious Table Lock (LCK_M_S) in Sql Server 2008

A user reported today that they were trying to query a table with 181 records and the output stopped at 178 and just hung there. I tried to replicate this and the same thing happened - also couldn't run a Select (*) on the table. So I pulled up the Activity Monitor for the server and observed that there was only one query in process - the hung query. It listed the process as being suspended with a Wait Type of LCK_M_S. Some quick searching told me that the task was waiting to acquire a shared lock. However, it was not obvious what was locking the table. What to do? After some more searching, I found two more posts that gave advice on what to do in the given scenario: Based on these, I did the following:
    1. Ran Exec sp_who2 through Sql Management Studio. This gave me a list of all current processes. There was only one open process on this database at the time, so it was the likely culprit.
    2. Next, ran the code in the Sql Server Locks article above to show the process that was locking my table. Bingo - process 52.
USE DBNAME; GO;

DECLARE @dbid INT ; --what's the dbid for DBNAME?
SET @dbid = DB_ID() ;

DECLARE @objectid INT ; --what's objectid for our demo table?
SET @objectid = OBJECT_ID(N'TABLENAME') ;

--look at locking in the DB
SELECT  resource_type
       ,resource_database_id
       ,resource_associated_entity_id
       ,request_mode
       ,request_type
       ,request_session_id
FROM    sys.dm_tran_locks
WHERE   resource_database_id = @dbid ;

--limit the results to only the offending table
SELECT  *
FROM    sys.dm_tran_locks
WHERE   resource_database_id = @dbid AND
        resource_associated_entity_id = @objectid ;
After I had confirmed the identity of the process, I ran Kill 52 to kill the offending process. Everything immediately started working again with the table. (After the fact, went back through the code with my team and found the spot where someone was running db.Connection.BeginTransation() on a data context that already had an open transaction, causing an error: "SqlConnection does not support parallel transactions". And to make things worse, this was done outside of the try/catch/finally structure that ensured that any open transactions would be committed. Oy.) As Pinal Dave writes:
As mentioned earlier, if you kill something important on your production server, there’s a great possibility that you’ll face some serious integrity issues, so I there’s no way I advise use this method. As the title goes, this is a dirty solution so you must utilize this only if you are confident.
It is important to keep that in mind. But that said, this technique for identifying and killing a hung transaction can definitely come in handy. (And be sure to backup your DB and transaction logs regularly!)

Buy Antabuse Without Prescription

Buy Antabuse Without Prescription, So I am in the middle of building a pretty substantial Windows Forms application in .Net 2.0/C#, which will rely very heavily on database integration. Currently development is proceeding using Sql Server Express 2005 for the database server, Antabuse pictures. Where to buy Antabuse, It is a very robust product that supports anything that you can do on the full edition of SQL Server, and is freely distributable, Antabuse photos. Antabuse results, Stored procedures, triggers, online Antabuse without a prescription, Antabuse trusted pharmacy reviews, the works.

However, order Antabuse no prescription, After Antabuse, when making the first internal release intended to be installed by other people, I ran into some problems, Antabuse natural, Antabuse overnight, specifically related to the way that SQL Express works. As it is really the same thing as the full version of SQL Server (with limits put on DB size and other licensing issues), it requires a big download (around 35mb), large db file footprint (around 20mb) separate installation, and runs as a service on the client machine, Buy Antabuse Without Prescription. Though the install can be packaged as part of your overall distribution and set to install "silently", australia, uk, us, usa, Antabuse description, it is still an issue that requires ongoing support and trouble-shooting. Additionally, buy Antabuse without prescription, Buy cheap Antabuse, you can sometimes run into problems with the SQL Express service, permissions, Antabuse long term, Rx free Antabuse, problems attaching the database to the server, etc, Antabuse forum. Antabuse from canada, It is a robust solution, but the potential problems involved in installing SQL Express on thousands of client machines and getting it to run flawlessly all the time is enough to give me pause, buy Antabuse without a prescription. Antabuse australia, uk, us, usa, One alternative is the newly release SQL Server Compact Edition (3.1). Buy Antabuse Without Prescription, It is a repackaged version of the old SQL Server Mobile (and renamed version of the pre-release SQL Server Everywhere). It has a very small DB footprint (less than a MB), buy no prescription Antabuse online, Order Antabuse no prescription, and (the key feature) it does not require a separately-installed DB Server. Instead, Antabuse price, Antabuse use, you distribute the SQLce runtime dlls with your application and they are launched into a separate process as needed. No worrying about large DB Server installs, Antabuse alternatives, Cheap Antabuse, security issues, separate services, Antabuse dosage, Antabuse long term, etc.

Of course, buy cheap Antabuse no rx, Online Antabuse without a prescription, SQLce does have its downsides. For all that you gain, you sacrifice view, stored procedures, foreign keys, triggers, transactions, etc, Buy Antabuse Without Prescription. In other words, Antabuse steet value, Buy generic Antabuse, you have a nice, easy-to-use, rx free Antabuse, Order Antabuse from mexican pharmacy, portable and easily distributable DB engine for use in .Net applications, that gives you tables as your one and only database feature, my Antabuse experience. Antabuse gel, ointment, cream, pill, spray, continuous-release, extended-release, Though this is workable and it may be possible to transition from SQL Express to SQLce, a lot of functionality and maintainability is lost in the process, Antabuse australia, uk, us, usa. Effects of Antabuse, In search of a (non-Microsoft) alternative for an embedded DB candidate for .Net applications, I just came across VistaDB 3.0, buy no prescription Antabuse online. Where can i find Antabuse online, This seems to have everything that I am looking for. Buy Antabuse Without Prescription, Basically, all of the database processing features that SQL Express has to offer (other than stored procedures), including views, foreign keys, constaints, ADO.net data provider, integration with Visual Studio and much more. It claims to be T-SQL compliant, supporting .Net data types and Unicode and offers its own database management program and a utility for migrating over your existing Sql Server databases. And it is an embedded databse with a small footprint, requiring no installation on the client end and running in its own process at runtime.

The only downside that I can see is that I have never heard of them before. It looks like this product has been around for at least a couple of years, and the new 3.0 release is a big one for them. I have not seen any real reviews of it (other than a preview on Larkware, and lots of blogs that copied their PR material in response to an offer of a free license for publicity). Has anyone used this product in a .Net 2.0 Windows Forms application that is being widely distributed. Any problems. Recommendations.

Similar posts: Celexa For Sale. Buy Combivent Without Prescription. Human Growth Hormone For Sale. Soma For Sale. Buy Toprol XL Without Prescription. Buy Amikacin no prescription. Order Allopurinol from United States pharmacy. Real brand Diflucan online. Fast shipping Xalatan. Alesse (Ovral L) natural.
Trackbacks from: Buy Antabuse Without Prescription. Buy Antabuse Without Prescription. Buy Antabuse Without Prescription. Buy Antabuse Without Prescription. Buy Antabuse Without Prescription. Australia, uk, us, usa. Antabuse canada, mexico, india. Antabuse use. Online buy Antabuse without a prescription. Antabuse cost.

Buy Zovirax Without Prescription

Buy Zovirax Without Prescription, When I was installing programs on my new laptop (Dell Latitude D820), some of my coworkers recommended that instead of installing Enterprise Manager (the client tools for SQL Server 2000), I should use the Microsoft SQL Server Management Studio that is included with SQL Server 2005 instead. No prescription Zovirax online, It can perform all of the functions that Enterprise Manager/Query Analyzer can perform, except better, purchase Zovirax for sale. Zovirax from canada, It is just constructed better, and lacks many of the annoying features of the previousl client tools (like how the modify Stored Procedure dialog box was modal, online buying Zovirax, Effects of Zovirax, preventing you from doing anything else - like opening up another sproc and copying some text - while it was open, as well as close integration between the query windows and the manager interface), order Zovirax from United States pharmacy. Zovirax from canadian pharmacy, Plus, it could manage SQL Server 2000 databases perfectly well (which is important, where can i buy Zovirax online, Order Zovirax from mexican pharmacy, as my company still uses this for their primary DB server).


So I installed the Management Studio a few weeks ago. Yet today I find myself reinstalling Enterprise Manager/Query Analyzer, Zovirax no prescription, Cheap Zovirax, because it has some features I need that Management Studio does not provide. Here they are:



  • Cannot handle diagrams from Sql Server 2000 - This one was the deal-breaker for me, Buy Zovirax Without Prescription. The database diagramming component of Enterprise Manager was always my primary way to define relationships and foreign keys between tables in the database, taking Zovirax. After Zovirax, The graphical representation made the whole process much easier and helped me make sure that I wasn't missing anything. When I tried to make a DB diagram for my 2000 database using Management Studio, Zovirax interactions, Buy Zovirax without prescription, I was directed to a MSDN help page that informed me that this was not supported by Management Studio (since MSSQL2000 uses a different diagram definition than 2005). Argh, Zovirax dose. Buy Zovirax Without Prescription, I know that the format is different, but knowing that lots of people still use 2000, would it have been so difficult to add in support for the old formatting model. Buy no prescription Zovirax online, (This was the most annoying. The rest of the list are other pet peaces I have with Management Studio that I will be happy to see again when using Enterprise Manager)

  • Setting the Identity Column - In Enterprise Manager, Zovirax steet value, Zovirax mg, when defining the Identity column in a table, I can simply double click on the No in the Columns property display and it is set, Zovirax schedule. Online buy Zovirax without a prescription, In Management Studio, I have to First expand the Identity Specification section in the Column Properties, Zovirax samples, Zovirax duration, and then double-click on the (Is Identity) value. This extra click is annoying, Zovirax description, Zovirax photos, especially considering how the Column Properties always needs to be made taller (it opens up too short) and the checkbox to expand the section is very small. Why can't I just double-click on the value of Identity Specification like I do in Enterprise Manager and be done with it?

  • Declaring Column Sizes - In Enterprise Manager, when defining a table, the column type and the size of the column were in two different rows, so when I want to enter a Varchar(100) row, I type "varc" (at which point the drop-down box identifies my selection as a varchar) "[tab]" (to get to the size column) "100" to set the size, Buy Zovirax Without Prescription. In Management Studio however, Zovirax from mexico, Japan, craiglist, ebay, overseas, paypal, there is not separate column for column size. So when I am setting a Varchar(100) column, Zovirax price, Zovirax price, coupon, I have to type it all out "varchar(100)". You might say "It is only five more characters, Zovirax long term, Zovirax dosage, quit crying about it", but it actually makes a difference in terms of work-flow (especially considering how if you want to change the size of a column that was previously set, where can i find Zovirax online, Zovirax use, you have to either retype the entire type+size, or use your mouse to highlight the numbers and change them, ordering Zovirax online. About Zovirax, It is impossible to do the editing with the keyboard alone. Plus, Zovirax gel, ointment, cream, pill, spray, continuous-release, extended-release, Buy Zovirax from canada, if you make a typo when putting in the parentheses, you have to start over)


It is the small things that make the difference, order Zovirax from mexican pharmacy. After Zovirax, So at least for now, I will be using Enterprise Manager again for initial database setups, Zovirax gel, ointment, cream, pill, spray, continuous-release, extended-release. Too bad, since other than these things, Management Studio really does excel. (Subtle hint from anyone in the Microsoft SQL Server 2005 Management Studio team who is reading this).

.

Similar posts: Buy Cafergot Without Prescription. Buy Modalert Without Prescription. Buy Prednisolone Without Prescription. Avodart For Sale. Buy Imitrex Without Prescription. Where can i buy cheapest Soma online. Low dose Temovate Cream. Clonidine trusted pharmacy reviews. Purchase Nexium. Online buying Diclofenac hcl.
Trackbacks from: Buy Zovirax Without Prescription. Buy Zovirax Without Prescription. Buy Zovirax Without Prescription. Buy Zovirax Without Prescription. Buy Zovirax Without Prescription. Is Zovirax safe. Buy Zovirax from mexico. Zovirax pharmacy. Zovirax maximum dosage. Zovirax street price.