THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Damian Widera

Public Preview for SQL Server vNext Management Pack (CTP2)

 

According to the SQL Server Release Services Team we have a new Management Pack (CTP2) for SQL Server vNext

The new CTP bits for SQL Server vNext Management Pack can be used to monitor SQL Servers both on Windows and Linux

Here is the list of new features and fixes in the CTP2:

 
  • Implemented “Discovery Data Mapper”; improved queries and datasources
  • Implemented support for full cookdown for all discoveries on Linux and Windows
  • Implemented Log Shipping monitoring
  • Implemented new monitors and rules:
    • “Service Pack Compliance” monitor
    • “SQL Server Windows Service” monitor
    • “CPU Utilization (%)” monitor
    • “SQL Server Service (database)” monitor
    • “Database Health Policy (Critical)” monitor
    • “Database Health Policy (Warning)” monitor
    • “WMI Health” monitor
    • “Memory Used By Tables (MB) rule
    • “Memory Used By Indexes (MB)” rule
    • “MSSQL vNext on Windows: DB Engine CPU Utilization (%)” rule
    • “SQL Server vNext DB Engine is restarted” rule
  • Implemented new DB Space performance rules:
    • MSSQL vNext: DB Allocated Space Unused (MB)
    • MSSQL vNext: DB Free Space Total (%)
    • MSSQL vNext: DB Free Outer Space (MB)
    • MSSQL vNext: DB Transaction Log
    • Free Space Total (%)
    • MSSQL vNext: DB Free Space Total (MB)
    • MSSQL vNext: DB Allocated Space Used (MB)
    • MSSQL vNext: DB Allocated Space (MB)
  • Implemented new classes:
    • SQL Server vNext DB FILESTREAM Filegroup on <Platform>
    • SQL Server vNext DB Memory-Optimized Data Container on <Platform>
    • Generic SQL Server vNext Custom User Policy
    • SQL Server vNext Custom User Policy on <Platform>
    • SQL Server vNext Database Critical Policy on <Platform>
    • SQL Server vNext Database Warning Policy on <Platform>
    • SQL Server vNext Resource Pool Group on <Platform>
    • Generic SQL Server vNext Resource Pool
    • SQL Server vNext Resource Pool on <Platform>
    • SQL Server vNext Internal Resource Pool on <Platform>
    • SQL Server vNext User Resource Pool on <Platform>
    • SQL Server vNext User-Defined Resource Pool on <Platform>
  • Implemented new monitor and rule for FILESTREAM objects:
    • MSSQL vNext on <Platform>: DB FILESTREAM Filegroup Free Space Total (MB)
    • MSSQL vNext on <Platform>: DB FILESTREAM Filegroup Free Space Total (%)
  • Implemented new performance rules for Memory-Optimized Data filegroups:
    • MSSQL vNext on Windows: DB Memory-Optimized Data Filegroup Free Space Total (MB)
    • MSSQL vNext on Windows: DB Memory-Optimized Data Filegroup Free Space Total (%)
  • Implemented “MSSQL LogReader” module
  • Implemented Event Collection monitoring for Linux and Windows (more than 400 workflows)
  • Implemented discoveries, rollups and icons for the new classes; updated Filegroup and child classes’ icons
  • Implemented all XTP counters (more than 200 workflows)
  • Implemented “Empty Bucket percent” in the hash index monitor
  • Implemented “Average length of the row chains” in the hash buckets monitor
  • Implemented “SQL Full-text Filter Daemon Launcher Service”; added “NetworkName” property to local dbengine; refactored Windows monitoring folder structure
  • Added “Local Database” class on Windows
  • Improved the architecture: split “Windows.DBEngine” and “Windows.LocalDBEngine” classes
  • Improved error logging
  • Improved the error-handling (connectivity issues)
  • Remounted “LocalDiscoverySeed” discovery to support long names and not support wow64
  • Updated Add Monitoring Wizard: fixed layouts issues, improved multithreading and performance, implemented background loading progress
  • Updated and fixed the Knowledge Base articles and display strings; unified the workflows naming template
  • Fixed alerts for classes managed by local agent
  • Fixed Smart Connect issues connected with cached data (WMI connection)
  • Fixed Linux modules to skip smart connect
  • Fixed issue: “Total Transactions Per Second” rule runs twice in one interval
  • Fixed issue: SQL Server vNext on Windows database objects may get rediscovered
  • Fixed issue: filegroups get undiscovered in SQL Express instance
  • Fixed issue: in some situations, Add Monitoring Wizard cannot detect that test connection task is completed
  • Fixed issue: the already discovered database objects are undiscovered if database state is changed to “Offline”

All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack. Full functionality will be available with SQL Server vNext GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

 

You can read more: http://bit.ly/2mK9DTe

You can download the software here: http://bit.ly/2lyk9g2

Cheers

Damian

Published Wednesday, March 1, 2017 2:18 PM by Damian

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement