Getting started on getting SQL server metrics in C#

September 28, 2023 ยท View on GitHub

Azure SQL sample for getting SQL Server and Databases metrics

  • Create a primary SQL Server with a sample database.
  • Run some queries on the sample database.
  • Create a new table and insert some values into the database.
  • List the SQL subscription usage metrics, the database usage metrics and the other database metrics
  • Use the Monitor Service Fluent APIs to list the SQL Server metrics and the SQL Database metrics
  • Delete Sql Server

Running this Sample

To run this sample:

Set the environment variable CLIENT_ID,CLIENT_SECRET,TENANT_ID,SUBSCRIPTION_ID with the full path for an auth file. See how to create an auth file. git clone https://github.com/Azure-Samples/sql-database-dotnet-get-sql-server-metrics.git

cd sql-database-dotnet-get-sql-server-metrics

dotnet build

bin\Debug\net452\GettingSqlServerMetrics.exe

More information

Azure Management Libraries for C# Azure .Net Developer Center If you don't have a Microsoft Azure subscription you can get a FREE trial account here


This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.