Jump to content

Large Enterprise Business

Products & Services
Support & Drivers
Solutions

Customer Focused Testing Solutions

Microsoft SQL Server
Technical webinars
Content starts here

Looking for solutions around business challenges related to Microsoft SQL Server? Seeking best practice recommendations for configuration, consolidation, management and availability of enterprise data? Our CFT SQL Server portfolio offers detailed answers and insights into the solution that might be right for your business.

Microsoft SQL Server solutions

High Availability and Server Optimisation

This solution: Offers you: Resources:
SQL Server 2008 remote replication and high availability using HP Continuous Access EVA and ProLiant Servers Recommendations and best practices for implementing disaster recovery for SQL Server 2008 in a clustered HP blade server/ – EVA8100 environment with Continuous Access EVA White papers Additional resources
Array-based replication and host-based mirroring technologies for Microsoft SQL Server 2005 Recommendations and best practices for implementing disaster recovery solutions in a clustered HP blade server/EVA8x00 environment with either Continuous Access EVA or SQL Database Mirroring. White papers Additional resources

Best Practices

This solution: Offers you: Resources:
SQL 2008 Data Warehouse best practices for HP XP24000 Storage, HP ProLiant DL785 G5 Server and HP Integrity rx8640 Server Provides database administrators, storage architects, and system architects with test-proven best practices to facilitate the best decisions for their environments. White papers
Online Transaction Processing (OLTP) Best Practices for the HP MSA2000 Storage Array with Microsoft SQL Server 2008 Storage design considerations, recommendations and best practices for the deployment of a mid-range SQL 2008 OLTP environment across multiple databases on the MSA2212fc with the Simple SAN Connection Kit. White papers
SQL Server 2008 in an OLTP environment, including consolidation of multiple databases, using HP EVA4400 storage and HP Proliant Servers Recommendations and best practices encompassing the configuration, design, and deployment of a mid-range SQL 2008 OLTP environment with 200 concurrent users across 10 databases White papers
SQL Server 2008 Data Warehouse on HP MSA2000 Storage Configuration, performance, and technical best practices for deployment of a SQL Server 2008 data warehouse with HP MSA2000 storage and HP ProLiant servers. Includes analysis of new SQL 2008 features. White papers Additional resources
Optimising HP servers with Microsoft SQL Server 2008 Description of how SQL Server 2008, specifically on 64-bit platforms, together with the resources and technologies available on HP servers, offers solutions for consolidating corporate data White papers
SQL Server 2008 backup compression, Resource Governor, and transparent data encryption Recommendations and operational guidelines for using three new features of SQL Server 2008 on ProLiant servers and HP EVA storage: backup compression, Resource Governor and transparent data encryption. White papers Additional resources
Microsoft SQL Server 2005 databases with HP servers, storage BI and server integration Considerations for HP Integrity and ProLiant servers, EVA storage and management software with SQL Server Integration Services (SSIS). White papers Additional resources
Using SQL Server 2008 Data Compression with HP ProLiant and Integrity servers and HP EVA 8x00 Description of data compression’s impact on OLTP and data warehouse workloads plus recommendations and guidelines. Following tested technical best practices in this paper can help optimise performance and save disk space. White papers

Backup and recovery

This solution: Offers you: Resources:
Backup and recovery for Microsoft SQL Server 2005
Best practices for implementing backup and recovery for the EVA8x00 using Linear Tape-Open tape, disk-to-disk and virtual tape plus recommendations for selecting the proper backup and recovery method using HP Data Protector software
White papers Additional resources