Products
Screenshots
Features
Downloads
Buy
Docs
Downloads
See product features
here
miniDBA Desktop 4.2
Windows application that can either connect directly to SQL Server
for ad-hoc monitoring or to miniDBA Server for 24*7 enterprise monitoring
Download Desktop
miniDBA Server 4.2
Optional service & Website that monitors SQL Server 24*7
Supports unlimited miniDBA Desktop & Web/Mobile clients
Download Server
Changelog
Version 4.2 - September 5th 2024
Improved scalability and reliability
Added Microsoft SQL Best Practise Assessment
Added BPA results in report format
Added blitz health checks
Added Azure SQL Permissions check UI
Added ability to import alert config from other installations
Added ability to copy multiple alert configurations between servers
Added server group membership via AD group/login
Added number of active alerts shown in server tree view
Reduced load on monitored Azure SQL Databases
Bug fix - SQL Agent job history not displaying
Bug fix - Invalid license issues
Bug fix - Slow index useage query
Bug fix - Recovery state pending databases show in UI
Bug fix - Extended events swamping server
Bug fix - Index schema population in UI
Bug fix - History not showing execution plans
Bug fix - Slow log reading
Bug fix - Slow log writing
Bug fix - SQL Server not connected alert not displaying
Bug fix - Alerts not sending to Ms Teams
Bug fix - Active requests query getting locked
Misc Bug fixes
Version 4.1 - January 1st 2024
Added Azure SQL DB live extended events
Added Azure SQL Deadlocks Ex Events session
Added deadlocks to performance tuning dashboard
Added alert stopped message to Ms Teams
Added global SQL merics and waits dashboard
Added table schema to table view
Added table schema diagram to table view
Added Azure costs dashboard data components
Added Azure costs subscription scanning
Added DB Name to long running query alert
Added Waits normalness % metric
Increased SQL statement logged max size to 4000 characters
Storage technology upgraded to SqlLite
Bug fix - Blocking sessions not displaying correctly
Bug fix - Unused and Missing indexes displaying incorrectly
Bug fix - Azure SQL Deadlocks missing
Bug fix - Scroll bars UI consistanecy
Bug fix - SQL Agent active running jobs not displaying
Bug fix - Extended Events not displaying when wrong DLL used
Bug fix - DB Locks not always showing from service
Bug fix - Custom health checks not visible
Bug fix - Missing category from wait statistics info
Bug fix - Duplicate server groups
Bug fix - Extended events auto scroll not scrolling grid
Misc Bug fixes
Version 4.0 - January 1st 2023
Added Performance Tuning Dashboard
Added Azure Cost Dashboard
Added Azure AD MFA
Added Index Defrag options in all database nodes
Added Kill multiple sessions at once (highlight in grid)
Added Unused Index - show useage stats for all other tables indexes
Added Missing Index - show all other tables indexes
Added Server status window if license debug or expired
Improved Memory and CPU use
Improved Index Maintenance UI
Bug fix - Extended Event sessions not visible
Bug fix - Remember window startup location
Bug fix - Jira tickets not completing
Bug fix - Copy alerts config between servers
Bug fix - Query Store incorrect date range
Bug fix - Historic blocking sessions not loading
Bug fix - Infinate wait spinner when cancel new first connection
Bug fix - Timeout caused by deadlocks sql query
Bug fix - Some data grids do not allow copy to clipboard
Misc Bug fixes
Version 3.3 - April 10th 2022
Added Jira integration
Added alert stopped time field
Added custom alert optionally returns/reports recordset
Added Query Store health check
Added date/time range selector for Query Store
Added live wait types graph
Improved history load time when many files
Improved alerts grid context menus
Bug fix - Query Store execution plan sometimes not showing
Bug fix - alert recipients sometimes not persisting
Bug fix - ungrouping of trigger types
Bug fix - alert configuration context menus
Bug fix - remove disconnected server from UI
Misc Bug fixes
Version 3.2 - January 1st 2022
Added SQL Managed Instance support
Added server level query store view
Added server management groups
Added Query Store view for Azure SQL DB
Improved history load time
Improved deadlock information
Improved index fragmentation UI
Improved Azure SQL table information
Bug fix - historic waits sometimes not visible
Bug fix - clearing all alerts
Misc Bug fixes
Version 3.1 - September 12th 2021
Added Profiler/Extended Events
Added drilldown from extened event to query plan
Added Query Store view
Added Query performance history
Added T-SQL auto formatting
Added server build numbers
Added extra Azure DB alerts
Added clear multiple alerts
Improved offline DB handling
Improved logging detail
Reduced CPU use on monitored servers
Faster desktop startup time
Bug fix - historic alerts sometimes not visible
Bug fix - unecessary license check when connecting to server
Bug fix - reduced memory use
Misc Bug fixes
Version 3.0 - March 27th 2021
Added Azure SQL Database monitoring for Mini DBA Server
Added community average metrics (to compare against)
Added file near max size alert
Added transaction log full alert
Added job performance history graph
Added historic blocking queries
Added execute plan statement parameters
Added execute plan operator recommendations
Added sending email via anonymous SMTP server
Added extra 10000 length to captured SQL statements
Added Azure DB graph context menus
Added Azure DB tree view context menus
Added Website user portal login menu item
Improved connection time when over 50 servers
Improved Server UI
Improved Memory Consumption
Improved Enterprise Dashboard UI
Bug fix - Mini DBA Server hangs when stopping
Bug fix - Email users and groups not saving
Bug fix - Hidden job calendar
Bug fix - Alert text filter
Bug fix - Index management issues
Bug fix - Buffer average series sometimes missing
Bug fix - Blocking SQL alert not always being raised
Bug fix - SQL 2008 syntax
Bug fix - Index management scroll bars
Misc Bug fixes
Version 2.15 - June 4th 2020
Added support for SQL Server on Linux
Added Azure SQL DB elastic pools and pool summary
Added Azure SQL DB historic performance logging and reporting
Added Azure SQL DB performance report
Added Azure SQL DB DTU healthchecks and alerts
Added Azure SQL DB custom sql alerts
Added Azure SQL DB deadlock detection
Added Azure SQLs to enterprise dashboard
Added defragmentation of individual index partitions
Added recommended actions for most common wait types
Added history view options for all appropriate dashboards
Added schema name to index maintenance tree
Added default email groups for all alerts
Added Sendgrid configuration to UI
Added alert email sending failure warning to UI
Added historic view options to server node right click menu
Added drive free space donut chart
Added drive free space grid
Added selection of multiple indexes from grid for analysis/defrag
Added Operating System type to UI
Upgraded Disk drive performance UI
Upgraded Graph UI brushes
Upgraded fragmentation UI - chart shown by default
Bug fix - Blank memory state
Bug fix - Free list stall metric incorrect
Bug fix - Index defrag operation not always cancellable
Bug fix - Index frag % not showing new level after defrag operation
Bug fix - Alert email formatting
Bug fix - Index maintenance tree view nodes not sorted alphabetically
Bug fix - Index fragmentation analysis not running when user switches to frag tab
Bug fix - Reading SQL error log sometimes times out
Bug fix - Report export in CSV sometimes fails
Bug fix - Memory usage when viewing large query plans
Bug fix - Long running queries sometimes wrong execution times
Misc Bug fixes
Version 2.14 - December 22nd 2019
Azure SQL Database Dashboard
Improved deadlock detection and UI
Failed SQL logins now have their IP addresses looked up and details logged
History view shows alerts
History view shows deadlock XML graph
History view shows file space usage
Deadlocks view filterable
Text filter added to alerts
Optional time threshold added to alerts
Compare alerts configuration across servers
SQL connections sustained between queries to improve cloud connectivity
Trace flag 1222 (deadlock logging) removed from UI as superceded
Improved email configuration UI
Bug fix - Alert Configuration not always saving
Bug fix - Large deadlock strings causing memory leak
Bug fix - Multi-email address alerts sometimes not sending
Bug fix - Large sql error logs timeout when being displayed
Bug fix - Wrong start/stop menu icon
Bug fix - Blank filenames in File IO grid
Bug fix - Live execution plan memory leak
Bug fix - Alerts snooze period not always saving
Bug fix - Server not saving changes to logging folder location
UI improvements
Misc Bug fixes
Version 2.13 - July 24th 2019
Cloud hosted SQL Server connectivty enhancements
SSRS Dashboard (Active, History & Scheduled reports)
Agent active jobs view
Agent scheduled jobs view
Active Agent jobs count shown in tree view
Defragmentation given option of fill factor
Server connectivity log option on server node
Faster permissions testing
Top SQL time taken changed from microseconds to milliseconds
Memory usage reduced
Disk drive related alerts can ignore specified drives
Bug fix - Busy SQL Agent Timeout
Bug fix - Activity details not fully updating on grid click
Bug fix - History IO metrics failure
Bug fix - Alerts count button header old count
Bug fix - Alert duplication
Bug fix - Alerts not scheduled every 60 seconds wouldn't fire
Bug fix - Email settings update may lock UI
Bug fix - Email group sometimes missing members
Bug fix - Service config file moved to reduce file permissions issues
UI improvements
Misc Bug fixes
Version 2.12 - April 8th 2019
Pagerduty integration for raised alerts
Snooze alerts
Alerts settings presets selectable on new sql server connection
New setting for minimum seconds between alerts popups
New license menu group
UI updates to alert configuration
Less cpu consumed by graph updating
Reliably cancel index defrag jobs
Copy alert recipients
New enterprise tile style
Bug fix - Alert DB filter binding
Bug fix - CPU history graph gaps are zeroed for better UX
Bug fix - Primary replica identification
Bug fix - Alert threshold textbox validation
Bug fix - Index maintenance UI
UI improvements
Misc Bug fixes
Version 2.11 - January 9th 2019
Index maintenance screen
Defragmentation jobs
Email recipient groups
Email recipient availability windows
Better deadlock reporting on SQL Server 2016+
Better initial assesment of SQL Server permissions
Manual option for SQL activity refreshing
New Settings UI
Enterprise Dashboard Improvements
Execution plan automatically expands parent statements
Added "Give Feedback" option in help menu
Bug fix - High CPU usage on monitored SQL Servers after 7 days
Bug fix - Remove Internet Explorer enhanced security errors
Bug fix - Physical core and sockets count
Bug fix - Countries using commas as decimal seperators, log data db insert error
Bug fix - Desktop user feedback
UI improvements
Misc Bug fixes
Version 2.10 - September 27th 2018
Historic view of Disk IO Performance
% Disk Time Idle Metric Added
Optionally Save all data grid layouts
Added grid column filtering and ordering where appropriate
Windows Process view more reliable
Cpu Core usage metrics more reliable
Improved Permissions UI
Databases level sampling no longer time capped
Server activity grid no longer resets layout on refresh
Version upgrading UI improvements
Improved miniDBA Server licensing tool logging
Fixed - Deadlock report not completing
Fixed - miniDBA sessions not being ignored
Fixed - Missing session details
Fixed - Reports failing on named instances
UI improvements
Misc Bug fixes
Version 2.9 - June 28th 2018
Upgraded alert configuration options
Minor alerts now have their own email, slack and event log options
New ability to filter out certain databases for alerts
Copy database filter from other alert
Email alert content improved
Alert config options saving improved
Options window information text to help reduce desktop/server confusion
New execution plan logging option - query length threshold
Graphical query plan upgrade
Email config password requirement removed
Transaction log performance dashboard and log content split
Fixed - Occassional Email not sending
Fixed - Alert configuration not always saving
Version 2.8 - January 15th 2018
Query plans logged and available in performance history
Memory metrics available in performance history
History graphs now have right click menu at point in time to drill down to queries and waits
IO performance by drive/storage device
Graphical execution plans
Global wait statictics displayed from all miniDBA installations
Long running query alert now ignores queries containing configurable strings
Added export reports in PDF option
Upgraded data grid data exporting, filtering and sorting
Added new wait type description additions
Perfmon connectivity statuses shown on server dashboard
Fixed - deadlock graphs and execution plans > 4000 characters long not displaying
Fixed - new history data load not clearing old data
Fixed - server data not displayed straight away when switching servers
Fixed - query timeouts on servers with > 500 databases
Fixed - UI bugs when connecting to a slow server
Fixed - buffer IO metrics not being read properly from perfmon
Fixed - data source dialog could sometimes not be closed
Fixed - cpu ms metric always shown as 0 on sql servers with huge uptime
Fixed - reports screen not closing historic data screen
Fixed - tempdb log usage not being reported properly
Fixed - graph x and y axis label spacing
Fixed - missing historic wait stats
Fixed - missing historic index activity
Fixed - db storage query tuned for large servers
Version 2.7 - August 1st 2017
Server to Desktop connectivity enhanced
Wait type description additions
Metrics hub integration
Enhanced logging
Custom alert UI upgrade
Fragmentation query enhancements
More detailed database permissions
Live session query enhancements
Report formatting
miniDBA Server logs in UI
Required database permissions added to docs
License validation service uses web proxy if required
Bugfix - Live file IO always visible
Bugfix - Waits screen user feedback
Bugfix - Server processes UI upgrade
Bugfix - Historic data graph click
Bugfix - Missing deadlocks
Version 2.6 - December 12th 2016
Desktop
SQL 2016 Live Query Plan Statistics
Send Alerts to Slack
Performance Baselines
Rolling Hourly Average Metrics
Graph Context Menus
Maintenance Windows (Set Times Alerts Don't Get Raised)
Alerts Priority Filter
Alerts UI Upgrade
Splash Screen
Bugfix - Enterprise History Filter
Bugfix - Blank Alert Descriptions
Bugfix - Cancelling Test Email
Bugfix - Default Trace Schema Data Doubling
Bugfix - Un-Closable Empty Tip Box
Server
Broadcast Data Size Reduced 80%
Web Monitor UI Theme Update
Query Load Reduced When There are No Clients
Bugfix - License validation
Bugfix - Web Monitor Alert Config Tab Reset
Bugfix - Web Monitor IO and Drive Space
Bugfix - Web Monitor Null Session List
Misc
Bugfix - Long Running Alert
Bugfix - Disk Space Alert
Version 2.5.5 - October 18th 2016
Desktop
SQL Server dashboard graphs now have context menus
File IO data grid now shows updating live data
New File IO stalls graph
New File IO operations graph
Connections replaced with sessions and requests
SQL 2016 waits per session view
Live session estimated plan
Execution plan view layout improved
Re-enable checking for product update
Direct or miniDBA Server connection selection, moved to combo box
Waits screen - pie charts
New help dialog shown when connecting to an empty minidba server
Default trace node renamed to change history
Parallel sessions no longer suddenly fill live sessions grid
Enterprise view tiles sized for Network Operation Centers
Reports miniDBA Server memory usage
Email test UI updates
History load time performance increased
Bugfix - Top T-SQL UI issues
Bugfix - default trace schema grid doubling data
Bugfix - current alerts tab header not empty on startup
Bugfix - open execution plan in external tool
Bugfix - Window always comes to front on startup
Bugfix - Tips popup UI
Server
Error handling improvement - service host re-starts itself if necessary
License validation bugfix
Bugfix - healthchecks run on minidba server now show full description
Misc
Sending email no longer blocks monitoring if it takes a long time
Log write time alert changed to be per file
New Alert - Log Write Time
New Alert - Data File Write Time
New Alert - Average Log Write Time
New Alert - Average Data File Write Time
New Alert - Insufficient System Memory
Memory alerts now include current Session usage when triggered
Upgraded to .Net 4.6
Bugfix - long running alert
Bugfix - blocking spid alert
Version 2.5 - April 28th 2016
Desktop
Custom T-SQL healthchecks
Healthchecks have description and links to articles
Kill button for sessions
Always On properties on server dashboard
Always On enabled but errored alert
Option to not display system/miniDBA sessions
Deadlocks screen updated to have realtime graph
Historic waits has ordered grid of waits per minute
Historic waits have descriptions
Historic waits and active statements have accurate chart position clicking
Only drives used by SQL Server are monitored
More efficient CPU usage
Charts have more detailed tooltips
Max log flush KB - new chart line series
Bugfix - sessions have last batch column populated
Web Monitor
Can now be installed on seperate server to miniDBA Server
Improved logging
New connection bugfix
Misc
Log manager deletes files older than 30 days
Server license tool; license assembly major version error fixed
Multiple UI bugfixes
Version 2.4 - February 19th 2016
Desktop
New Reports screen with 5 pre-canned reports
Select data grids can add their data to a report
Send reports by email from within the application
SQL Agent screen with calendar view of job/step executions
Index heatmap graphics updated
SQL Memory dashboard improvements
Added last hour AVG to Page Life Expectancy chart
Server chart titles have tooltips with chart data descriptions
Web Monitor
New live session monitoring by session status
SQL Server properties tab
Required SQL Permissions for monitoring tab
Chart titles have tooltips with chart data descriptions
Backend logging for enhanced diagnostics
Fix: mismatching web monitor and server passwords reports the issue gracefully
Data grid column sorting and scrolling
Misc
Free disk alert only monitors drives used by sql server
File auto growth alert now has ms threshold
Fix: Deadlocks alert triggers multiple times on application start
Blocking session alert now has all spid details
Alerts configuration can be copied between servers to save time
Multiple UI bugfixes
Version 2.3 - November 24th 2015
Desktop
Historic data load times much reduced
Time drop down on SQL server dashboard - Live/Hour/12 Hours/24 Hours etc
Clear ALL alerts button
Permissions screen to enable easier monitoring setup
Web Monitor
Size of streaming data from server to client reduced
IIS memory consumption reduced hugely
IE login modal problem fixed
Misc
Sampling time reduced
New alert: File auto-growth
New alert: Failed login
New alert: Error log high severity
New alert: Error log medium severity
New alert: Sort warnings
New alert: Database Mirroring State Change
Version 2.2 - October 16th 2015
Desktop
Graph click through to appropriate dashboard
Email sender address added as an option
Alert workflow - comment and clear
Historic alert filter
Historic alert occurances
View performance data for alerts - red line on graphs
Instances summary extra columns
Tree shortcut to history with autoload of current day
History view of active sessions with their T-SQL
History graph zoom aligned
History view memory consumption reduced
Web Monitor
Size of streaming data from server to client reduced
IIS memory consumption reduced hugely
IE login modal problem fixed
Misc
New alert: file stall ms
New alert: log wait time
New alert: db log % full
Loading historic data time reduced by 500%
Version 2.1 - May 11th 2015
Desktop
Memory pressure property
Custom SQL alert configuration
Extra history graphs
Link to setup email from alerts page
Can filters dbs out of tree and summary pane
CPU scheduler history graphs
Memory Dashboard redesign and new metrics
IO dashboard reliablity bug fixes
TempDB log always visible on server dashboard
Enterprise node now has number of active alerts
DB summary screen has trans sec column
Server connectivity more reliable - UI components now always correct
client server conn dialog error better displayed
faster parallel loading of logs
t-sql colour highlighting
Server
Web Monitor introduced
Service starts with better default windows logon
License tool for server
Provides historic data - not just realtime
Misc
New alert: memory pressure
Loading historic data time reduced by 500%
log extra counters
much more efficient waits and full text requests
Logs total max size now actually deletes oldest file if necessary
Recording of deadlocks
Version 2.0 - July 17th 2014
Desktop
Log data folder added to options
Azure UI tweeks for indexes
history deadlock graph
history blocking graph
azure export excel
Bugfix: CPU node doesnt come back online after a stop command
SSAS stop/start with no mem leak or peaks
Admin/ reader roles enabled to help with long runners,index frag, errorlog
fixed ui performance when databases expanded
Reader role cant update interval secs from dropdown
Server
Index meta data now provided
Reflect light query mode through service to ui
CPU and windows process data provided
Drive IO data provided
All sampling goes to background mode (60 second interval) when no clients are connected
Version 1.6.1 - May 27th 2014
Desktop
SQL export to excel
SSAS export to excel
Email test button in options
Healthcheck button functionality
Modern UI overhaul
Tips window
Vertipaq history graph UI fixes
History date format now in user locale
Alert settings writing to db accurately
Option to turn off deadlock detail sampling - reduces error log entries
History cpu 4 hours out of sync bug fixed
Alert: sql free disk - drive name in reason
Alert: CPU needs threshold
Alert: logical drive space
SSAS metric logging
Server
Store sql server logins
Authenticates admin/reader
SQL history from service
Older...
14 Day Free Trial Sign Up
Start Your Free 14 Day Trial to Begin Monitoring Your SQL Servers Today
Email
Start Download