Microsoft SQL
Microsoft SQL is the monitoring module for Microsoft SQL Server. You can monitor performance counters and get inventory reports for your SQL Servers and databases.
You can reach Microsoft SQL module monitoring and reports via left menu.
Module Reports
VirtualMetric collects following inventory reports for Microsoft SQL module.
Bare Metal Reports
Server Reports
Database Reports
Module Counters
VirtualMetric collects following performance counters for Microsoft SQL module.
Processor
Memory
Paging File
Network Interface
LogicalDisk
PhysicalDisk
Buffer Manager
Memory Manager
SQL Statistics
General Statistics
Access Methods
Locks
Plan Cache
Databases
Database Files
Stored Procedures
Index Stats
Table Stats
Database Replica
Availability Replica
User Permissions
If you want to use non-administrator user for VirtualMetric, you need to add the following changes for the user account in addition to Bare Metal permissions.
MSSQL Service Configuration
You need to open CMD window to configure Security Descriptions for MSSQLSERVER Service. Type following command on CMD:
You will see default security descriptor of the MSSQLSERVER Service.
Add the following security descriptor to MSSQLSERVER security descriptions:
Update the Security Description via following command:
SSMS User Configurations
Using SSMS add user to Server Logins:
Choose user and click OK button:
From Securables tab select Search and choose The Server selection.
And enable the following permissions:
Login Securables Options
Requirements
Following SQL components are required to monitor Microsoft SQL:
You can install required components via following MSI package:
Following Windows features are required to monitor Microsoft SQL Clusters:
You can install required features with following PowerShell command:
Last updated