My Blog

SQL BI Check on cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

1.  Real-time performance monitoring for SQL Server Analysis Services (SSAS)
2. See physical server metrics for CPU, disk, and storage.
3. View analysis metrics for SSAS processing, memory, and cache.
4. Get up and running in minutes, no agents required.

 

Features

Major Features of  SQL BI Check

Real-time SQL BI Performance Monitoring : Monitor the performance of physical server activity as well as analysis services to get a better picture of your SQL BI systems. Set the refresh rate to as little as 1 minute and see up to 2 ½ hours of data. The configurable dashboard provides an at-a-glance view of the metrics that are important to you.

Physical Server Metrics : View CPU utilization in terms of percentage as well as query pool and processing pool queue lengths. See storage engine activity and cache performance. The sessions bubble chart displays all active sessions visually by CPU time with bubble size and color distinctions to show the most CPU intensive sessions. Hover over a bubble to see a snapshot of session and utilization details.

Analysis Services Metrics : Monitor SSAS processing by rows read and rows written to see the analysis services load. View memory in SSAS specific shrinkable and non-shrinkable categories to get a precise view of the SSAS memory utilization of the overall system memory. See the SSAS cache activity to see how efficiently the cache memory is being used.

Up and Running in Minutes with No Agents : The small download and easy installation wizard will get you up and running quickly. No agents are installed on the server as all metrics are obtained through SQL or WMI.

Integrate with SSMS : Designed to launch directly within SQL Server Management Studio (SQL 2012 and above) for optimal usability and efficient workflow.

 

AWS

Installation Instructions For Windows

A) Click the Windows “Start” button and select “All Programs” and then point to SQL BI Check

B) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

C) Other Information:

1.Default installation path: will be on your root folder “C:\Program Files\Idera\Idera SQL BI Check\”
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Users Instructions Screenshots

 

 

 

Videos


SQL BI Check on cloud

Related Posts