PolyServe for SQL Server

1. PolyServe for SQL Server Enterprise Research Infrastructure Services

2. Microsoft SQL Server and Research • TSO • DIPR • PolyServe • Discussion of database services Topics

3. Current customers with TSO? • Has become enterprise capable • Simple, intuitive GUI Microsoft SQL Server

4. Technical Services and Operations offers SQL 2005 and 2008 hosting • Free within defined thresholds: • No local apps to the DB server • Max 10GB storage • Max 25 concurrent connections • Max db_owner privs (no negotiated sysadmin access at reduced service level) TSO’s Shared SQL Solution

5. Structured and non-structured data: • Lives outside of VM • 30 day recovery window • PostgreSQL and MySQL • Oracle Database: Real Application Clusters • Microsoft SQL Server: PolyServe for MS SQL DIPR: Discovery Informatics Platform for Research

6. 2 primary customer target audiences • Typical research TSO customers with larger size, bandwidth or concurrency needs than shared standards allow • VLDB implementations with shared R/O datasets (CITED) Polyserve for SQL Server

7. Ease of deployment and patching • Simplified management • Currently in pilot with SQL2005 and SQL2008 instances • Provides limited HA • Rolling upgrades Polyserve for SQL - Benefits

8. Industry proven cluster filesystem • Performance, functionality and manageability improvements over NTFS (used in MSCS) • Same filesystem technology used with ERIS HPC Polyserve FS

9. Polyserve for SQL Server

10. Current: • 6 X BL 460c G6 Nehalem blades • 48GB RAM/blade • EVA 8100 and MSA 2000 storage • Windows 2008 SP2 • Expansion: • 6 more identically prepared BL 460c G6s • Waiting for support of Windows 2008 R2 Polyserve for SQL - Config

11. Polyserve for SQL Server

12. Demo… what would you like to see? Polyserver for SQL - Demo

13. Research Computing Links: • http://rc.partners.org • http://research.partners.org Technical Resources: • http://h18000.www1.hp.com/products/storage/software/polyserve/db_utility/sql/index.html References