Skip to content
Pre-release

@marcingminski marcingminski released this Dec 3, 2019 · 84 commits to 2_2_beta since this release

Beta can be installed via dbatools using the -PreRelease switch

  • Added Baselines to PowerBI Dashboard so we can see an overlay of performance data from past day, week and month.
  • Added more default Checks
    • Log Growths
    • Errors/sec
    • Logins/sec
    • Page life expectancy
    • Buffer cache hit ratio
    • Memory Grants Pending
    • Memory Grants Outstanding
    • Number of Deadlocks/sec
    • Readahead pages/sec
    • Lock Waits/sec
    • Lock Timeouts/sec
    • Lock Requests/sec
    • Average Wait Time (ms)
    • Page writes/sec
    • Page Lookups Rate
    • Page reads/sec
    • Lazy writes/sec
    • Free list stalls/sec
    • Page Split Rate
    • SQL Re-Compilations Rate
    • SQL Compilations Rate
    • Full Scan Rate
    • Long Running Open Transactions
    • Databases with no LOG backup
    • Databases with no DATA backup
    • Oldest DATA backup (days)
    • Oldest LOG backup (minutes)
    • Database page_verify not CHECKSUM
    • Databases not MULTI_USER
    • Databases not ONLINE
    • Databases with Auto Shrink Enabled
    • Databases with Auto Close Enabled
    • Queued actions have not been processed
    • Checks are failling
    • Check execution time is high
    • One or more disk will be full soon
    • Disk Free % is low
    • Action queue failure rate is high
    • Action queue is high
    • SQL Server Uptime is low
    • CPU Utilistaion
    • Blocking detected
    • Agent Job failure
  • Added more Action templates
  • Added more Reports
    • Long Open Transactions
    • Missing Log Backup Report
    • Missing Data Backup Report
    • Out of Date Data Backup Report
    • Out of Date Log Backup Report
    • Backup Report
    • Disk Utilisation Report
    • Blocked Processes
    • Agent Job failures
    • Indexes with high fragmentation
      Indexes with high fragmentation
  • Improved error logging for checks and actions
  • Bug fixes
  • Additional PBI dashboard to show Check status and results over time.
  • "Performance Issues" moved from PBI as checks to SQL.
  • Alternative dashboard for disk utilisation
  • Most of the data now exposed via dim and fact views
  • Updated wait stats categories for SQL 2016 as per tiger toolbox and Paul Randal's recommendation.
  • Excluded idle waits as per tiger toolbox and Paul Randal's recommendation
  • Added trend tables for Performance Counters with data aggregated over 1 hour and default retention of 2 years.
  • Added missing NOT NULL constraints where appropriate and removed unused columns (this will cause SqlPackage.exe to abort deployment due to potential data loss). Use with /p:BlockOnPossibleDataLoss=FALSE and take backup first.
  • Updated SSIS to reflect changes in the schema
  • Improved XES Blockers collector to reduce number of rows stored. Instead of storing every occurrence of the blocking chain it is now only storing the most recent occurrence.
  • Performance improvements.
  • Exclude DatabaseMail% Application name from long queries as it can hang around for a while every few minutes.
  • Added ability to remove all but most recent snapshot with the retention parameter = -1. This is handy for large collectors such as index stats and histograms.
  • Started capturing basic database options handy for alerting i.e. is OFFLINE, not MULTI_USER,, AUTO_CLOSE on, AUTO_SHRINK on etc
  • PowerBI throws an error when visuals that use R or Python are loaded even though they are not used. In this release unused visuals were removed to avoid such errors.
Assets 3
You can’t perform that action at this time.