We have an instance of Microsoft SQL Server running on an Azure VM that contains millions of rows across several tables. While our day-to-day operations are running within acceptable performance parameters, recently some queries have started taking exponentially longer to run to the point of not being able to complete them in a timely manner. We have some other issues we need to address as well.
We need someone to help us with the following:
- Identify and correct the cause of the performance issues we're seeing across multiple queries
- Review, recommend and implement regular DB maintenance procedures
- Review, recommend and implement changes to any backup strategies
This DB is our production database and as such, must remain 100% operational at all times.