The information in this article applies to:
BUG #: 17962, 17978 (SQLBUG_65) SYMPTOMS
Using the sp_tableoption system stored procedure or DBCC PINTABLE to pin a
table in memory can incorrectly lead to LRU and LazyWriter problems if the
table is used in a JOIN query and the NOLOCK optimizer hint is also
included.
WORKAROUND
To work around this problem, run the sp_tableoption system stored procedure
and set the pintable option to false.
STATUSMicrosoft has confirmed this to be a problem in SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 5a
for Microsoft SQL Server version 6.5. For information about
downloading and installing the latest SQL Server Service Pack, see
http://support.microsoft.com/support/sql/.
MORE INFORMATION
The documentation on the use of sp_tableoption with the pintable option
states that if the table exceeds the data cache size it can lead to data
cache depletion. The symptoms that occur with this bug indicate that even
though the table is clearly smaller than data cache, WARNING messages are
still written in the error log. Additional query words: sp sp5prodsql errorlog
Keywords : SSrvGen SSrvTran_SQL kbbug6.50 kbfix6.50.SP5 |
Last Reviewed: November 17, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |