SQL Rx®
A managed practice of Integrated Services, Inc...
SQL Rx is the culmination of proven industry “best practices” and ISI’s years of experience optimizing database and system architecture and performance. SQL Rx has given clients the added benefit of eliminating the need to purchase more hardware or to rebuild systems or applications.
Tune the performance of your SQL databases and servers with SQL Rx. Immediately quantify both hardware and software performance bottlenecks using detailed system and SQL Server measurements. SQL Rx delivers a detailed analysis identifying specific system hardware and SQL Server software bottlenecks with a prioritized list of suggested resolutions and cost-benefit estimates.
SQL Rx includes the following, and more:
- RemoteDBATM Service
- SQL Rx WinPerfTM 3.1 analysis
- Performance Tuning
- Disaster Recovery / High Availability
- Data Migration
- Development Environment Integration
- Capacity Planning
- SQL Upgrades
- Replayable-Trace Workoad Analysis and Tuning
- SQL Server consolidation
- Windows server inventory
- SAN configuration
RemoteDBATM
RemoteDBA provides an effective, low-cost alternative to having a DBA on your staff, and is designed to provide a consistent and complete approach to administration and monitoring of your production environments.
RemoteDBA includes the following, and more:
- Overall configuration review
- Backup strategy and verification
- Login auditing
- Job failure alerts
- Long running queries monitoring and logging
- Disk space monitoring
- Critical perfmon counter logging
- Long-running job monitoring
- Index administration logging
- Best-practices mentoring
WinPerf 3.1TM
WinPerf is a SQL Server Performance and Capacity Tuning tool developed by ISI to collect and uniquely correlate both SQL Server and System performance data to quickly identify and decode bottlenecks.
Through its SQLRx practice, ISI has delivered its WinPerf service to several hundred companies per year since its first release in 2005. WinPerf delivers a formalized report, not only isolating performance and capacity constraints, but identifying root cause and decoding even to a specific line of code. WinPerf is widely used by companies such as Unisys, Microsoft and EMC, as well as numerous mid and large size enterprises.
Available as both a Full and Lite Assessment, an analysis with WinPerf is a cost- effective and quick solution to resolve performance and capacity constraints.
