DBA Monthly Services

Twice Monthly:

Quick Tune Up

• ​Add top 5 missing indexes*
  
• Check expensive queries
• Check Disk Latency
  
• Check SQL Memory
  
• Check File Sizes
  

Check Back Up Integrity

Check Maintenance Plan

Check Backups

*Some items may not be adjusted if not enough data exists to support making a change.

ERP Services

Manual Creation

Process Documentation

Crystal Report Customization

SSRS Report Customization

Best Practice Consultation

Bar Code Implementation

Custom Bar Code Creation

KnowledgeSync Help

Spreadsheet Server Help

ERP - We provide on site and remote ERP training, implementation, customization and data migration services.

DBA - We provide Database Administrative services for companies who need this, but can't justify a full time DBA.

DBA One Time Services

Missing Index Analysis

Missing Index Addition*

Query Analysis

Query Optimization*

Report Analysis

Report Optimization*

Create Maintenance Plan*
Create Backup Strategy*

​Check Disk Latency

Check SQL Memory
Check File Sizes

Check Client vs Server Speed

*To the extent access is afforded by the ERP package.