Companion for MS SQL Services

 Overview
The Companion for MS SQL Services is designed from the ground up to enhance your SSAS implementation with little or no impact on performance. Its efficient architecture consists of two components – a Windows NT service installed on the system running Microsoft SQL Services and a Client application that can run on any machine capable of communicating with the SQL Services.

Companion for MS SQL Services


The NT service collects data retrieved from the SSAS server and writes it to a SQL Server database. The familiar and intuitive Client application connects to this database and presents the data in an easily understood format. The interface is developed using leading edge technologies like asynchronous processing, so you will never be held up by the more intensive processes.

With a lightweight architecture that runs natively on any Windows platform (including x86, x64 and IA64), the Companion for MS SQL Services can increase the performance, manage the growth and empower the development of any SQL Services implementation.
 Service and Support

Enterprise Software Solutions provides software support related to the purchased product at no additional cost. Most of the submitted bugs and requests are addressed and resolved within 48 hours. Recommendations and New Feature Requests are added on a TODO list and addressed after being reviewed and approved.

Companion for MS SQL Services license includes:
  • Per server instance license with single or unlimited users
  • Initial overview of your environment, security, servers, deployment, setup, and configuration
  • Recommendation on product deployment – stand alone, failover cluster
  • Initial configuration of the product
  • Initial overview of configurable options, discussion, review and help with decision making on default values
  • Initial training on how to use the product
  • 1 year of support directly related to the product
  • 1 year of updates, bug fixes, patches and any new versions that we deploy
Additional license information:
  • Yearly renewal prices for support and new versions are 50% of the original product cost
  • Academic and additional Cluster Node licenses are at 50% the original product price
Additional Support Options:
  • Dedicated service and support
  • Advanced software development
  • Development Architect
  • Consulting
  • Monitoring
  • Optimizations
 Features_New

The Companion for MS SQL server is more than just a performance monitor. It allows you to dig deep into the inner workings of the MS SQL server and bring to your attention critical information that will help you improve your SQL server performance. Some of the features listed below were invented by Enterprise Software Solution.

  • Time Travel – review performance over time and identify heavy users and queries
  • Forensics – perform forensic investigation in the SQL Server log files
  • Deadlock Analyzer – review the complete deadlock chain of all related statements
  • Advance Reporting – over 60 reports to help you with performance, tuning, utilization and monitoring
  • Blocking and Waiting – identify blocking requests or review current waits on resources
  • Opened Sessions – get detailed information about each currently connected session
  • Performance Monitor – review SQL based and Windows OS based perform counters for overall view of the server performance
  • Running Queries – review currently running queries, identify most expensive queries, review the SQL statement
  • TempDB Usage – review TempDB usage and identify if it is a bottleneck in the server performance
  • Baseline Analysis - observe and track bottlenecks and performance trends, and estimate data performance over time to stay ahead of the curve
  • Performance Monitoring – visualize overall server health statistics aggregated and in real-time, including disk I/O, network interface throughput, CPU time and memory usage
  • Disk Partition Alignment - display information like partition offset and allocation unit size to determine whether partitions are aligned for best I/O performance
  • Backup and Restore Performance – get better control of your disaster recovery processes
  • Hardware Management – keep tabs on server hardware details, such as memory capacity and usage, CPU socket type and bus frequency
  • Event Logs – quickly filter and review the windows and the SQL server event logs
 Screen Shots
Edit Album Re-Order the Album Images

Companion for MS SQL Server Screen Shots

Companion for MS SQL Server Screen Shots

  • Companion for MS SQL Server - Blocked Sessions
  • Companion for MS SQL Server - CPU view
  • Database Structure in Companion for MS SQL Server
  • Companion for MS SQL Server - Deadlock trace
  • Disk view in Companion for MS SQL Server
  • Log view in Companion for MS SQL Server
  • Memory View in Companion for MS SQL Server
  • Network view in Companion for MS SQL Server
  • Performance Monitor in Companion for MS SQL Server
  • Perfomrnace Monitor SQL
  • Resource Wait in Companion for MS SQL Server
  • Running Queries in Companion for MS SQL Server
  • Running Quries in Companion for MS SQL Server
  • Scheduler View in Companion for MS SQL Server
  • Sessions View in Companion for MS SQ
  • Temp DBU sage  in Companion for MS SQ
  • TimeTravel in Companion for MS SQL Server
  • Time Travel in Companion for MS SQL Server
  • Top CPU Queries in Companion for MS SQL Server
  • Companion for MS SQL Server - Missing indexes
 Contact Information
 Enterprise Software Solutions, LLC.

Skype:


Toll Free: (888) 804-7089
E-mail: info@entsoftsol.com
Find us on Google+