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 most 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. Outer Edge 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. Outer Edge’s 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. To be used for later comparisons.
- 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.
- Ask a DBA: Light
Get 1 hour of DBA time to ask questions, vet ideas, or general advice. If more time is needed, we will work with you to develop a custom program.
- 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. We can help keep you current and plan and perform your SQL Server upgrade.