SQL Server

Server & Database Dashboards

  • See realtime graphical views of servers, databases, connections, CPU, waits, memory, storage, disk latency and more
  • Live session view - who is currently running what T-SQL, who is blocking who & live resource usage (CPU, index, memory)
  • Find problems quickly using easy to understand visualizations & without any T-SQL necessary

Monitor & Alert

  • Set up configurable alerts across your server environment that cover the areas of: Blocking & Deadlocks, Long running queries, Buffer & Disk activity, File sizes, SQL & non SQL Cpu usage and more
  • Be alerted 3 ways - miniDBA in application alerts, Email & Windows event log

Performance tune T-SQL

  • Identify worst performing statements & causes (CPU, IO, memory, locks)
  • Index analysis - Live index usage, Fragmentation with the index heatmap & Unused\Recommended indexes
  • Wait statistics - See live view of current & total waits & associated wait type descriptions

Health Checks

  • Run over 50 diagnostic checks at server & database level with 1 click.
  • Be warned of configuration, design or performance problems; key information for performance tuning.

Analyse History

  • Sampled data is stored and can be viewed in the History Viewer: SQL performance counters, wait statistics, deadlocks & T-Sql are all available for performance analysis
  • Review historic saved data to plan scaling & increase the lifespan of your hardware
  • Monitor data is written to an internal database - no need to setup & license a logging database

Versions Supported

SQL Server 2005, 2008, 2012 & 2014

Permission Requirements

High level permissions such as SA or DBO are not necessary - just public role or VIEW SERVER STATE

Azure SQL Database

Azure specific usage

  • Bandwidth, Throttling, Storage
  • Database wait statistics
  • Diagnostic checks written for Azure SQL Database

Monitor & Alert

  • Set up configurable alerts across your Azure Databases that cover the areas of: Blocking & Deadlocks, Long running queries, Buffer activity, Cpu usage and more
  • Be alerted 3 ways - miniDBA in application alerts, Email & Windows event log

Performance tune T-SQL

  • Identify worst performing statements & causes (CPU, IO, memory, locks)
  • Index analysis - Live index usage, Fragmentation with the index heatmap & Unused\Recommended indexes
  • Wait statistics - See live view of current & total waits & associated wait type descriptions

Health Checks

  • Run over 20 diagnostic checks at server & database level with 1 click
  • Be warned of configuration, design or performance problems; key information for performance tuning

Analyse History

  • Sampled data is stored and can be viewed in the History Viewer: performance counters, waits, deadlocks & Sql are all available for performance analysis
  • Review historic saved data to plan Azure scale up and or out
  • Monitor data is written to an internal database - no need to setup & license a logging database

Analysis Services

MDM & Tabular Dashboards

  • Graphical view of instance activity
  • Cpu & Thread usage
  • Disk activity
  • Memory usage
  • Query & processing memory consumption
  • Processing activity

Monitor & Alert

  • Set up configurable alerts across your SSAS Databases
  • Server & database status (going offline/unprocessed)
  • Blocking & Deadlocks
  • Long running queries
  • High disk activity
  • Be alerted 3 ways - miniDBA in application alerts, Email & Windows event log

Live session view

  • Who is currently running what query
  • Who is currently consuming what server resources
  • Who is blocking and deadlocking

Database Views

  • Side by side view of all databases on a server
  • Compare Storage Size, Processed state, Cpu usage
  • See what session/user activity is taking place in each database
  • Identify which databases are consuming the most server resources

Analyse History

  • Sampled data is stored and can be viewed in the History Viewer: performancecounters, waits, deadlocks & Sql are all available for performance analysis
  • Review historic saved data to plan server scale up and or out to extend hardware lifetime
  • Monitor data is written to an internal database - no need to setup & license a logging database

miniDBA Desktop

