HP PolyServe Software for Microsoft SQL Server: A Simple Approach to SQL Server Consolidation

White Paper Published By: HP

The success of SQL Server in recent years has produced a phenomenon of SQL Server sprawl - the uncoordinated deployment of tens, hundreds or even thousands of database servers. The result has been low levels of utilization, poor availability and, most importantly, an enormous management burden inflicted on many IT departments. There is an acute need for a way to deploy SQL Server that allows capacity to be matched appropriately to need, that provides high availability without introducing extra complexity and extra cost, and that actually simplifies the life of administrators.

Tags :

sql server, sql, microsoft sql server, microsoft, hp, polyserve, migration, infrastructure

Published:	Jul 25, 2008
Type:	White Paper
Length:	29 pages

HP PolyServe Software for Microsoft SQL Server: A highly
available, flexible, simple approach to SQL Server
consolidation white paper
How to achieve a 50% reduction in total cost of ownership with shared data clustering
Introduction: The growth of SQL Server in the enterprise........................................................................... 2 Traditional SQL Server environments and SQL sprawl .............................................................................. 3 The costs of SQL sprawl........................................................................................................................ 4 Low levels of utilization..................................................................................................................... 4 Inadequate availability ..................................................................................................................... 6 Management overhead..................................................................................................................... 7 Initial responses to SQL Server sprawl .................................................................................................... 7 Storage area networks...................................................................................................................... 7 Consolidation on large servers .......................................................................................................... 8 Server virtualization.......................................................................................................................... 9 A better solution: HP PolyServe Software for Microsoft SQL Server........................................................... 10 Shared data makes it possible......................................................................................................... 11 HP PolyServe Software for Microsoft SQL Server ................................................................................... 13 Matrix Server................................................................................................................................. 14 Cluster file system........................................................................................................................... 15 High-Availability and application control engine................................................................................ 15 Matrix Manager ............................................................................................................................ 17 Volume Manager ........................................................................................................................... 18 HP PolyServe Software for Microsoft SQL Server................................................................................ 19 Benefits of HP PolyServe Software for Microsoft SQL Server.................................................................... 21 Dynamic Rehosting: Consolidation without tears ................................................................................ 21 Easy, universal high availability....................................................................................................... 22 Maintenance off-loading ................................................................................................................. 23 Simplified management .................................................................................................................. 23 Supportability................................................................................................................................ 25 Initial responses revisited .................................................................................................................... 26 Total cost of ownership ................................................................................................................... 27 Conclusion........................................................................................................................................ 28 For more information.......................................................................................................................... 29 The success of SQL Server in recent years has produced a phenomenon of SQL Server sprawl-the uncoordinated deployment of tens, hundreds or even thousands of database servers. The resul... [download for more]

Browse Technology Topics

