SQL Databases monitor

%3CLINGO-SUB%20id%3D%22lingo-sub-789530%22%20slang%3D%22en-US%22%3ESQL%20Databases%20monitor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWe%20have%20a%20requirement%20to%20monitor%20the%20number%20of%20transactions%20per%20second%20on%20SQL%20Databases%20on%20hosted%20on%20azure%20servers%3F%20Can%20this%20be%20done%20using%20Log%20Analytics%20Workspace%3F%20If%20yes%20what%20Windows%20Performance%20Counters%20we%20need%20to%20enable%20in%20data%20collections%20of%20log%20analytics%20workspace%3F%20Please%20advice.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-789530%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789632%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Databases%20monitor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338025%22%20target%3D%22_blank%22%3E%40roopesh_shetty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EFor%20SQL%20in%20a%20Virtual%20Machine%20please%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fperformance-monitor%2Fsql-server-databases-object%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fperformance-monitor%2Fsql-server-databases-object%3Fview%3Dsql-server-2017%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20then%20enable%20the%20desired%20ones%20in%20the%20Log%20analytics%20portal%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125719i11E612370F836AA4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-08-06%20091758.png%22%20title%3D%22Annotation%202019-08-06%20091758.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20should%20also%20look%20at%20Azure%20Metrics%20-%20in%20case%20any%20of%20those%20options%20are%20relevant%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-monitor%2Fplatform%2Fmetrics-getting-started%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fazure-monitor%2Fplatform%2Fmetrics-getting-started%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi

We have a requirement to monitor the number of transactions per second on SQL Databases on hosted on azure servers? Can this be done using Log Analytics Workspace? If yes what Windows Performance Counters we need to enable in data collections of log analytics workspace? Please advice.

1 Reply
Highlighted

@roopesh_shetty 


For SQL in a Virtual Machine please see https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-databases-o...

 

You can then enable the desired ones in the Log analytics portal

Annotation 2019-08-06 091758.png

 

You should also look at Azure Metrics - in case any of those options are relevant https://docs.microsoft.com/en-gb/azure/azure-monitor/platform/metrics-getting-started