SQL Server Health and Azure Migration Assessment

Benefits of a SQL Server Health & Azure Migration Assessment

Emergent Software’s SQL Server Health & Azure Migration Assessment helps mitigate data loss, improve performance and reliability, enhance security, and identify potential cost savings. This comprehensive evaluation ensures your SQL Server environment is optimized and ready for a seamless migration to Azure.

• Mitigate Data Loss
  Ensure backups meet RPO/RTO requirements and detect database corruption early.
  
  
• Improve Performance
  Optimize server configuration and implement proper indexes.
  
  
• Enhance Reliability
  Verify system setup and apply recommended patches.
  
  
• Boost Security
  Identify logins with elevated privileges and strengthen security measures.
  
  
• Achieve Cost Savings
  "Right-size" your environment to optimize resource use and reduce costs.
  
  

Server Health & Azure Migration Assessment includes:

• Data Loss Mitigation
  • Ensure your backups meet your RPO/RTO requirements.
  • Ensure database corruption checks are being performed regularly.
• Performance
  • Optimize memory usage and allocation.
  • Align system configuration settings such as MAXDOP and cost threshold for parallelism with industry standards.
  • Identify and resolve bottlenecks by thoroughly analyzing index, CPU, memory, and I/O usage patterns.
• Reliability
  • Check system setup to ensure data, log, and temp files are not on the C: drive and are allocated properly.
  • Ensure the latest security and performance enhancements are being taken advantage of by comparing the server's patch level with the most recent available from Microsoft.
  • Improve business continuity by validating the correct service accounts are assigned ownership roles on databases, agent jobs, and endpoints.
• Security
  • Flag accounts with system admin and other elevated privileges.
  • Provide a list of database owners that are not tied to the SA login.
  • Provide recommendations for utilizing Defender for Cloud for SQL Server.
• Azure Migration Preparations
  • Identify potential challenges migrating to SQL Server on an Azure VM, Azure SQL Managed Instance, or Azure SQL Database.
  • Provide SKU recommendations and cost estimates.
  • Consider Azure-Enabled SQL Server for hybrid environments.
• SQL Licensing
  • Review current SQL licenses owned and make cost savings recommendations through leveraging SQL options in Azure.
• Index Health
  • Evaluate index usage and fragmentation.
  • Look for optimization opportunities.
  • Provide recommendations on index maintenance tasks.
• Common Misconfiguration Review
  • Identify default settings left unchanged.
  • Detect unnecessary services and ports left open.
  • Check for improper file and directory permissions.