Are you experiencing any of the following?

  • Slow running server

  • Not sure about the security of the server

  • Want to extend the life of your current server

  • Experiencing performance problems

  • Not sure if your server is being backed up and could handle a disaster

  • Not sure if the server was installed correctly and is using resources efficiently

 

If you are experiencing any of these, then our comprehensive Health Check is for you. We use a series of scripts to perform over 750 separate tests on your SQL Server and supporting environment. We compare your server to industry best practices and produce a comprehensive report listing items that need to be fixed along with the resolution. We also provide an Excel checklist so that you can prioritize items to be fixed. With the Health Check results in hand you can implement the needed changes internally or we would be glad to help. The Health Check usually takes three days to perform.

Do you have any of the following problems?

  • Slow running queries

  • Locking and blocking

  • Application that is starting to run slow

  • Not sure if performance problems are caused by Windows, SQL Server, VM or network

  • Finger pointing regarding performance

  • Need a second opinion regarding performance issues

 

This is a subset of the Health Check designed to identify areas of your server related to performance such as: slow running queries, locking and blocking, missing indexes, redundant or duplicate indexes, incorrect server settings, missing or wrong maintenance jobs. As part of the process we check hundreds of SQL Server and environment settings. We compare your server to industry best practices and produce a comprehensive report listing items that need to be fixed along with the resolution. We also provide an Excel checklist so that you can prioritize items to be fixed. With the Performance Check results in hand you can implement the needed changes internally or we would be glad to help. The Performance Check usually takes two days to perform.

Do you have concerns about any of the following?

  • Not sure if your SQL Server is secure

  • Not sure if you are susceptible to SQL Injection

  • Not sure if users have the proper authority

  • Not sure if users have weak passwords

  • Not wanting to make the paper/internet

  • Have an audit coming up and want to minimize findings

  • Need to verify that your server is PCI compliant

 

This is a subset of the Health Check designed to identify areas of your server related to security. We check hundreds of setting and values to identify weaknesses of your SQL Server. We compare your server to industry best practices and produce a comprehensive report listing items that need to be fixed along with the resolution. We also provide an Excel checklist so that you can prioritize items to be fixed. With the Security Check results in hand you can implement the needed changes internally or we would be glad to help. The Security Check usually takes two days to perform.

Do you want your SQL Server installed correctly, efficiently and according to industry best practices? If so this service is for you. We use comprehensive checklists designed to install SQL Server quickly, correctly and according to industry best practices. As part of the installation we also identify items that may need to be changed in Windows and VM to optimize performance. We also install maintenance jobs to maintain optimum performance and reliability. Call or write for a quote since each installation is different.

Do you need help in designing a system that uses High Availability or Disaster Recovery technologies? Are you getting conflicting input on which technology to use? Do you have RTO, RPO and SLAs to meet? If so we can help you to evaluate the different options that are best for your situation. Call or write for a quote since each situation is different.  

Do you need DBA help, but am unable to hire a Full Time Employee? Do you need senior level help with tough SQL Server problems? If so we can help. Time is usually on a per-hour basis. Please call or write for more information.

Security Check / Audit

Installation

High Availability and Disaster Recovery

Consulting

Performance Check

Health Check