Services · Overview

What we do for your SQL Server.

Seven services, one team in Hamburg, since 1994. You commission what you need: once, as a project, or on an ongoing basis. Our own tools are part of every engagement, so every finding comes with evidence.

Which service fits?

From your situation to the right service.

Most enquiries start with one of these sentences. If none fits, or several do: the Health Check is the usual starting point, and a conversation costs nothing.

Your situationServiceFormFirst step
SQL Server is slow, right now or again and again.Performance tuningOne-off, days to weeksConversation, then analysis with follow-up measurement
You want to know where you stand.Health CheckOne-off, fixed procedureKick-off, data collection, report with evidence
There is no DBA, or no time for operations.PSG DBA PoolOngoing, Bronze · Silver · Gold, weekdaysSystem intake, handover
A critical application has to stay fast for good.PSG MXOngoing, monthlyTuning first, then ongoing care
You are building, moving or consolidating.Infrastructure & high availabilityProjectRequirements, architecture, build, failover test
Azure is the target, or under consideration.SQL Server in AzureProject or advisoryPlatform choice, then migration
You need reports you can trust.BI & reportingProjectRequirements, architecture, data integration
Something is on fire right now.Urgent helpImmediatelyCall +49 40 39882875
From a management perspectiveWhy SQL Server slows down again after tuning, and why performance needs ongoing control: Performance risk, for decision-makers →
The services

Seven services, briefly explained.

01

Performance tuning

We find the cause in queries, plans, waits and configuration, implement the change and measure the effect. Urgent or planned, with a documented before and after.

SQL Server performance →

02

Health Check

A fixed procedure from kick-off to results meeting, a fixed set of review areas, and every finding with observation, evidence, risk and recommendation. Tailored to your question.

SQL Server Health Check →

03

PSG DBA Pool

Operations hand in hand with your team: daily system checks on weekdays, backups, maintenance, patches and permissions, remotely through your access. Three tiers, also as cover for absence or outage.

SQL Server DBA services →

04

PSG MX

Ongoing performance care for your critical application: tune first, then spot changes early and counter them within the agreed scope. Monthly, with a report.

PSG MX →

05

Infrastructure & high availability

Availability groups, failover clusters, disaster recovery, migration and consolidation: designed from your requirements, built, and handed over with a tested failover. No licence sales.

Infrastructure & high availability →

06

SQL Server in Azure

Choosing between VM, Managed Instance and Azure SQL Database, migrating, and keeping performance up in the cloud, with an eye on cost and operations.

SQL Server in Azure →

07

BI & reporting

Right-sized architecture, data integration and reports that answer questions. Also for organisations without SQL Server, for example in the public sector.

BI & reporting →

Stack and tools

How the services fit together.

Internally we organise our work in five layers; you do not need to know the stack to work with us. Our own tools are part of Health Check, tuning, MX and the DBA Pool, so findings come with evidence rather than guesswork. All tools →

The PSG Stack · five layers

  • 01

    Foundation

    Infrastructure and high availability, migration, edition and cores. Infrastructure →

  • 02

    Operations

    Ongoing administration together with your team. PSG DBA Pool →

  • 03

    Performance engineering

    Solving problems, urgent or planned, and caring for critical applications over time. Performance → · PSG MX →

  • 04

    Evidence & analysis

    Evidence instead of guesswork: execution history, plans, changes. PSG QX →

  • 05

    Product layer

    Performance knowledge across every installation of a software product, for vendors. QX Fleet →

Our tools

  • QX

    PSG QX

    Analyses the execution history: which query, which plan, since when, and what actually changed after a change. More →

  • REC

    QX Recorder

    Captures the evidence of sporadic problems before it disappears. More →

  • MXA

    MX AIOps

    Data collection and analysis on site, largely rule-based, as the foundation of ongoing care. More →

  • FLT

    QX Fleet

    For software vendors: performance across every installation of the same product, release assessment before and after. More →

Contact

What brings you here?

In a first conversation we clarify the occasion and the goal and suggest the right service, or tell you if we are not the right people.

Book a conversation →