Retour
-
Titre
How to create Azure SQL database agents using CLI -
Description
Beginning with the Azure SQL cartridge 6.1.5 it is now possible to deploy and monitor a large number of Azure SQL and Elastic Pool agents via the command line interface (CLI), using a predefined CSV file.
How can a user create new Azure SQL and Elastic Pool agents using CLI? -
Cause
One Elastic Pool can include numerous databases.
For the enhanced solution of monitoring Elastic Pools, how can users add monitoring quickly for all/number of the databases out of one or more Elastic Pools.
-
Résolution
The CSV file can be downloaded from the Foglight Management Server (FMS) as a Zip file, by going to Administration | Cartridges | Components for Download and downloading the file DB_Azure_CLI_Installer.
The downloaded ZIP file contains the following files:
- README.txt file
- a groovy script file that runs the silent installation. This file should be copied to the /bin directory.
- silent_installer_input_template.csv—a template file that should serve as the basis for inserting contents into the input CSV file. This file can be copied to any folder of your choice, provided that the path indicated by the parameter points to the selected path.
- two SQL scripts used to grant permissions and check Azure SQL agent permissions.
NOTE: If the database name is equal to "master" then an Elastic Pool agent will be created. In case of conflicts:- When an agent creation fails, the installer will skip it and continue running to install the next agent and then list those that failed with the reason of the failure in the output file.
- If there is an attempt to try and create an agent for a database already being monitored, the installer will skip the operation and proceed to the next database agent listed in the input file