When installing the central repository database on a virtual machine, ensure that it is installed on a physical disk mapped to the virtual machine. Typically, the repository database is installed on a non-production server under direct control of the DBA. Doing so will affect the performance of that instance. Installing the repository database on the same computer that’s hosting the monitored SQL Server instance is not recommended. Q: What are the requirements for the central repository database?Ī: The central repository database requires SQL Server 2008, or later, to be installed. The central repository database for storing the collected performance data.The SQL Servers that need to be monitored for collecting data about their performance.Q: Are there any connectivity requirements for the computer where the data gathering service is installed?Ī: The computer where the data gathering service is installed must have connectivity to: Though, the central repository database can be installed on another computer within the same network during the installation. Q: Where are ApexSQL Monitor components installed?Ī: The data gathering service, central repository database (by default), and the web server will be installed on the same computer. Web server – a self-hosted web server that allows user to communicate with the application via any supported web client (web browser).Central repository database – a SQL Server database that stores all data collected by the data gathering service.
![apex sql monitor apex sql monitor](https://s33170.pcdn.co/wp-content/uploads/2014/12/MetricSettingsa.png)
#Apex sql monitor windows#
Data gathering service – a Windows service that continuously monitors SQL Servers.The ApexSQL Monitor installation comprises three main components: This article provides all necessary information about ApexSQL Monitor needed by the first time user to successfully evaluate and/or use the application.ĪpexSQL Monitor is an agentless application that does not require anything to be installed on monitored SQL Servers.