Sunday, March 22, 2009

Storage Engine Architectural Overview

Overview
The original code was inherited from Sybase and designed for eight-megabyte Unix systems in 1983.These new formats improve manageability and scalability and allow the server to easily scale from low-end to high-end systems, improving performance and manageability.
Benefits
There are many benefits of the new on-disk layout, including:
• Improved scalability and integration with Windows NT Server
• Better performance with larger I/Os
• Stable record locators allow more indexes
• More indexes speed decision support queries
• Simpler data structures provide better quality
• Greater extensibility, so that subsequent releases will have a cleaner development process and new features are faster to implement

No comments:

 
ss_blog_claim=b2020e0f26362b8071fda24b7fed8308 ss_blog_claim=b2020e0f26362b8071fda24b7fed8308