The Microsoft SQL Server App provides insight into your SQL server performance metrics and errors. The App consists of predefined Dashboards, providing visibility into your environment for real-time or historical analysis on backup, restore, mirroring, database monitoring, general health and operations of your system. The Microsoft SQL Server App supports SQL Server 2014.
- The Microsoft SQL Server App is based on SQL Server ERRORLOG, which is typically found at:
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\ERRORLOG.
The ERRORLOG uses UTF-16LE encoding, which you will set when you configure the Source.
- The App also analyzes SQL Server performance metrics with logs generated using a VBS script.