Stand alone Application

  • Totally self contained monitoring and data logging.
  • No need for miniDBA Server or backend log storage databases.
  • Windows XP, Vista, 7, 8, Server 2003/2008/2012
  • Great for ad-hoc monitoring and performance tuning of SQL, Azure Db & SSAS
  • From $99 USD

Optional use of miniDBA Server

  • Monitoring is ad-hoc as it stops when miniDBA client is closed where as server keeps monitoring 24*7.
  • Instead of connecting directly to the database miniDBA client can connect to miniDBA server
  • Teams may choose to have all clients connect to a single miniDBA Server instead of direct connections to the database servers to reduce server load.
  • Ideal for production and larger team environments.
  • Resource intensive features can be disabled for miniDBA clients.

Performance tune T-SQL

  • Identify worst performing statements & causes (CPU, IO, memory, locks)
  • Index analysis - Live index usage, Fragmentation with the index heatmap & Unused\Recommended indexes
  • Wait statistics - See live view of current & total waits & associated wait type descriptions

Health Checks

  • Run over 50 diagnostic checks at server & database level with 1 click.
  • Be warned of configuration, design or performance problems; key information for performance tuning.

Analyse History

  • Sampled data is stored and can be viewed in the History Viewer: performancecounters, waits, deadlocks & Sql are all available for performance analysis
  • Review historic saved data to plan scaling & increase the lifespan of your hardware
  • Monitor data is written to an internal database - no need to setup & license a logging database

miniDBA Server

24*7 Monitoring

  • Windows Service with a IIS Web Adminstration UI.
  • Collects data from all your SQL Servers constantly.
  • Raises configurable alerts around the clock.
  • Self contained data logging requires no backend database setup
  • Licensed per monitored instance

Monitored servers shared with miniDBA Desktop

  • miniDBA Server supports an unlimited amount of miniDBA Desktops connecting to it for administration and performance analysis
  • Client/Server model makes multi user environments affordable as the monitored instances are only paid for once, on the server
  • miniDBA Desktops only need a basic single server license to see all the servers miniDBA Server is monitoring
  • Ideal for production and larger team environments.

Stored alert history

  • Unlike miniDBA client, the server stores all raised alerts
  • Allows users to go back in time to see what alerts have been raised
  • Enables detailed forensic investigation of server issues

Smart Historic Data Storage

  • Sampled data is stored in a configurable network folder
  • Oldest data will be deleted when the folder reaches a chosen size.
  • Never worry about logging data filling a drive.

Configuration through miniDBA client

  • A single miniDBA client (Enterprise Edition) is required to connect to the server to configure it.
  • This cost is much reduced when buying bundles of a server plus multiple Desktops.
  • Desktops connect as either Administrators or Readers role

miniDBA Web Monitor

Mobile Monitoring

  • Raises configurable alerts around the clock.
  • Self contained data logging requires no backend database setup
  • Windows XP, Vista, 7, 8, Server 2003/2008/2012
  • Great for constant monitoring & team development environments
  • $199 USD per monitored instance - less when bought in a bundle

Monitored servers shared with miniDBA Desktops

  • miniDBA Server supports an unlimited amount of miniDBA Desktops connecting to it for administration and performance analysis
  • Client/Server model makes multi user environments affordable as the monitored instances are only paid for once, on the server
  • miniDBA Desktop only need a basic single server license to see all the servers miniDBA Server is monitoring
  • Ideal for production and larger team environments.

Stored alert history

  • Unlike miniDBA client, the server stores all raised alerts
  • Allows users to go back in time to see what alerts have been raised
  • Enables detailed forensic investigation of server issues

Smart Historic Data Storage

  • Sampled data is stored in a configurable network folder
  • Oldest data will be deleted when the folder reaches a chosen size.
  • Never worry about logging data filling a drive.

Configuration through miniDBA client

  • A single miniDBA client (Enterprise Edition) is required to connect to the server to configure it.
  • This cost is much reduced when buying bundles of a server plus multiple Desktops.
  • Desktops connect as either Administrators or Readers role