Kbase P171034: FORCESEEK table hint with UPDATE lock hint on the MS SQL Server DataServer OE10.2B03
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/01/2011 |
|
Status: Unverified
GOAL:
FORCESEEK table hint with UPDATE lock hint on the MS SQL Server DataServer OE10.2B03
GOAL:
FORCESEEK table hint with UPDATE lock hint to minimize deadlock condition on the MS SQL Server 2008
FACT(s) (Environment):
MS SQL Server 2008
MS SQL Server 2008 R2
Windows Server 2008
OpenEdge 10.2B 32-bit
OpenEdge 10.2B 64-bit
OpenEdge 10.2B03 Service Pack
MS SQL DataServer
FIX:
OpenEdge OE10.2B03 Service Pack implemented FORCESEEK table hint with UPDATE lock hint on the MS SQL Server DataServer. In order for this new feature to be effective, you need to update the existing schema holder by just repulling all the tables again. Without Updating schema holder, this feature will not be effective. This feature will only work with MS SQL Server 2008 or higher. You may also want to use the SNAC 10 driver with MS SQL Server 2008 for optimal performance. Implementation of the FORCESEEK table hint with UPDATE lock hint resolves some deadlock issues related to update during heavy usage on the MS SQL Server Database.
If you would like to know details about the FORCESEEK table hint, read the MSDN article http://msdn.microsoft.com/en-us/library/bb510478.aspx.