How to use PowerBI as a free monitoring tool (including 5 free reports for SQL Server)

Target Audience:

Accidental DBAs, DBAs with no budget or crafty professionals that want to know how to use PowerBI in a non-standard way

Abstract:

Power BI is a business analytics service that delivers insights to enable fast, informed decisions; we’ll use it as an (improper) free monitoring tool.
Being at GroupBy, we’ll focus on SQL Server Reports, but the methodology is system-agnostic and will enable you to create a monitoring report for anything.

In the first part of the session, you’ll learn why we’re using PowerBI for such task and what are the limitations, explaining the PowerBI basics, architecture and components.

In the second part, we’ll analyze 5 examples of ready-to-go and license free monitoring reports tailored for SQL Server:

– FirstRespondersKit Monitoring Dashboard
– Xevents Dashboard to track query errors
– Job Information Dashboard
– Permission Information Dashboard
– Streaming DataSet

This will give you both some reports that you can start to use right now, and the inspiration to build your own.

Why I Want to Present This Session:

I want to help others by providing free tools and methodology to monitor/analyze any environment (starting from SQL Server)

Additional Resources:

Home
The following two tabs change content below.
Previous Post
How to Build a Blog Worth Reading
Next Post
Deploying SQL Server 2019 Big Data Clusters on VMware

2 Comments. Leave new

Eugene Meidinger
September 14, 2019 9:28 am

Overall an interesting topic and a good abstract. You cover why people might want to attend and list out the specifics. I also appreciate the screen shot.

I would probably replace the SQL Saturday in your abstract, however 🙂

Reply
Emanuele Meazzo
September 14, 2019 3:44 pm

Damn you copy/paste ;D
Thanks Eugene!

Reply

Leave a Reply to Emanuele Meazzo Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu