SQL Server

MGA can provide a range of SQL Server Database Services including:

• Health Checks
• DBA Support
• Performance Analysis and Tuning
• Migration and Upgrade Support
• Disaster Recovery (Planning and Implementation)

Health Checks

Review client SQL Server databases to gather information of any database issues and database health concerns that could affect the database stability. Including preliminary discussions with the client to get a sense of any current SQL Server issues or hiccups they have been experiencing.

Create a plan to resolve SQL Server issues.

We can provide two levels of health checks:

• Initial or quick overview of general health of the sql server instance( 1 day)
• Detail health check report (5 days)

Issues may include:

• Error messages
• Stability
• Performance
• Frequent reboots
• No DR plans
• Running Old platform
• Lack of security and planning

Detailed Health Check

• Database Overview
• Infrastructure Overview
• Error messages
• Stability
• Performance
• Frequent reboots
• No DR plans
• Running Old platform
• Lack of security and planning
• Server workload
• Documentation, support and licencing
• Capacity Management and Scalability
• Back up and Recovery
• Security
• High Availability
• Robustness

DBA Support

Work with the client team on agreed engagement time offering our MGA SQL Server clients high level SQL Server database support, management and maintenance. MGA SQL Server support helps you extract maximum potential from your database environments through design and implementation of an infrastructure that will ensure your business systems are always up and running. MGA works with you to assess the best outcomes and implement strategies to achieve them, while working with your team.

SQL Server Database Support is available as a Service Agreement.

Performance Analysis and Tuning

Ask client first if they have or encountered issues such as:

• Deadlocks
• Locking and blocking
• Poor query performance
• Slow queries
• Incorrect indexes
• IO issues
• CPU bottlenecks
• Troublesome SQL Server configurations
• Problems with memory allocation

Demonstrate how they may diagnose and attend to any of the above issues.

Migration and Upgrade Support

• Oracle to SQL Server
• Upgrade of SQL Server within its family suite.

Disaster Recovery (Planning and Implementation)

Implement and plan DR such as Log shipping, Database mirroring and high availability solutions such as SQL Server clusters.

For more information on our SQL Server Database Services, or any other MGA Products & Services, please contact us.