Bramble Hub Marathon - Microsoft SQL Server Performance review

SQL Server and any associated databases are complex software and can quickly deteriorate in performance for many reasons such as inefficient code, SQL misconfiguration, network latency or I/O stalls. Without having an in-house DBA or database specialist, it can be almost impossible to identify the source of performance issues.

Features

Checking basic performance measures for the server are on line

Checking databases are performing adequately with respect to I/O

Identify any badly performing queries

Checking Table and Row locking considerations

Checking index tuning and maintenance analysis

Checking Storage Configuration

Checking File placement analysis

Checking collation sequences

Benefits

Highlights specific areas for development or remedial work

Identifies issues that may be disrupting performance

A document will be produced outlining short and long-term recommendations

Framework

Service ID

Contact

Planning

We would have a scoping call with the customer to talk through the options and then we would offer a chargeable Design Workshop to help plan what we are going to implement.

Planning service works with specific services

No

Training

Training

Training service provided

Yes

How the training service works

We provide knowledge transfer for certain skill sets. This will not be official training and there will not be an accreditation linked to it.

Training is tied to specific services

Yes

Services the training service works with

O365

Azure

Exchange

Active Directory

SCCM

Intune

VMWare

Citrix

Setup and migration

Setup and migration

Setup or migration service available

Yes

How the setup or migration service works

We offer a chargeable service for cloud migrations where we will design and implement the required work needed to migrate to the cloud.

Setup or migration service is for specific cloud services

No

Quality assurance and performance testing

Quality assurance and performance testing

Quality assurance and performance testing service

Yes

How the quality assurance and performance testing works

We offer chargeable health checks to ensure that the system is working to a high standard and the customer is using the system to its fullest. We will provide documentation with our findings and suggested remediation.

We provide 1st/2nd and 3rd Line Support. Indicative costing is as follows 1st Line - 120 calls annually - £1770, 2nd Line - 120 calls annually - £4450, 3rd Line - 120 calls annually - £8330. With every support contract you will be allocated an Account Manager to escalate any issues to.