Mini DBA Web Monitor Security


Legacy Documentation

Desktop And Mini DBA Server

Legacy Documentation Home alerts analysisservicesalerts analysisservicescpu analysisservicesdashboard analysisservicesdatabases analysisservicesio analysisservicessessions azurealerts azuredatabase azuredatabasehealthcheck azureindexes azurelocks azure security azuresessions azuresql azuresqldatabase azuresqldatabasedashboard azuresqldatabases azure sql server dashboard azuretables azurewaits compare performance baseline connections cpu custom sql server alerts database database query performance databases defaulttrace dm exec query statistics xml documentation errorlog files gettingstarted healthcheck database healthcheck sql server history active history blocking history data storage history deadlocks history files history memory history viewer history waits howtoperformancetuneazuresqldatabase how to performance tune sql server how to sql server performance tuning how to sql server query tuning indexes Installation io License Support locks maintenance windows options performance history security server servergettingstarted Server Installation server memory serveroptions serversecurity servertroubleshooting sql database memory sql execution plan sql extended event sessions sql server activity sql server alert configuration sql server alerts sql server database sql server execution plan view sql server index defrag jobs sqlserverindexfragmentation sql server index fragmentation sql server index maintenance sql server live query statistics sqlserverqueryperformance sql server query performance sql server send slack alerts sql server send teams alerts sql server transaction log sql server wait statistics tables tranlog waits webmonitorconfigure webmonitorconnections webmonitorcurrent webmonitorcustom webmonitorenterprise webmonitorgettingstarted webmonitorhistoric webmonitorinstallation webmonitorio webmonitormemory webmonitoroptions webmonitoroverview webmonitorsecurity webmonitorwaits wmi
There are no individual logins to Web Monitor just 2 roles; Administrator and Reader
These are the same as the 2 roles offered by Mini DBA Server. An unlimited number of users can log into Mini DBA Web Monitor using these roles.
Passwords can be set after installation in the web site's web.config file, in the root of the web site directory. Permission to this directory and file should be restricted so end users cannot change passwords.

Web Monitor Login

Administrator

The administrator role can access Mini DBA Server options and add\remove monitored database servers.

Reader

The reader role lacks the permissions to change anything about how Web Monitor or Mini DBA Server runs. All they can do is see all the performance data.
Note:- increasing numbers of readers puts negligable extra load on the server so is safe to give reader access to potentially large numbers of users.

Read about Web Monitor Settings here