Azure SQL Solution
The Azure SQL Solution is a comprehensive set of pre-configured audit jobs and reports that provide information on users and roles, activity, permissions, configuration, sensitive data, and overall security assessment for Azure SQL.
Supported Platforms
- Azure SQL
Requirements, Permissions, and Ports
See the Target Azure SQL Requirements, Permissions, and Ports topic for additional information.
Sensitive Data Discovery Considerations
If you run Sensitive Data Discovery (SDD) scans, you must increase the minimum amount of RAM. Each thread requires a minimum of 2 additional GB of RAM per host. For example, a job configured to scan 8 hosts at a time requires an extra 16 GB of RAM (8x2=16).
Access Analyzer installs the appropriate JDK (Java) version for Sensitive Data Discovery on the server. The JDK deployed is prepackaged and doesn't require any configuration; it has been preconfigured to work with Access Analyzer and should never be customized through Java. It will not conflict with other JDKs or Java Runtimes in the same environment.
Location
The Azure SQL Solution is located within the Jobs tree, as part of the Database Solution: Jobs > Database > Azure SQL.
The Database Solution license covers all database platforms that Access Analyzer supports. Additionally, Sensitive Data Discovery enables the solution to search database content for sensitive data.
The Azure SQL Solution includes:
- Databases > 0.Collection > AzureSQL > 0.Collection > Azure SQL Job Group — This job group collects high-level summary information from targeted Azure SQL Instances. Other jobs in the Azure SQL solution use this information for further analysis and to produce reports.