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.
- tee with utf-8 encoding
- PowerShell says "execution of scripts is disabled on this system."
- Calling a PowerShell script from within a VBScript and the use of quotes in the variable passed (JSON format variable)
- Install winget by the command line (powershell)
- How does threading in powershell work?
- System.IO.FileInfo and Relative Paths
- Iterating Json attributes and PSCustom Objects
- MS Graph API - How to query additional pages
- Certificate Rebind in IIS 10 using powershell
- How to make PowerShell tab completion work like Bash
- Powershell function to check input and return datatype is not returning correct values
- Convert string to DateTime in Powershell from CSV
- PowerShell Call SSIS package, Pass Two (or More) Parameters
- Print Local Group Members in PowerShell 5.0
- Get current computer's distinguished name in powershell without using the ActiveDirectory module
- Best PowerShell method to get the current Active Directory Site name of the local computer
- NetBIOS domain of computer in PowerShell
- How do find out short name of domain I'm in?
- Powershell : How to include the root directory while creating a zip using a function
- PSCustomObject to Hashtable
- How to create a Run As Administrator shortcut using PowerShell
- Az-GetRoleAssigments Not returning Data for DisplayName, SignInName & Object Type - Azure Powershell Runbook
- How to accept inline inputs in a noninteractive powershell script
- remove event subscriptions from system topics
- powershell parse Json file with \ and wildcard in the key name
- Is there a string concatenation shortcut in PowerShell?
- import files to databricks workspace
- How is child_process.exec('powershell "$userInput = Read-Host;"') handled in node.js?
- Can't use sed when using ssh with ms powershell to linux host
- Append information to the output of an existing command