Whitepaper : Moving SQL Server to a Virtual Platform
Introduction:
This whitepaper is a guide for DBAs on moving SQL Server from a physical environment to a virtual environment. Virtualization has become a major topic for Database Administrators. In the early days of virtualization, SQL Server was not considered suitable for virtualizing. However, the virtual platforms have matured, and virtualizing SQL Server is a widely accepted practice. Virtualization is now a critical part of enterprise environments to varying degrees.
Virtualization also plays a major role in consolidation, especially in large enterprises. Virtual machines (VMs) offer a way to consolidate many small physical servers into a few large servers while still maintaining separation of the workloads. A well-tested, successful approach to virtualization is to start slow and grow your virtual platform. Combine this approach with proper planning and good standards and practices to ensure a successful mover to VMs.
Topics :
Products :
Introduction:
This whitepaper is a guide for DBAs on moving SQL Server from a physical environment to a virtual environment. Virtualization has become a major topic for Database Administrators. In the early days of virtualization, SQL Server was not considered suitable for virtualizing. However, the virtual platforms have matured, and virtualizing SQL Server is a widely accepted practice. Virtualization is now a critical part of enterprise environments to varying degrees.
Virtualization also plays a major role in consolidation, especially in large enterprises. Virtual machines (VMs) offer a way to consolidate many small physical servers into a few large servers while still maintaining separation of the workloads. A well-tested, successful approach to virtualization is to start slow and grow your virtual platform. Combine this approach with proper planning and good standards and practices to ensure a successful mover to VMs.
Topics :
Products :
Robert L. Davis
Robert L. Davis was a senior database administrator and technical lead at Microsoft. He had over 11 years of experience with SQL Server, including expertise in high availability, disaster recovery, performance tuning, and data architecture. Robert was a speaker and trainer. He was also a writer for SQL Server Magazine and co-authored “Pro SQL Server 2008 Mirroring” by Apress.
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.