First let me apologize if this has been asked before.
We have a database we are experiencing some major locking issues with. We noticed some long wait times and a large number of waiting tasks. Upon following the session IDs all the way back to the head blocking session ID that session ID is still marked as the head block, but has no SQL Command associated with it. The only thing associated with the session is "SET TRANSACTION ISOLATION LEVEL READ COMMITTED"
Our web application is Cold Fusion Based hitting a SQL Server 2008 Server.
Please let me know where to look and what to look for.
In 99% of the cases concurrency and blocking issues related with non-optimized queries. Take a look at the sql statements system is executing and see is plans are not optimal (table/index scans instead
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…