OPTIMIZE YOUR SQL SERVER DATA PLATFORM'S PROCESSES & RESOURCES

Discover everything that SQL SERVER QUERY ANALYTICS has to offer

SQL Server Query Analytics is a set of tools that will allow you to identify who is using which services of your SQL Server Data Platform, in order to optimize processes and resources.

We have developed a series of tools for your team in both BI & Analytics, and SQL Server environments. These tools carry out an analysis of the log of your stored data, both in the analytical and relational engines. In addition, you can obtain advanced information that allows you to identify bottlenecks in your processes, reports and analytical queries, as well as to point out which could fail in the future. The best part is, you can customize your pack to best suit your needs.

Simply choose the modules and instances you need and start saving today by creating a customized solution.

  • SSAS (SQL Server Analytics Services) Query and Usage Analytics
  • SSIS (SQL Server Integration Services) Analytics
  • Power BI Usage Analytics
  • SSRS (SQL Server Reporting Services) Analytics
  • T-SQL Query Analytics

You will pay for instance and product. Just choose how many services you would like to use in each server, mix and match as you wish.

Focus on what is important

Are you tired of those tasks that are not in your job description? Are you tired of wasting time, looking for the cause of your system’s latency problems? Let our tools take care of those tedious tasks and start saving time and valuable effort.

Be aware of what happened

You will be able to keep a historic track (number of days will depend on your subscription), so you´ll be able to predict potential complications.

Cost savings

If you are saving time, you are saving money. Your time is very valuable to you and your enterprise. Start saving today! In addition, you will know from day 1 the cost of your subscriptions.

}

Improve your team's productivity

Know exactly where the problem is, how to solve it and keep track to prevent problems from happening.

We have your system’s
back

Since 2002, we have been helping large and medium-sized companies to automate and improve their processes. We share the tools we use in our consulting and mentoring projects.

You could combine it with other SolidQ tools

All of the modules are compatible with one another and with any other SolidQ Service such as Adaptive BA Framework or SolidQ Flex Services.

Customize your SQL Server Query Analytics pack

You could engage with any of the following Star Packs, or you could buy each tool separately. As an example, for the BASIC subscription (3 instances) you can combine them in any of the following ways:

 

One server, three services

  • Server “A” with 3 integrated instances
    1. T-SQL Query Analytics
    2. SSAS Query and Usage Analytics
    3. Reporting Analytics

Two Servers, three distributed services

  • Server “A” with 2 instances:
    1. T-SQL Query Analytics
    2. SSIS  Analytics
  • Server “B”, with 1 instance:
    1. Power BI Usage Analytics

Three Servers, one service in each one

  • Server “A”, with one instance:
    1. SSIS Analytics
  • Server “B”, with one instance:
    1. T-SQL Query Analytics
  • Server “C”, with one instance:
    1. SSRS Analytics

MODULE 1. SSIS Analytics

This tool will allow you to see the executions of the SSIS packages that orchestrate and execute the tasks of your ETL.

With SSIS Analytics, you will identify:

  • Which SSIS packets have failed
  • Which SSIS packages have been successfully executed
  • Where the bottlenecks are
  • Check the duration of the executions
  • See additional information related to the changes tables
  • Gather further information about the details of your uploads*

STAR PACK 1: TSQL QUERY ANALYTICS + SSIS ANALYTICS
(*) Available only and exclusively by combining it with an Adaptive Business Analytics Framework subscription. 

MODULE 2. SSAS Query and Usage Analytics

Using this tool, you will be able to analyze and to give a meaning of the information contained in multiple databases

With SSAS Query and Usage Analytics:

  • Identify which users and applications are making queries against the analytical engine of SSAS (both tabular and multidimensional instances)
  • Identify which queries are being made
  • Detect any performance problems
  • Detect and identify bottlenecks in order to apply any corrective actions needed

STAR PACK 2: TSQL QUERY ANALYTICS + SSRS ANALYTICS + SSAS ANALYTICS

MODULE 3. Power BI (Audit) Usage Analytics

This tool will let you identify which users are consuming content in the Power BI service.

Power BI Usage Analytics:

  • Identify which users consume what content, in order to scale the service properly.
  • Control the actions that your users carry out.
  • Identify usage peaks and who has consumed the service at that time.
  • Get historical data from the moment the installation is done. This is essential when carrying out audits of access and control of operations (GDPR).

STAR PACK 3: TSQL QUERY ANALYTICS + SSAS ANALYTICS + POWER BI USAGE ANALYTICS

MODULE 4. SSRS Analytics

With this tool, you can identify which reports users use most to focus only on what really adds value for your users

With SSRS Analytics:

  • Identify which reports are most popular
  • Measure the performance of your reports, to eliminate those that are not used so frequently
  • Focus your efforts on improving only those reports that provide value for your users

STAR PACK 2: TSQL QUERY ANALYTICS + SSRS ANALYTICS + SSAS ANALYTICS

MODULE 5. T-SQL Query Analytics

Tool designed to control the behavior of your queries, so that you always have control of what happens in your database

With TSQL Query Analytics:

  • Optimize your database
  • Identify which query is the one that caused the performance failure
  • Detect in advance any upcoming failures of your queries
  • Detect if performing a migration to another version of SQL Server will improve your system
  • Get daily reports by mail about the performance of your queries*

STAR PACK 2: TSQL QUERY ANALYTICS + SSRS ANALYTICS + SSAS ANALYTICS

STAR PACK 1: TSQL QUERY ANALYTICS + SSIS ANALYTICS

(*) Depends on the contracted subscription

I think it is a great and very powerful tool. I have discovered three queries that were weighing the speed of my application, I have allocated little effort in repairing them and my application now seems like another

It has allowed me to detect that migrating to SQL Server 2016 was a success. Now the whole system goes much faster.

Thanks to SQL Query Analytics, I can see what happens with my queries, without having to spend hours trying to find the one responsible for the slowness of my system.

Cases in which the SQL Server Analytics pack can be useful:

  • The performance of the system has fallen drastically for an unknown cause
  • I need to optimize my SQL environment
  • I have a hard time identifying where the problem is
  • I waste a lot of time identifying where the problem is
  • I do not have time to find the root of the problem.
  • We lose a lot of money with patches, trying to solve the problem, but it is still there.

Customers using the SQL Server Query Analytics modules

Related Services

TRAINING

Public and Private Delivery Options. Advanced Power BI, BI & Analytics Master’s Degree with Microsoft Technologies, SQL Server execution plans, T-SQL Fundamentals, Advanced T-SQL Querying, Programming & Tuning for SQL Server 2012- 2017.

CONSULTANCY SERVICES

Do you need prompt help with any your projects? Buy consultancy hours and distribute to best suit your company’s needs.

INTEGRATED SOLUTION

If the time has come to turn over a data platform and you need a new BI solution, migrate to your system, or apply predictive analytics, we can help you with your digital transformation.