Fully Managed SQL Server Services
Does sluggish system performance have you searching for causes in all directions? Many companies take the route of buying new hardware or pointing to the applications, but the management of the SQL Server is often the overlooked culprit. SQL Server is typically the most important server in any environment as it stores and serves data to almost everyone in the organization. The challenge for most organizations is that their IT departments do not have SQL expertise or the budget to properly manage and optimize SQL Server. OET Advisors™ understands these realities and offers affordable services that leverage our senior Database Administrators and System Engineers to overcome this challenge. We ensure your SQL Server investment is running optimally through baseline health checks, setting up and monitoring regular automated maintenance jobs, and monthly patch reviews. OET Advisors’ SQL Services include:
- SQL Server Baseline
Run a series of queries to get a baseline of server settings, temp file configuration, Service Pack/Version support issues, and index fragmentation initial settings.
- SQL Server Security review
- Review/Setup SQL Server Maintenance
Index rebuilds/tuning/de-fragmenting/recompile objects
- Performance Summary
3-4 times per month run a light trace and quickly analyze the results to maintain optimal performance.
- Review VMWare Settings to make sure they’re optimal for SQL Server.
- Review Windows/Cluster Settings to make sure they are optimal for SQL Server.
Additionally, we perform project based services based on your requirements.
- Performance Study
Collect detailed trace information for a period of time to look for long running queries, give results, make recommendations, implement changes.
- Upgrade SQL Server
As Microsoft releases new versions of SQL Server, support for older versions are queued up for de-support. This can be cumbersome for organizations to monitor and is often overlooked. Indeed support for Microsoft’s SQL Server 2008/2008 R2 ends on July 9, 2019! This date signals the end of regular patches and security updates for any new viruses or security problems, leaving your systems and data exposed and vulnerable to new and emerging security threats. We can help keep you current and turn end of Microsoft support into strategic advantage.