Considerations
1
Health
Do I know when I have failed services or a loss of functionality?
2
Performance
Does system poor performance affect my operations and bottom line?
3
Access
Do I know if systems are operational prior to user login?
What is it?
Optimised Bistrack application
Improved staff efficiency (no-lock, refresh rates, best practice methods)
Improved customer and user experience
Facilitates faster SQL server database
SQL Server re-configuration and tuning (index, compression, fill factors)
Ensure all BI applications and BI reporting run optimally
Maximise existing hardware
Reduce loads required to run applications
Monitoring includes
Critical and application functionality
50+ alerts running in the background
Flexible programmable alerts delivered by dashboard, email or SMS
Performance related hardware statistics
SQL Server performance statistics
Page life expectancy, AVG read/writes, blocked processes, long running queries
BisTrack application specific performances
Add product to order, order issue, invoice create, mark delivered, Crystal prints
Monthly trend analysis
Critical items monitored
SQL server
SQL Server agent and job execution
Database index routines
Database and transaction log backups
Database system integrity
Key windows services/processes
E-business agent
Report Server agent
Key application functionality
Financial export
Background SQL jobs (nightly maintenance, dashboard updates etc.)
Report Server printing
Benefits
SQL server tuning
Initial optimization and configuration
Database index review and maintenance
Optimising work loads and schedules
System performance baseline and on-going logging
Regular database integrity checks
Bistrack application
System option overview
Best practice guidance (e.g. job scheduling, data tidy)
Optimisation of Smart Views and dashboards etc.
Deployment of BisTrack Report Server
Crystal reports tuning
Option 1 pricing (OTLF)
Health & performance monitoring module
£3,000
Module cost & Installation
Full implementation in Azure or On-Premise infrastructure environment
Initial setup
£798
Configuration setup
Agree monitoring
Quarterly monitoring fee
£900
Commitment
Monthly monitoring module to be implemented for a minimum of twelve months
Summary
Step 1
CONSIDERATIONS
Do I know when I have a loss of functionality?
Does poor performance affect my operations and bottom line?
Step 2
WHAT IS PERFORMANCE MONITORING?
Leverage faster BisTrack
Faster SQL Server database
Step 3
BENEFITS
SQL Server tuning
BisTrack application best practice and optimisation