MS SQL Server Administration — from €79/mo

Hand SQL Server to engineers — we remove blocking, set up backups with point-in-time restore. Plans from €79/mo

Order SQL Server maintenance
Microsoft SQL Server maintenance

MS SQL Server administration is the maintenance of your Microsoft SQL Server by our engineers: an audit of indexes and statistics, maintenance plans, backups with transaction logs and point-in-time restore, and analysis of blocking and deadlocks. After that the server lives under 24/7 monitoring. Plans from €79/mo: Mini — 4 hours of work per month, Pro — 10 hours, Max — 25 hours. This is a maintenance service — the server and the databases remain yours. Other database engines — MySQL, PostgreSQL, MongoDB — are covered by our database administration service.

Plans

MS SQL Server administration. Mini — 4 hours of work per month, Pro — 10 hours, Max — 25 hours; beyond the plan — €19/h.

Mini covers one server and a small monthly workload; Pro adds 10 hours of work per month and priority support for several instances. Transparent monthly billing. Max gives you 25 hours of work per month with priority response and regular audits.

79 mo

Server Admin Mini

4 hours of work per month
OS/software setup and updates
24/7 monitoring
Incident response
Beyond the plan — €19/h
429 mo

Server Admin Max

25 hours of work per month
Everything in Pro
Priority response
Regular audits and reports
Beyond the plan — €19/h
1

Maintenance plans

We configure SQL Server Agent jobs: index rebuilds, statistics updates and scheduled database integrity checks.

2

Point-in-time backups

Full and differential backups plus transaction logs: the database can be restored to the exact minute. Copies are stored separately and verified by test restores.

3

24/7 monitoring

We watch the load, blocking, agent jobs and free space for databases and logs — and respond to incidents at any hour.

How we maintain your SQL Server

1

SQL Server audit

We examine indexes, statistics, execution plans of heavy queries, memory and tempdb settings, the recovery model and the current backups.

2

Setup and optimization

We configure maintenance plans and backups with transaction logs, fix memory and tempdb settings and speed up problem queries.

3

24/7 support

We monitor the instance around the clock, install updates in an agreed window and respond to incidents and load growth.

A one-off SQL Server task?

A one-off SQL Server task?

You do not have to be our client. Queries are slow, the transaction log has ballooned, backups need setting up or a database needs restoring? Order the 1 hour of work package for €39.50: you pay for one job — we do it.

Send us access to the server and we will check whether the task fits into one hour. If it does not, we will suggest the right administration plan. No account required.

Related services: database administration, 1C administration, clusters and replication.

Order 1 hour of work — €39.50

Frequently asked questions

Didn't find your answer?
Write to us via the contact page.

Production editions from Express to Enterprise, on Windows and on Linux: setup, maintenance plans, backups and tuning. The version and edition are recorded during the audit.

Yes. Full and differential backups plus transaction log backups let us restore the database to the exact minute. Restores are verified on a test database, not on paper.

Most often the database runs in the full recovery model while log backups are not configured — the file grows until the log starts being saved. We set up log backups and the growth stops.

Yes. We read the execution plans, add missing indexes and refresh statistics. Often fixing one query brings the gain, not a bigger server.

We find long transactions and the offending query through monitoring and server logs, then fix the query or the order of operations. Restarting SQL Server is the last resort, not the first.

Yes, MS SQL is a standard DBMS for 1C:Enterprise. We tune memory, tempdb and maintenance jobs for the 1C workload; maintaining 1C itself is our separate 1C administration service.

Access to the server and to SQL Server with administrator rights. You can issue a separate account for us and revoke it at any time.

The price depends on the volume of work, not the database size. Mini — 4 hours of work per month for €79/mo, Pro — 10 hours for €189/mo, Max — 25 hours for €429/mo. Extra work is €19/h.