Data Center Virtualization, Cloud Computing, Infrastructure, Design and Facilities... more, Power and Cooling, Green Computing less		Data Management Application Integration, Analytical Applications, Business Intelligence... more, Configuration Management, Database Development, Data Integration, Data Mining, Data Protection, Data Quality, Data Replication, Database Security, EDI, SOAP, Service Oriented Architecture, Web Service Management, Data Warehousing less
Electronics Analog Communications, Digital Signal Processing, Electronic Design Automation... more, System On A Chip, Electronic Test and Measurement, Embedded Design, Boards & Modules, Embedded Systems and Networking, Electromechanical & Mechanical, Optoelectonics & Displays, Packaging and Interconnects, Passive & Discrete Components, Power Sources & Conditioning Devices, Integrated Circuits and Semiconductors, Sensors & Actuators less		Enterprise Applications Application Integration, Application Performance Management... more, Best Practices, Business Activity Monitoring, Business Analytics, Business Integration, Business Intelligence, Business Management, Business Metrics, Business Process Automation, Business Process Management, Call Center Management, Call Center Software, Change Management, Corporate Governance, Customer Interaction Service, Customer Relationship Management, Customer Satisfaction, Customer Service, EBusiness, Enterprise Resource Planning, Enterprise Software, EProcurement, Extranets, Groupware Workflow, HIPAA Compliance, IP Faxing, IT Spending, Marketing Automation, Performance Testing, Product Lifecycle Management, Project Management, Return On Investment, Risk Management, Sales & Marketing Software, Sales Automation, Server Virtualization, Simulation Software, Supply Chain Management, System Management Software, Total Cost of Ownership, Video Conferencing, Voice Recognition, Voice Over IP, Workforce Management, Incentive Compensation, Spend Management, Manufacturing Execution Systems, International Computing less
Human Resource Technology Human Resources Services, Payroll Software, Time and Attendance Software... more, Workforce Management Software, Financial Management, Employee Monitoring Software, Employee Training Software, Recruiting Software/Services, Employee Performance Management, ELearning, Benefits Management, Expense Management less		IT Career Advancement Cisco Certification, Microsoft Certification, Linux Certification... more, Network Security Certification, Software Development Certification less
IT Management Employee Performance, ITIL, Productivity, Project Management... more, Software Compliance, Sarbanes Oxley Compliance, Service Management, Desktop Management less		Knowledge Management Collaboration, Collaborative Commerce, Contact Management... more, Content Delivery, Content Integration, Content Management System, Corporate Portals, Customer Experience Management, Document Management, Information Management, Intranets, Messaging, Records Management, Search And Retrieval, Search Engines, Secure Content Management, SLA less
Networking Active Directory, Bandwidth Management, Convergence, Distributed Computing... more, Ethernet Networking, Fibre Channel, Gigabit Networking, Governance, Grid Computing, Infrastructure, Internetworking Hardware, Interoperability, IP Networks, IP Telephony, Local Area Networking, Load Balancing, Migration, Monitoring, Network Architecture, Network Management, Network Performance, Network Performance Management, Network Provisioning, Network Security, OLAP, Optical Networking, Quality Of Service, Remote Access, Remote Network Management, Server Hardware, Servers, Small Business Networks, TCP/IP Protocol, Test And Measurement, Traffic Management, Tunneling, Utility Computing, VPN, Wide Area Networks, Green Computing, Cloud Computing, Power and Cooling, Data Center Design and Management, Colocation and Web Hosting less		Platforms AS/400, Domino, Linux, Microsoft Exchange, Oracle, PeopleSoft... more, SAP, Siebel, Solaris, Tivoli, Unix, Web Sphere, Windows, Windows Server less
Security Access Control, Anti Spam, Anti Spyware, Anti Virus, Application Security... more, Auditing, Authentication, Biometrics, Business Continuity, Compliance, DDoS, Disaster Recovery, Email Security, Encryption, Firewalls, Hacker Detection, High Availability, Identity Management, Internet Security, Intrusion Detection, Intrusion Prevention, IPSec, Network Security Appliance, Password Management, Patch Management, Phishing, PKI, Policy Based Management, Security Management, Security Policies, Single Sign On, SSL, Secure Instant Messaging, Web Service Security, PCI Compliance, Vulnerability Management less		Software Development .NET, C++, Database Development, Java, Middleware, Open Source... more, Software Outsourcing, Quality Assurance, Scripting, SOAP, Software Testing, Visual Basic, Web Development, Web Services, Web Service Security, XML less
Storage Backup And Recovery, Blade Servers, Clustering, IP Storage... more, ISCSI, Network Attached Storage, RAID, Storage Area Networks, Storage Management, Storage Virtualization, Email Archiving, Data Deduplication less		Wireless 802.11, Bluetooth, CDMA, GPS, Mobile Computing, Mobile Data Systems... more, Mobile Workers, PDA, RFID, Smart Phones, WiFi, Wireless Application Software, Wireless Communications, Wireless Hardware, Wireless Infrastructure, Wireless Messaging, Wireless Phones, Wireless Security, Wireless Service Providers, WLAN less