TAILIEUCHUNG - Microsoft SQL Server 2008 R2 Unleashed- P233

Microsoft SQL Server 2008 R2 Unleashed- P233:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2284 CHAPTER 55 Configuring Tuning and Optimizing SQL Server Options 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 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 IO was used to specify the number of simultaneous disk I O requests that SQL Server and earlier versions could submit to the Windows OS during a checkpoint operation. It invariably helped overall throughput on systems that used RAID devices that had extensive disk cache mechanisms. SQL Server 2008 adjusts these options automatically. Configuration Options and Performance The following sections explain essential information about many of the most significant SQL Server configuration options and their impact on SQL Server performance. Some of the options don t have performance implications and therefore may not be addressed in much detail or at all. As part of each option s explanation an indication of whether the option is advanced or basic is given along with the option s default value and whether the option is self-configuring. Recommended values are usually indicated for the different types of generalized application processing that the SQL Server is used for that is OLTP OLAP data warehouse and mixed . For some configuration options there may not be recommended values but perhaps there may be notes that further explain how they can be used. Remember that there are 70 configuration options this chapter focuses on the essential ones in alphabetical order how they are listed in SQL Server . access check cache bucket count Type Advanced Option Default Value 0 When any database object is accessed by SQL Server the access check is cached in an internal structure named access check result cache. The access check cache bucket count option controls .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.