SQL Server Health Check Services
Find out your SQL Server weak spots, and create a clear roadmap of what needs improvement
Have you been dealing with:
- Random or ongoing SQL Server performance or stability issues?
- A SQL Server that is not functioning as it should be and you don’t know why?
- You bought performance monitoring software but you STILL don’t know how to leverage the information it’s giving you to solve your issues?
- You lost your DBA and simply want an audit of your current environment to understand where you stand?
- You invested in new hardware and you’re still experiencing the same performance issues and you don’t know why?
Do you want:
How we do it better:
- Data security – We use bank-level security We add our own two-factor authentication, network segmentation, enterprise firewalls, security software, silos, vaults, and more.
- SQL Server Health Check is included free of charge – for any consulting or managed service client. Because this is the ONLY way to provide good recommendations.
- Most comprehensive 145 point SQL Health Check in our industry – which includes more than just a SQL Server audit, but also other items that affect stability and performance:
- Server and OS configuration:
- Windows settings
- Disk and storage configuration
- AD, GPO, local security policies
- Log review
- Patching
- SQL Server instance config
- CPU & RAM config
- Security access level analysis
- Maintenance plans and backups
- Trace flags
- Monitoring and alerting
- SQL patching
- Parallelism settings
- Database config
- DB options
- File sizes, number of files
- Tempdb config
- File placement
- Data & index separation
- Performance
- Indexing
- Missing indexes
- Over-indexing and unused indexes
- IX merging
- Fragmentation
- Compression
- Blocking and deadlocking
- Worst performing queries consuming most of hardware resources CPU, storage, network resources, and duration
- Longest and most frequently run TSQL
- Indexing
- Utilization (Workload)
- Bottleneck review & wait stats
- Server-level performance – CPU, RAM, storage, network, storage
- Disk and file latencies
- Zero effect on your database performance or availability while we investigate
- An easy-to-understand SQL Server roadmap to improving SQL Server over time5
Testimonials
"Red9 has incredible expertise both in SQL migration and performance tuning."
The deep level of knowledge of MSSQL is incredible and the combined experience and expertise has been a huge asset. Additionally, the flexibility and professionalism throughout a difficult migration was highly appreciated.
Richard StaatsCloud Engineer The deep level of knowledge of MSSQL is incredible and the combined experience and expertise has been a huge asset. Additionally, the flexibility and professionalism throughout a difficult migration was highly appreciated.
"The customer realized a 60% decrease in CPU utilization as a direct result of Red9's work."
With little notice Red9 was able to find and fix a number of different SQL misconfigurations and wasteful practices as our customer moved their SQL environment from a rack solution with Fiber SAN to the Azure cloud.
Jason MilgramAzure Practice Director, Champions Solutions Group, AllAware.com With little notice Red9 was able to find and fix a number of different SQL misconfigurations and wasteful practices as our customer moved their SQL environment from a rack solution with Fiber SAN to the Azure cloud.
"Rare… Penetrating Knowledge of SQL."
Red9’s cool confidence and eagerness to deliver results are surpassed only by their deep penetrating knowledge of SQL. Whether it's SQL design, development, optimization, or recovery, Red9 is a SQL Gem.
David LernerPresident, LernerSolutions.com Red9’s cool confidence and eagerness to deliver results are surpassed only by their deep penetrating knowledge of SQL. Whether it's SQL design, development, optimization, or recovery, Red9 is a SQL Gem.
"Red9 are the experts in large scale MS SQL Database environments."
They have mastered the understanding of complex, heavy load TSQL transactions. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA company with the kind of skill set Red9 has proven time and time again.
Tim JanssenApplication Manager, Service King Collision They have mastered the understanding of complex, heavy load TSQL transactions. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA company with the kind of skill set Red9 has proven time and time again.
Previous
Next