We manage your SQL Server databases on an ongoing basis, whether on your own server, on Azure SQL or on Amazon RDS: 24/7 monitoring, weekly and monthly reviews, incident management and evolutionary support, without you having to hire an in-house DBA.
Monitoring
We continuously monitor your SQL Server environment with Coyote Monitor, combining monitoring, performance analysis and periodic configuration reviews.
Management
We handle operational tasks such as SQL Agent Jobs, updates and patching (on Azure SQL and Amazon RDS, version control and service tiers), support new business needs and apply continuous improvements based on our analyses.
Status report of the managed instances:
- Overall server status
- Unhandled errors
- Failed jobs
- Backup status
- Restore chain status
- Free disk space
- Server memory status
In-depth analysis of system performance and evolution:
- Performance trends: every month we compare key indicators, wait times and connections to spot trends before they become a problem
- Slow and most-executed queries: we identify the queries and procedures that hurt your system the most and those that run most often
- Indexes: we recommend missing ones and remove those that are unused or duplicated
- Tables and storage: we detect which tables need updated statistics, a reorganized structure or compression to gain performance and space
- Resource usage and latency: we track CPU, memory, disk and latency per database to anticipate when you will need more capacity
- Available updates for SQL Server and Windows
What we offer
The alert system detects problems automatically so we can act before they affect production.
Every incident follows a clear workflow:
- Information gathering
- Logging and classification
- Resolution by level: L1, L2 or L3
- Closure and documentation
We support your team with:
- New architectures and configurations
- Additional installations
- T-SQL code optimization
- Parallel projects
- Performance tuning
- Improvements recommended in the reviews
24/7 SUPPORT
Proactive 24/7 monitoring. We resolve incidents before they affect you.
24/7 administration and monitoring of your SQL Server, Azure SQL or Amazon RDS for SQL Server.
DBA as a Service is an ongoing, proactive SQL Server administration service, available 24×7, that includes monitoring with Coyote Monitor, documented weekly and monthly reviews, incident management and evolutionary support. Instead of hiring an in-house DBA, you get a specialized team that constantly watches over and optimizes your instances, without you having to manage that role yourself.
The Health Check is a one-off 4-week audit that diagnoses and fixes the state of your SQL Server at a given point in time. DBA as a Service is ongoing: once the environment is optimized, our team keeps it that way permanently, with monitoring, periodic reviews and 24×7 support. The Health Check is a great starting point: it leaves your environment optimized, and DBA as a Service makes sure it stays that way.
The 24×7 service covers immediate response to serious incidents outside business hours, including weekends and public holidays.
We manage SQL Server on your own server, Azure SQL and Amazon RDS for SQL Server, with monitoring, reviews and incident handling adapted to each environment.
No. We can be your DBA team or reinforce the one you already have, supporting your team with new architectures, optimization and parallel projects.
We start with a kick-off meeting where we introduce the team that will work with you, define the contacts and agree on the support escalation levels, both on Aleson’s side and yours. If your environment does not come from a Health Check, we first run an Onboarding to configure it according to best practices. From then on we activate 24/7 monitoring with Coyote Monitor and give you access. Once the server is properly configured, the weekly and monthly reviews begin.