VirtualMetric for Microsoft SQL

VirtualMetric provides most detailed Microsoft SQL Server monitoring and Microsoft SQL reporting solution on the market. You can get following reports by just enabling your MSSQL servers on VirtualMetric, although you don't have to do any changes on your servers:

  • Database Reports
  • Server Reports
  • Storage Reports
  • Network Reports
VirtualMetric SQL Server Monitoring - Dashboard

Database Reports

VirtualMetric can provide detailed information about health state, resource usage, database inventory, index fragmentation and expensive queries.

Inventory Reports

Database inventory reports like database users, database tables, stored procedures, database files, database replicas..

Event Log Reports

VirtualMetric can link all server event logs with databases. So you can easily check critical database event logs.

Stored Procedure Reports

Stored procedure creation dates, last modified dates, recompile status, startup status, encryption status..

Database Mirroring Reports

Database mirroring reports like mirroring safety level, mirroring status, witness status, safety sequence, mirroring role sequence..

Database User Reports

Database user and login reports like login type, create and last modified dates, login modes, authentication type..

Database Replica Reports

Detailed reports for SQL Server Always On like replica role, availability mode, replica group name and server name..

VirtualMetric Microsoft SQL Server Monitoring - Database

Server Reports

You should also monitor your SQL servers to ensure about your database environment health state. VirtualMetric provides best performance and inventory reports of your MSSQL servers.

Hardware Reports

VirtualMetric supports many physical server manufacturers to provide you best monitoring results. VirtualMetric uses IPMI to get health status of physical elements of your MSSQL servers like physical processor, physical memory, network card, hba, fan and power supply.

Temperature Reports

Temperature directly effects performance of physical servers. So it's very important to monitor processor, mainboard and environment temperature to avoid performance issues. VirtualMetric collects all temperature values by using IPMI protocol.

Network Reports

Monitoring database network layer is one of the many challenges for system administrators. VirtualMetric can monitor all networking layers to provide most accurate performance results and inventory reports. You can see following inventory details: Link speed, Jumbo Frames, RSS, VMQ, MTU Size, TCP Offload, UDP Offload, Driver Provider and NDIS version.

Operating System Reports

VirtualMetric also collects important inventory information of your MSSQL Servers to show you more detailed reports. VirtualMetric provides useful reports like event logs, firewall configuration, administrator reports and Windows Updates.

VirtualMetric Microsoft SQL Server Monitoring - SQL Server

Storage Reports

Performance reports of databases and performance & inventory reports of physical disks of Microsoft SQL Servers.

Database Storage Reports

- SQL Performance Monitoring: Read IOPS, Write IOPS and Total IOPS of your databases.

- SQL Performance Monitoring: Read Throughput, Write Throughput and Total Throughput of your databases.


Local Disk Reports

- SQL Monitoring: Physical disk number, model, signature and firmware version of local disks to check your raw disk inventory.

- SQL Monitoring: Storage brand and storage serial number. Currently EMC and 3Par storages are fully supported.

VirtualMetric Microsoft SQL Server Monitoring - Storage Overview

Network Reports

VirtualMetric also provides detailed network reports of your databases. VirtualMetric helps you to see network issues on your database servers.

Throughput Reports

- Received Throughput: Received traffic rate for your databases. If there is an anormal traffic on your database, you can rapidly see it.

- Sent Throughput: Sent traffic rate for your databases. If there is an anormal traffic on your database, you can rapidly see it.


Packets Transfers

- Packets Received: Received package rate for your databases. If there is an anormal traffic on your database, you can rapidly see it.

- Packets Sent: Sent package rate for your databases. If there is an anormal traffic on your database, you can rapidly see it.

VirtualMetric Microsoft IIS Monitoring - Cluster Management

Stored Procedures

SQL Reporting: VirtualMetric provides detailed monitoring reports for your stored procedures like cpu usage, read and write io usage and elapsed time.

Network Statistics

SQL Reporting: VirtualMetric can provide detailed network usage statistics of database servers like received and sent throughput and packet details like received and sent packets.

Storage Statistics

SQL Reporting: VirtualMetric is able to provide you Read and Write IO usage of your databases by checking executed queries, especially for shared web hosting servers.

VirtualMetric Hyper-V Monitoring - Network Reports

Network Reports

Monitoring SQL Server network layer is one of the many challenges for system administrators. VirtualMetric can monitor all networking layers to provide most accurate performance results and inventory reports. VirtualMetric provides bandwidth usage of databases to help you for chargeback options. Also monitoring post and get requests to see if there is problem with a database or there is a hacking attempt. You can also see VLAN information, network drivers, IP information and other useful reports. You can also get following inventory details for Microsoft SQL Servers: Link speed, Jumbo Frames, RSS, VMQ, MTU Size, TCP Offload, UDP Offload, Driver Provider and NDIS version.

Try VirtualMetric Free for 30 Days! Free Trial