AlphaSOFT SDS offers performance tuning, diagnostics, baselining and optimization of Microsoft SQL Server and T-SQL stored procedures or scripts
SQL Database Services – Making SQL Server a Better Place for All
- SQL Server Health Check: Your server and database configuration is the starting point for improving SQL Server performance. You will receive a report with recommendations of changes to make on the configuration of your SQL Server.
- Priority SQL Server Performance Fix: Your production systems are currently affected by poor performance and you urgently need it fixed. SDS will attend to your issues with a matter of urgency and solve the crisis. This is a 24\7 service.
- TSQL Code Check: Our experts will analyse your code and recommend improvements. The included report on changes made will explain why the changes should be made – allowing you or your developers to improve your SQL coding practises.
- TSQL Coding: If you don’t have a TSQL expert on board, we can write T-SQL code according to your specifications. This service includes a TSQL Code Check after implementing the code in production.
- Index Strategy: As experts in indexing on SQL Server our team have the required skills to analyse your indexes and produce a report with recommendations – including a script to implement these recommendations. Common problems include duplicate indexes, unused indexes and missing indexes.
- High Availability: We can recommend and implement high availability including database mirroring, log shipping and replication.
- Database Compression: If you are running SQL Server Enterprise Edition, we can analyse your indexes to determine an effective compression strategy. You will receive a report with recommendations which includes a script to implement said recommendations.