#Installing sql server client agent install
Install the SQL Sentry client, monitoring service, and database on the same network for the best performance. Simply add the SQL Server as a monitored target.
#Installing sql server client agent license
A free license is included in every SQL Sentry installation for this purpose. You should always monitor the SQL Sentry database with SQL Sentry to ensure there are no CPU, memory, or disk bottlenecks. Modern flash or hybrid storage systems should be used for maximum scalability and performance. The greater the number of monitored targets, the more data is collected and stored in the SQL Sentry database, and the more fast storage becomes important. High disk latency (>5ms per read IO avg, >1-2ms per write IO avg) can limit scalability and cause sluggishness with the SQL Sentry client. Use Fast Storage for the SQL Sentry Database For more information, see the System Requirements section. Azure SQL Database is not supported for the SQL Sentry database. Important: The SQL Sentry database must be installed on a SQL Server 2014 or higher instance. If you are using the EPI version of SQL Sentry, then it must be installed on a machine that has the SQL Sentry controller service.It can be installed on a machine along with the SQL Sentry monitoring service and SQL Sentry client, or it can be installed on a machine by itself without any other SQL Sentry components (recommended). The SQL Sentry portal service is part of the optional SQL Sentry Portal feature that may be installed.For monitoring cloud targets, the SQL Sentry monitoring service may be installed either on-premises, or on a Windows virtual machine (IaaS) in the respective cloud platform.
The SQL Sentry monitoring service is a Windows service and is installed on a dedicated server or VM with network connectivity to the SQL Sentry database server and monitored targets.
0 kommentar(er)
