How To Enable Auditing on SQL Database Servers or SQL Database on AZURE PORTAL
What is Auditing? Azure database auditing tracks database events and writes them to an audit log in your azure storage account, log analytics workspace, or Event Hub How useful it is? Helps you to understand database activities, events and let you know about any vulnerability occured on your sql database or sql database server. By analyzing reports can find any suspicious events, unusual activities and trends. How much does it costs? What is Retention Period? Depending upon the logs generated and storage type you choose to store the logs it costs you. You can Choose to write logs into: Storage Account Log Analytics Workspace Event Hub Before Selecting the Storage Account please consider your retention period (This period is nothing but the time period for which you want store the logs in storage account or workspace). For storage account you can choose retention days for 1 to 3285 days and if you want to go with infinite you can select retention period as 0 while enabling th...