История

Nick Salch aabe571d9d DB Health Template first draft		2020-08-21 09:20:29 -07:00
..
Templates	DB Health Template first draft	2020-08-21 09:20:29 -07:00
README.md	Update README.md	2020-04-21 12:32:36 -07:00

README.md

This template is a work in progress and is not yet meant for use in production

This template is a work in progress, but is in a usable state. It currently only has realtime pages from querying DMVs. It will get historical data as well as I post updates.

Pre-Requisites

PowerBI Desktop installed on your machine.

There are currently no other pre-requisites other than a running SQLDW Instance. In future releases there will be Log Analytics queries and the below pre-requisites will apply to that.

Variables

When you open the template it will as you to fill in a number of variables. A lot of these are for future use or will be removed later.

SQLDW_Servername: the name of the server your SQLDW resides on in the form sqldwname.database.windows.net

DatbaseName: The name of your SQLDW Database

LogAnalyticsWorkspaceID: Not in use, enter any text value

StorageAccountName: Not in use, enter any text value

RangeStart: Not in use, enter any date value in the form 4/21/2020 1:00:00 AM

RangeEnd: Not in use, enter any date value in the form 4/21/2020 1:00:00 AM

SQLDW_Servername_short: Not in use, enter any text value

Messages about Native Database Queries

Most of the DMVs are collected using native datbase queries. You need to allow each one permissions to run by hitting 'Run' on the popup.