GRE Solutions Limited

SQL Server Performance Tuning

If your application is suffering from poor performance, it might be that the database is the cause of poor performance. We can establish if it is your database causing the slowness and identify and fix the bottleneck that is slowing things down.

Features

  • Identify your worst performing database queries
  • Understand what SQL Server is waiting on
  • Understand what indexes may help

Benefits

  • Improved user expereince
  • Reduction in resources used to return data
  • Improved system usability

Pricing

£550 a person a day

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at gethyn@gethynellis.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 12

Service ID

3 9 6 3 4 0 3 4 3 6 5 0 7 2 6

Contact

GRE Solutions Limited Gethyn Ellis
Telephone: 07795567000
Email: gethyn@gethynellis.com

Planning

Planning service
Yes
How the planning service works
We will run a setup of scripts and generate a report highlighting
> Your worst performing queries
> Identify any missing indexes
> Use Wait Stats analysis to pin point specific bottlenecks
Planning service works with specific services
Yes
Hosting or software services the planning service works with
  • SQL Server
  • Azure SQL Database

Training

Training service provided
No

Setup and migration

Setup or migration service available
No

Quality assurance and performance testing

Quality assurance and performance testing service
Yes
How the quality assurance and performance testing works
We look at query execution times and resource usage before and after to show a reduction in resources used

Security testing

Security services
No

Ongoing support

Ongoing support service
No

Service scope

Service constraints
We will need sysadmin access to the SQL Server. This can be through an account or we can work with a staff member to queries the diagnostic data

User support

Email or online ticketing support
No
Phone support
Yes
Phone support availability
9 to 5 (UK time), Monday to Friday
Web chat support
No
Support levels
We will work with you while carrying out the performance tune up ti make sure that any changes made are implemented with a minimum impact on your systems

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Staff screening not performed
Government security clearance
Up to Developed Vetting (DV)

Pricing

Price
£550 a person a day
Discount for educational organisations
No

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at gethyn@gethynellis.com. Tell them what format you need. It will help if you say what assistive technology you use.