Key tasks and business insights for SQL Server2008

For database administrators facing heavy management tasks every day, improvements in product performance, especially in management performance, may be the most leap to them.

SQL Server 2008 Performance Promotion "Four Kings" are mission-critical platforms, dynamic development, beyond relational data and pervasive business insights. The first and fourth items are for data maintenance and management. SQL Server 2008 's promotion of mission-critical and business insights has greatly facilitated management simplification. The management tools and features of SQL Server have made a number of significant breakthroughs in this release.

It's all because of you--declarative Management Framework

SQL Server 2008 introduces the declarative Management Framework (DMF), a new policy-based management architecture designed for the SQL Server database engine, and policy-based management that effectively improves database performance. DMF is a policy-based system for managing one or more instances of SQL Server within a network. It enables you to enforce system configuration policies by leveraging SQL Server Management Studio to create policies to manage server entities.

The schema consists of three components: policy Management, policy creation, and explicit management (explicit administration). Policy Management and creation enables you to develop and implement policies across SQL Server instances, simplifying management, and reducing error occurrences. No matter what strategy you've developed, explicit management allows you to develop management operations in real time and apply to all servers,

Perhaps the most significant feature for DMF is that you can manage and enforce SQL Server installation policies across one or more servers. You can perform the same operation on more than one SQL Server at a time rather than on a separate server.

Using DMF to apply policies is very simple. You can easily select one or more managed target databases, or you can directly check whether the target database complies with a policy, or force the target database to follow this policy directly. These operations can be performed within the GUI console, and typically take only a few minutes to develop and perform these operations.

Managing the performance of the system

SQL Server 2008 introduces a number of new tools to improve and manage database performance. The standards and options for collecting performance data are broader, and a new centralized information base is provided to store and access the data. Evaluation and planning performance standards are simpler than in the past, especially when dealing with multiple database instances.

SQL Server 2008 also improves data compression techniques. Interested friends can compare the data compression performance of SQL Server 2005 to see if they can run faster to generate smaller compressed files. In general, however, data compression can store data more efficiently in the database and reduce storage requirements. Data compression can also significantly improve the performance of large I/O workloads, so that both data retrieval from the database and data in the database are performed more quickly.

Focus Explorer

SQL Server uses a new Resource Manager tool called Resource Governor that allows you to measure and control the allocation of resources. The resource manager can determine resources constraints and priorities based on different workloads. In other words, you can define the amount of server resources that each operation or process can take advantage of, so that the operation and process cannot take advantage of the amount of available resources you have preset. This allows you to perform multiple tasks at the same time without having to go down in the middle of an outage due to insufficient resources.

SQL Server 2008 also introduces a technology that becomes a hot-plug CPU, which allows you to add additional CPUs to a supported hardware platform without shutting down related application devices and software. But, to be honest, it's hard to say what kind of system should be added to the CPU during the run. If you can't turn off a database for the time being or wait until midnight to turn it off, the hot-swappable CPU feature will allow you to upgrade the database server without any difficulty. If you want to extend and rebuild a database on a faster system, hot-swappable CPUs will be a good choice for database administrators who want to save valuable time.

As a database administrator, you must enjoy the fun of these new features, especially those that make your day-to-day management life easier. Features such as the Resource Manager and new performance metrics tools provided by SQL Server 2008 enable administrators to compress work and save time more easily than any previous version of SQL Server.