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
The Activity viewer is available in both the server and database level "Activity" view that shows live/executing SQL requests.
The screen is broken into 4 tabs: Requests \ Blocking \ Blocked \ Sessions
Next to that button is the "Kill Session" button which will end the session. Below the button the session details section is broken into tabs:
Details of the execution plan view can be seen here
This functionality is available in the free single sql connection version of Mini DBA Desktop and above.
Requests
Requests are currently active SQL batches that are executing on the SQL Server.Blocking
Any sessions that are blocking other sessions/request. Only head blockers are listed here, which means only sessions that are blocking and not blocked by any other sessions.Blocked
Requests that are blocked by blocking sessions (listed in the blocking tab). "Blocked By Session" column is the session id of the session that is doing the blocking.Sessions
All sessions connected to the SQL Server. Memory use and cpu time taken is listed for the lifetime of the session which includes all requests that have already run plus any currently executing.Session Details
After clicking on a session or request in any of the grids mentioned above the lower half of the screen displays session details. These details are refreshed whenever the above grid is clicked again or the "Refresh Session" button is clicked.
Next to that button is the "Kill Session" button which will end the session. Below the button the session details section is broken into tabs:
T-SQL
Requests show the currently executing T-SQL and sessions show either the currently executing or the most recently executed T-SQL. The session grid shows the last executed time of the T-SQL shown.Locks
All locks currently used by the executing request are shown. The object they are taken out on and their mode are shown in the grid.Waits
Wait types currently being waited on by the executing request. The top half of this section is a grid listing all the different wait types and the amount of time waited per wait type. The lower half is a description of each wait type. The description is shown when a wait type is clicked in the data grid. The left side of the description tells you about the wait type, the right side shows global wait data for that type. This is data collected anonamously from all Mini DBA installations to compare against your server.Estimated Plan
Estimated plans are not always found for the session in the plan cache but when they are the estimated plan view is populated with a list of statements and operators in a hierarchy, ordered by estimated cost:
Details of the execution plan view can be seen here
Live Statistics
Live statistics shows statements and operators in an actual execution plan get executed in real time. More details of this view can be found hereThis functionality is available in the free single sql connection version of Mini DBA Desktop and above.