Transcript

Expand

Welcome to IDERA SQL Virtual Education for SQL BI Manager. SQL BI Manager is an identifier (ID)ERA solution that allows you to monitor your entire business intelligence environment. From the Analysis Services to Integration Services to Reporting Services. Both the utilization as well as activity that is affecting your environment. Right now, we are looking at the administration screen within the console. This is a web console. It is running on Apache Tomcat with a service that has responsible for reaching out to pull the performance data remotely on each of the business intelligence (BI) instances. The first thing we will do in the console is add instances and configure thresholds. We may also set up email notification rules as well. So that we can get notifications whenever problems pop up. To add a business intelligence (BI) service. Will simply choose this option Add BI Service. Which will bring up a wizard to add the instance. You can also select what service is installed on the instance. Supply appropriate credentials for Windows Management Instrumentation (WMI) collected data versus SQL collected data. And it really is as simple as that. We can perform a test to make sure that everything is okay with a communication. And then add the instance to be monitored. In my case, I have already added my instances. So I am going to jump over to my dashboard view, which will display my most recent alert activities happening across my business intelligence (BI) environment. If anything stands out as something that I need to look at a little bit closer, I can click on the alert. And it will drill right into that the performance data that I need to review. In this case, it took me to the Analysis Services section. And you can see it is highlighted up here. Because I have each of my instances put into different containers. Based on the services that I am monitoring. So starting off with Analysis Services. We have jumped over to the interrupts per second. Because of the alert, I click on. You can also go back up to the overview screen. Just to see all of the alerts relevant to this sense. Or change it up to view another instance. If you want to. There is a certain server performance overview. Where you can drill into hot spots and activity across disk performance, network activity, central processing unit (CPU), memory, and processing. Anything you click on will display the recent activity. And you can also make adjustments to the date and time range at the top of the screen. To look at other trends based on what types of activity you are experiencing in your environment. Going down the list here. Some of the things notable to mention. For Analysis Services, we can go in and look at the query activity. To look at all active queries including elapsed time, reads and writes, user that is running the query, the session identifier (ID). We can also take it down to the underlying session. Specific sessions database access, start time, last command, last commit, last command, start in, end time. Drill into the model names. And look at that the different models that exist. For this particular business intelligence (BI) server. If SQL has enabled. Drill through. Enable last schema update, last data update, user activity as well. I have this single user here. But I can pull up that user to look at all of that individual’s activity. So that has the Analysis Services. But we equally have those types of features for Reporting Services and Integration Services. Including the ability to look at the alerts specific to Reporting Services. And drill into resource utilization, central processing unit (CPU), memory, and disk activity for Reporting Services. But also the ability to go in and look at Reporting Services specific activity. Like the active connections for Reporting Services. Or drill into Reporting Services. And look at this active session for this particular server or the overall reporting activity as well. Report execution type statistics, the start time, the end time. The report that has generated. I have it kind of crunched down that you can expand these columns. If you want to, there is some additional advanced filtering as well. If you need to filter based on report path, user type, or status. And all of this can be exported out. If you need to share it with different audiences as well. And last we have the Integration Services section. And the same is applicable for Integration Services. You are able to drill into your Integration Services activity view alerts. And also look at trends and utilization happening on that particular server. And different hotspots in the day where activity tends to increase or you tend to see slowdowns. And performance-based on utilization. So with that, that has the SQL BI Manager solution. Hopefully, this has been helpful in introducing you to some of the key features and what would be enticing about this product. Feel free to go out to our website and download a fully functional trial evaluation and put it to the test. I appreciate you watching the presentation today. And I hope you have a great day.

An Overview of SQL BI Manager

IDERA SQL BI Manager provides agentless monitoring of the servers and services for SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services. Get insight into over 140 metrics including OS counters, service performance counters, and system availability.

Dashboard views display data across the entire BI environment and enable you to drill down to find details relating to performance and availability issues. In addition, configurable alerts keep you notified of the state of your BI environment so you can take corrective action as needed. Learn More →

Start a FREE Trial of SQL BI Manager
Share This
Contact IDERA:
+1 (713) 523-4433