• Advanced table and index partitioning
• Snapshot isolation
• A 15% performance improvement from the Windows Scheduler and a 50% improvement in server performance from new XeonMP processors

At the same time SQL Server's availability and reliability has improved due to:

• Better options for clustering
• New capabilities for database mirroring, database snapshots, and partitioning
• Improved T-SQL exception handling, enhanced XML support, tighter integration with the Microsoft .NET Framework Common Language Runtime (CLR) and advanced messaging capabilities in Service Broker

To read about the financial savings from SQL Server and the added benefit of a new migration tool read CIOview's latest white paper
The Business Value of Migrating from Oracle to SQL Server 2005.

In a word: workload. Even in the well-defined world of database applications, your workload can have as much as a 90-fold effect on the database resources required. Workload-related differences in performance have a follow-on effect since your database software license, operations staff, and even physical hardware and facilities costs increase as you add more CPUs. As a result your workload is key in dictating your TCO. Understanding the performance implications of your workload - and knowing the performance metrics to use -- is absolutely crucial if you want to avoid over or under-purchasing hardware and every other item driven by the number of servers and CPUs installed. To read about the TCO and performance implications of different workloads in the database world get the white paper.

With the relaunch of eUpdate, we have added some features to better serve you. Now you can choose categories that reflect your interests, so that you only receive emails from CIOview that match your chosen interest categories. Update your profile now!