How to configure the log analytics for single database and server?
I configured log analytics with Azure SQL Analytics (Preview) solution for monitoring the databases, servers and elastic pools.
For that, I followed the below links
Monitor Azure SQL Database using Azure SQL Analytics (Preview) in Log Analytics
Enable Azure resource metrics logging using PowerShell
I used below cmdlet for enable metrics and diagnostics for single database instead of all my databases.
Set-AzureRmDiagnosticSetting -ResourceId “/subscriptions/XXXXXX-XXX-XXX-XXX/resourceGroups/YYYYY/providers/Microsoft.Sql/servers/YYYY/databases/” -WorkspaceId “XXXXXX-XXX-XXX-XXX” -Enabled $True
But when I run the above cmdlet in PowerShell ISE with Administrator mode, I got the below error even I installed the Azure RM Modules.
Please take a look at: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-metrics-diag-logging
There you have the information about how to configure your database to send the telemetry into Log Analytics. In addition to PowerShell, this can be done through Azure Portal, CLI, REST API, and ARM template.
When it comes to the PowerShell problem, looks like you missed specifying the database in your ResourceId. You can configure the database or elastic pool to sent the telemetry into Log Analytics, you can't configure the server.
- VS code terminal can't find AWS SAM even though windows terminal can
- How to combine multiple conditions in a PowerShell if-statement
- Can I change Read-Host so it doesn't always end in a colon?
- How to call native XPath functions from Select-Xml?
- How to get all piped in objects at once when using Begin/Process/End blocks?
- Calling a method returned from another method in Powershell
- Powershell -- how to minimize the console the script is running in while sitting in a loop?
- Automation Account Script to delete Stale Devices
- Powershell version of cut -d is very slow on large files, am I missing the fast way to do it?
- how to use "if" statements inside pipeline
- Error When Connecting to Azure from PowerShell
- Execute powershell in x64 from MSBuild
- Powershell 5 and 7 processes double quotes in different way when running Cygwin
- SQL Package extract command is failing in PowerShell script
- Office 364 Audit logs: Search-UnifiedAuditLog is not recognized as the name of a cmdlet
- Empty path name is not legal - DTEXEC with Powershell
- Cannot remove PowerShell environment variables
- Is automating App Registration on Azure possible through ARM Template on the User's tenant?
- Powershell error "value can not in the type System Management Automation LanguagePrimitives+InternalPSCustomObject converted"
- Diskspace Report HTML Text Color Output
- Issue with Azure Automation Account and Key Vault Certificate Retrieval
- How to display current virtual environtment in python in oh-my-posh?
- How do I get a list of Service Principals in Azure via the CLI
- Handling special characters in password string
- What is the right way to check a switch parameter
- How to make ($Line_1`n$Line_2) work in a CMD script?
- .ps1 script reported as "Missing closing '}'" in .bat file script
- APPAP308E - Invalid process path. Full path is required
- How do I verify that a SMB server requires signing, preferably with Powershell?
- Import-Excel: Expand imported Excel columns to become individual row entries