July 28, 2003 at 8:53 pm
Hi, we are on SQL 2000 server sp3a on w2k sp3
we are having problen with an aplication, is 65% compatible and I want to know if there are any uncompativility between the way sql 6.5 manage the locks and sql 2000,
thanks in advance
best regards
July 28, 2003 at 9:31 pm
SQL locking changed from 6.5 to 7.0, and less so (if at all) from 7.0 to 2000. The following is from SQL 7.0 BOL.
quote:
The locking subsystem has changed significantly. Most importantly, SQL Server 7.0 now supports full row-level locking for both data rows and index entries. The SQL Server 7.0 lock manager has been optimized to complete lock requests faster and with less internal synchronization. Many OLTP applications can experience increased concurrency, especially when applications append rows to tables and indexes.The SQL Server 7.0 lock manager adjusts the resources it uses for larger databases dynamically, eliminating the need to adjust the locks server configuration option manually. SQL Server 7.0 chooses automatically between page locking (preferable for table scans) and row-level locking (preferable for inserting, updating, and deleting data).
I don't know if that helps at all, but to better understand the locking subsystem you may have to refer to a specialised SQL 7.0 text. Eg. Inside SQL Server 7.0, or SQL Server 7.0 Unleashed.
Cheers,
- Mark
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply