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 deadlocks tab of the history viewer displays the sql server deadlock history over the course of miniDBAs monitoring.
The main server dashboard in Mini DBA displays real time deadlocks but the history viewer is where to find any deadlocks that occurred more than a minute ago.
This is critical with after the event investigation into why deadlocks occurred with a view to resolving deadlocking to prevent it in the future.
The graph at the top displays the number of deadlocks at a point in time, this makes it easy to identify particularly bad times for deadlocks.
The grid in the middle of the screen shows the details of each individual deadlock occurrance.
Clicking on a deadlock in the grid will display the deadlock graph at the bottom of the screen. Use the tabs to display either text or xml form.
All the information for the deadlock can be se in these graphs - which process/spid blocked which other spid when and for what resource.
Deadlocks can raise an alert in Mini DBA Enterprise Edition in real time as they happen by enabling the deadlock alert.
Note:Deadlocks are only logged in Mini DBA for SQL Server 2008 and later editions. Also pre release CTP versions have been seen to not log deadlocks reliabily so it is recommended you keep your installed version up to date with the latest service pack.
The main server dashboard in Mini DBA displays real time deadlocks but the history viewer is where to find any deadlocks that occurred more than a minute ago.
This is critical with after the event investigation into why deadlocks occurred with a view to resolving deadlocking to prevent it in the future.
The graph at the top displays the number of deadlocks at a point in time, this makes it easy to identify particularly bad times for deadlocks.
The grid in the middle of the screen shows the details of each individual deadlock occurrance.
Clicking on a deadlock in the grid will display the deadlock graph at the bottom of the screen. Use the tabs to display either text or xml form.
All the information for the deadlock can be se in these graphs - which process/spid blocked which other spid when and for what resource.
Deadlocks can raise an alert in Mini DBA Enterprise Edition in real time as they happen by enabling the deadlock alert.
Note:Deadlocks are only logged in Mini DBA for SQL Server 2008 and later editions. Also pre release CTP versions have been seen to not log deadlocks reliabily so it is recommended you keep your installed version up to date with the latest service pack.