Optimizing Storage Performance, Provisioning, and Manageability for Microsoft SQL Server

An IBM Redpaper publication



Abstract

Microsoft SQL Server has become very popular as a database environment driving a broad range of mid-level business applications, ranging from Customer Relationship Management (CRM) to eCommerce and from Enterprise Resource Planning (ERP) to supply chain integration. The combination of affordability, performance, ease of deployment, and sophisticated analytical features has led to a significant proliferation of SQL Server databases in many organizations. In many cases, these databases include applications that have become a critical component of business operations.

Unfortunately, in many cases these databases are stored in native internal or direct-attached storage that is spread over multiple Windows servers--a storage environment that cannot deliver the performance, scalability, availability and manageability required by mission critical data today. Issues can be compounded when server administrators, not database administrators (DBAs), are responsible for managing these database environments.

To optimize storage performance for SQL Server, organizations need a consolidated networked storage environment, well-matched to the price and performance characteristics of the database servers, that can meet the demanding service level requirements of the business and that can simplify the management of the distributed SQL Server database environment dramatically.

This IBM Redpaper describes the SQL Server benefits that are available from storage consolidation using best-in-class IP SAN (iSCSI) storage.

Table of contents

Not available.



Profile

Publish Date
29 August 2007


Rating: Not yet rated


Author(s)

IBM Form Number
REDP-4245-00

Number of pages
18