What's new in miniDBA Desktop 4.1.5231.0
Jan 2, 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
New in miniDBA Desktop 4.0.5166.0 (Jan 12, 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
New in miniDBA Desktop 3.3.5058.0 (Apr 9, 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
New in miniDBA Desktop 3.2.5017.0 (Jan 1, 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
New in miniDBA Desktop 3.1.1607.0 (Sep 13, 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
New in miniDBA Desktop 3.0.4672.0 (Mar 28, 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
New in miniDBA Desktop 2.14.4004 (Dec 24, 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
New in miniDBA Desktop 2.13.3718 (Dec 24, 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
New in miniDBA Desktop 2.12.3565 (Apr 9, 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
New in miniDBA Desktop 2.11.3503 (Jan 10, 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
New in miniDBA Desktop 2.8 (Jun 29, 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
New in miniDBA Desktop 2.7.0 Build 2780 (Aug 3, 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/li>
- Bugfix - Missing deadlocks
New in miniDBA Desktop 2.6.1.2724 (Feb 21, 2017)
- Bugfixes:
- Enterprise History Filter
- Blank Alert Descriptions
- Cancelling Test Email
- Default Trace Schema Data Doubling
- Un-Closable Empty Tip Box
- 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