{"id":6026,"date":"2022-08-24T11:17:52","date_gmt":"2022-08-24T11:17:52","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=6026"},"modified":"2022-08-24T11:17:52","modified_gmt":"2022-08-24T11:17:52","slug":"azure-sql-profiler-in-order-to-run-a-trace-against-sql-server-you-must-be-a-member-of-sysadmin","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/azure-sql-profiler-in-order-to-run-a-trace-against-sql-server-you-must-be-a-member-of-sysadmin","title":{"rendered":"Azure SQL Profiler &#8211; In order to run a trace against SQL Server you must be a member of sysadmin"},"content":{"rendered":"<p>You are not allowed to run a\u00a0<span class=\"markww884kgln\" data-markjs=\"true\" data-ogac=\"\" data-ogab=\"\" data-ogsc=\"\" data-ogsb=\"\">trace<\/span>\u00a0against Azure SQL Database.\u00a0<\/p><div class=\"x_elementToProof\">\u00a0To do query profiling on Azure SQL, you can use\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-gb\/azure\/sql-database\/sql-database-monitoring-with-dmvs#monitoring-query-performance\" target=\"_blank\" rel=\"noreferrer noopener\" data-auth=\"NotApplicable\" data-linkindex=\"0\">Dynamic Management Views<\/a>\u00a0or take a look at the\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-query-performance\" target=\"_blank\" rel=\"noreferrer noopener\" data-auth=\"NotApplicable\" data-linkindex=\"1\">Azure SQL Database Query Performance Insight<\/a>.<\/div><div><br \/>You can also Use &#8220;Azure Data Studio&#8221; with the &#8220;SQL Server Profiler&#8221; Extenstion. (see below MS links)<\/div><div class=\"x_elementToProof\"><p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/what-is?view=sql-server-ver15\" target=\"_blank\" rel=\"nofollow noreferrer noopener\" data-auth=\"NotApplicable\" data-linkindex=\"2\">https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/what-is?view=sql-server-ver15<\/a><\/p><p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/sql-server-profiler-extension?view=sql-server-ver15\" target=\"_blank\" rel=\"nofollow noreferrer noopener\" data-auth=\"NotApplicable\" data-linkindex=\"3\">https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/sql-server-profiler-extension?view=sql-server-ver15<\/a><\/p><\/div><p class=\"x_MsoNormal\">As an alternative to the Profiler, the Query Store feature is automatically enabled, you can see the top resource usage SQL Statement\u00a0 and also specify the time frame and statistics (by CPU, Reads, avg or total)<\/p><p id=\"ZcxhloU\"><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"322\" class=\"alignnone size-full wp-image-6045  img-responsive\" src=\"http:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608a31c30b.png\" alt=\"\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608a31c30b.png 614w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608a31c30b-300x157.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p><p class=\"x_MsoNormal\">Configure the Statistics and Time frame using the Configure button<\/p><p id=\"rpzvtfm\"><img loading=\"lazy\" decoding=\"async\" width=\"1232\" height=\"379\" class=\"alignnone size-full wp-image-6046  img-responsive\" src=\"http:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608b702679.png\" alt=\"\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608b702679.png 1232w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608b702679-300x92.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608b702679-1024x315.png 1024w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2022\/08\/img_630608b702679-768x236.png 768w\" sizes=\"auto, (max-width: 1232px) 100vw, 1232px\" \/><\/p>","protected":false},"excerpt":{"rendered":"<p>You are not allowed to run a\u00a0trace\u00a0against Azure SQL Database.\u00a0\u00a0To do query profiling on Azure SQL, you can use\u00a0Dynamic Management Views\u00a0or take a look at the\u00a0Azure SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3917,3918,1464,3919,3920,591,3916,3664],"class_list":["post-6026","post","type-post","status-publish","format-standard","hentry","category-research","tag-alter","tag-alter-trace","tag-azure","tag-profilder","tag-profiler","tag-sql","tag-sql-profiler","tag-trace"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=6026"}],"version-history":[{"count":2,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6026\/revisions"}],"predecessor-version":[{"id":6047,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/6026\/revisions\/6047"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=6026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=6026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=6026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}