��้องอาศัยการเริ่มต้น warm หรือนำล็อกธุรกรรมไปข้างหน้า


Question3
qควร SQL Server ทำการแคช หรือควรคอนโทรลเลอร์ดิสก์ทำการแคช

ก.The answer depends on which method is faster. Our experiments have shown that the SQL Server cache is more efficient than the operating system disk cache. However, we have no way of knowing whether or not it is more efficient than the caching used by a particular type of disk controller. The SQL Server cache probably does not work as fast as a hardware cache; however, it has "inside knowledge" and can work smarter.

Run a representative workload with the SQL Server memory parameter set to the minimum value that will support the number of users required (with the disk controller cache active) for your installation. Then try it with the memory parameter set to that value plus the amount of RAM in the disk controller cache (with the disk controller cache deactivated). For a truly accurate comparison, the number of pages in the procedure cache should be equal in both cases. This takes some juggling because the size of the procedure cache is specified in percent of the total cache size, while the size of the total cache is specified by the memory parameter and the number of user connections parameter. The total cache size is whatever is left after the 42K per user connection has been carved out of the space specified by the memory parameter. The remainder is divided between the procedure and data page cache according to the procedure cache parameter.
SQL Server requires systems to support ‘ guaranteed delivery to stable media ’ as outlined under the Microsoft SQL Server Always-On Storage Solution Review program. FoFor more information about the input and output requirements for the SQL Server database engine, click the following article number to view the article in the Microsoft Knowledge Base:
967576Microsoft SQL Server Database Engine Input/Output Requirements
GP-fault

คำเตือน: บทความนี้ได้รับการแปลโดยอัตโนมัติ

คุณสมบัติ

รหัสบทความ: 46091 - การตรวจสอบครั้งสุดท้าย: 01/06/2011 04:27:00 - ฉบับแก้ไข: 2.0

  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
  • kbhardware kbmt KB46091 KbMtth
คำติชม