Database/Database Server Blocking. 
Author Message
 Database/Database Server Blocking.

Hi All,

Since upgrading our SQL server to the latest service pack (6.5 SP5a) we've
been experiencing unexpected
systematic locking/blocking. Prior to the service pack, there where no such
problems. It also is fine ironically in MSSQL7.

The problem occurs in the following sequence:

A VC++ app using DAO opens a control table (table A) is opened for
read-write access in a database.
The table is updated and then closed. Another table (B) is then opened for
exclusive write access (dbConsistent) in the same database, slowly populates
it. This process can take several minutes.
Upon completion, control table A is opened again, updated and closed.

Concurrently a second (monitoring) application periodically opens, reads and
closes the same control table (A) with read-only access. However, this
second application is blocked by the first appplication while table B is
being populated, despite all connections to table A having been closed.

The number of outstanding locks are typically upto 15,000. Utilising a begin
and end transaction in VC++.

Futher, access to the SQL Server (not the same database) is blocked until
the first application completes.
Applications blocked include:

1. Other VB and VC++ App's accessing other databases.
2. SQL Enterprise Manager whilst connecting to the server.
3. SQL Enterprise Manager whilst attempting to refresh the 'Current
Activity' Statistics.
4. NT Performance monitor accessing SQL Server Statistics.
5. Access to the Database via 'MS Access'.

Has anyone experienced this problem and/or found a solution ?

Paul



Sun, 14 Oct 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to Backup the Contacts Database、Tasks Database、Appointment Database

2. Developing one DLL in two environments (Test server+database, Production server+database)- VC++ 6.0, OLEDB, ATL COM, ASP

3. Developing one DLL in two environments (Test server+database, Production server+database)- VC++ 6.0, OLEDB, ATL COM, ASP

4. Error in VC5.0 DATABASE project trying to use a DATABASE DIAGRAM

5. alt.comp.databases,comp.databases,comp.databases.ms-sqlserver

6. Creating a new database with DAO (Other than Microsoft Jet Database)

7. How do you access remote databases where the database is not registed in the local ODBC

8. Database settings -- Visual C++ used with Visual FoxPro database

9. How to access Custom Database Properties of a Access 97 database programmatically

10. Create database without using VC++ database tools

11. Querying Database with C# and SQL Server

12. SQL Server and Oracle database export/import

 

 
Powered by phpBB® Forum Software