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.

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

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 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.