Obsolete Configuration Options
Many configuration options available in SQL Server 7.0 or SQL Server 2000 have become obsolete or do not function any longer. Some options, such as time slice, were introduced in SQL Server 7.0 and then immediately became obsolete.
The following configuration options are obsolete in SQL Server 2008:
• Allow Update (remains listed but cannot be set)
• set working set size (remains listed but has no effect)
• Open Objects (remains listed but has no effect)
From a historical perspective, one of the all-time favorite options in SQL Server 7.0 was max async IO. The reason that option became obsolete is that it is completely automated with SQL Server 2000, SQL Server 2005, and SQL Server 2008. Previously, max async ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
