%3CLINGO-SUB%20id%3D%22lingo-sub-1381302%22%20slang%3D%22en-US%22%3EPerformance%20Benchmark%20-%20Azure%20Synapse%20Analytics%20(Data%20Warehouse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1381302%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22lia-align-justify%22%3E%3CSPAN%20style%3D%22font-size%3A%20medium%3B%22%3EToday%2C%20any%20organization%20who%20is%20ready%20to%20spin%20Azure%20service%20always%20curious%20of%20performance%2C%20load%2C%20design%20etc.%20The%20story%20is%20no%20different%20with%20data.%20With%20Azure%20Synapse%20DWH%20organization%20want%20to%20make%20sure%20they%20choose%20right%20skus%20and%20design%20to%20benefit%20customer%20and%20themselves.%20Any%20organization%20can%20come%20up%20with%20following%20questions%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-justify%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%0A%3CUL%3E%0A%3CLI%20class%3D%22lia-align-justify%22%3E%3CSPAN%3EAre%26nbsp%3Bwe%26nbsp%3Bchoosing%26nbsp%3Bright%26nbsp%3Bsku%26nbsp%3Bfor%26nbsp%3Bcurrent%26nbsp%3Band%26nbsp%3Bfuture%26nbsp%3Bworkload%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-justify%22%3EAre%26nbsp%3Bwe%26nbsp%3Butilizing%26nbsp%3Bthe%26nbsp%3Bresources%26nbsp%3Bwell%3F%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-justify%22%3EWhat%26nbsp%3Babout%26nbsp%3Bthe%26nbsp%3Blatency%3F%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-justify%22%3EBased%26nbsp%3Bon%26nbsp%3Bupcoming%26nbsp%3Brequest%2C%26nbsp%3Bwhat%26nbsp%3Bwill%26nbsp%3Bbe%26nbsp%3Bthe%26nbsp%3Bimpact%26nbsp%3Bon%26nbsp%3Ballocated%26nbsp%3Bresources%20aka%20load%20testing%3F%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-justify%22%3EHow%26nbsp%3Bto%26nbsp%3Bmake%26nbsp%3Bsure%20queries%26nbsp%3Bare%26nbsp%3Bperforming%26nbsp%3Bwell%26nbsp%3Bon%26nbsp%3BDWH%26nbsp%3Bdesign%3F%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-align-justify%22%3EHow%26nbsp%3Bto%26nbsp%3Bbuild%26nbsp%3Bbaseline%26nbsp%3Bmatrix%3F%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CDIV%20class%3D%22lia-align-justify%22%3EWell%2C%20one%20of%20the%20ways%20is%20to%20monitor%20(and%20setup%20alerts)%20the%20service%20on%26nbsp%3B%20production%20environment%20and%20adjust%20the%20sku.%20However%20this%26nbsp%3Bmay%20impact%20the%20user%20experience%26nbsp%3B%20and%20become%20hard%20practice%26nbsp%3Bto%26nbsp%3Bfollow.%26nbsp%3BThis%20blog%20post%20try%20to%20overcome%20such%20problems%20in%20advance%20to%20avoid%20any%20surprises%20on%20production%20environment.%20The%20focus%20will%20be%20on%20building%20a%20framework%20to%20simulate%20the%20load%20with%20multiple%20sql%20queries%20and%20get%20answer%20for%20above%20questions.%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%20class%3D%22lia-align-justify%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%0A%3CDIV%20class%3D%22lia-align-left%22%3E%3CFONT%20size%3D%224%22%3E%3CSTRONG%3EReference%26nbsp%3BArchitecture%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FDIV%3E%0A%3CDIV%20class%3D%22lia-align-justify%22%3E%3CSPAN%3EIn%26nbsp%3Bthis%26nbsp%3Bend%26nbsp%3Bto%26nbsp%3Bend%26nbsp%3Barchitecture%2C%20we'll%20simulate%20the%20load%20from%20different%20regions%20with%20different%20queries.%20The%20outcome%20will%20help%20us%20understand%20if%20we%20choose%20right%20sku%20and%20setup%20good%26nbsp%3B%20DWH%20design%20like%20table%20distribution%2C%20index%2C%20cache%20etc%26nbsp%3B.%20Here%20is%20the%20reference%20architecture%20of%20the%20framework%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3E%3CSPAN%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22RefArch.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190789iD1AF4350AFE5FEB5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22RefArch.jpg%22%20alt%3D%22Architecture%20diagram%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EArchitecture%20diagram%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CP%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3EAll%20scripts%20and%20step%20by%20step%20guide%20can%20be%20found%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%20style%3D%22font-family%3A%20inherit%3B%22%3E%3CA%20title%3D%22Details%22%20href%3D%22https%3A%2F%2Fgithub.com%2Frawatsudhir1%2FAzureSynapseDWH%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3E.%20However%2C%20below%20are%20the%20steps%20to%20build%20the%20framework%20along%20with%20few%20pictures.%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%3E%3CSTRONG%3E%3CFONT%20size%3D%224%22%3ESetting%26nbsp%3Bup%26nbsp%3Benvironment%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FDIV%3E%0A%3COL%3E%0A%3CLI%20class%3D%22lia-indent-padding-left-30px%22%3EAzure%26nbsp%3BSynapse%26nbsp%3BAnalytics%26nbsp%3B(Data%26nbsp%3Bwarehouse)%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-indent-padding-left-30px%22%3ESetup%26nbsp%3BData%26nbsp%3Bwarehouse%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-indent-padding-left-30px%22%3E%3CDIV%3EDownload%20and%26nbsp%3Bconfigure%26nbsp%3BApache%26nbsp%3BJmeter%3C%2FDIV%3E%0A%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-indent-padding-left-30px%22%3EBuild%26nbsp%3BJava%26nbsp%3BManagement%26nbsp%3BExtension%26nbsp%3B(aka%26nbsp%3Bjmx)%26nbsp%3Bfile%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-indent-padding-left-30px%22%3EMove%26nbsp%3Bscripts%26nbsp%3Bto%26nbsp%3BAzure%26nbsp%3Bstorage%3C%2FLI%3E%0A%3CLI%20class%3D%22lia-indent-padding-left-30px%22%3EExecute%26nbsp%3Bwork%26nbsp%3Bload%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CDIV%3E%3CSPAN%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22JDBCRequest.jpg%22%20style%3D%22width%3A%20941px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190810iC0B2633FE2EAC041%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22JDBCRequest.jpg%22%20alt%3D%22JDBC%20Request%20Diagram%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EJDBC%20Request%20Diagram%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22PowerShellOutput.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190814iF1EDECC62DFA5584%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PowerShellOutput.jpg%22%20alt%3D%22PowerShell%20Outcome%20Diagram%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPowerShell%20Outcome%20Diagram%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%20style%3D%22font-family%3A%20inherit%3B%22%3EAnalyse%26nbsp%3Bthe%26nbsp%3BTest%26nbsp%3BResults%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FDIV%3E%0A%3COL%3E%0A%3CLI%3E%3CDIV%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%3E%3CSPAN%3EInvestigate%26nbsp%3Bresult%26nbsp%3Bover%20Azure%20portal%20dashboard%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FDIV%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EUnderstand%20the%20bottleneck%20and%20performance%3C%2FFONT%3E%3CBR%20%2F%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B1)%20Table%26nbsp%3BDistribution%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2)%20Partition%26nbsp%3Bstrategy%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3)%20Index%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B4)%20Cache%3C%2FSPAN%3E%3C%2FDIV%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B6)%20Views%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CDIV%3E%3CFONT%20size%3D%224%22%3EApache%20Jmeter%20Report%3C%2FFONT%3E%3C%2FDIV%3E%0A%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22QueryExecutedReport.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190811i9289B9B839A86149%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22QueryExecutedReport.jpg%22%20alt%3D%22PBI%20Dashboard%20Diagram%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPBI%20Dashboard%20Diagram%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22QueryExecutionStatus.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190813i1051AFAED122EC47%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22QueryExecutionStatus.jpg%22%20alt%3D%22Query%20Execution%20Diagram%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EQuery%20Execution%20Diagram%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1381302%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22RefArch.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190787i203DB7F12132D08F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22RefArch.jpg%22%20alt%3D%22RefArch.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20framework%20to%20answer%20various%20questions%20(on%20design%2C%20load%2C%20performance%20etc)%20before%20organization%20go%20live%20with%20Azure%20Synapse%20Analytics%20(Data%20Warehouse).%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1381302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Administration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1425965%22%20slang%3D%22en-US%22%3ERe%3A%20Performance%20Benchmark%20-%20Azure%20Synapse%20Analytics%20(Data%20Warehouse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1425965%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F159563%22%20target%3D%22_blank%22%3E%40Sudhir%20Rawat%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3ECould%20you%20please%20help%20how%20to%20troubleshoot%20performance%20issues%20in%20Azure%20Synapse%20step%20by%20step%20like%20SQL%20server%20(on-prem%20db)%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428068%22%20slang%3D%22en-US%22%3ERe%3A%20Performance%20Benchmark%20-%20Azure%20Synapse%20Analytics%20(Data%20Warehouse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428068%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683181%22%20target%3D%22_blank%22%3E%40MallikarjunaAvula%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20sure%20you%20will%20agree%20that%20document%20performance%20issues%20and%20how%20to%20troubleshoot%20requires%20more%20time%20and%20efforts.%20So%20I%20am%20interested%20to%20know%20what%2C%20where%20and%20how%20you%20need%20my%20help.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-Sudhir%20Rawat%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787872%22%20slang%3D%22en-US%22%3ERe%3A%20Performance%20Benchmark%20-%20Azure%20Synapse%20Analytics%20(Data%20Warehouse)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787872%22%20slang%3D%22en-US%22%3E%3CP%3E%40%3CSPAN%20class%3D%22UserName%20lia-user-name%20lia-user-rank-Occasional-Visitor%20lia-component-message-view-widget-author-username%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683181%22%20target%3D%22_self%22%3E%3CSPAN%20class%3D%22%22%3EMallikarjunaAvula%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22UserName%20lia-user-name%20lia-user-rank-Occasional-Visitor%20lia-component-message-view-widget-author-username%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EAzure%20Synapse%20SQL%20Monitor%20gives%20you%20a%20comprehensive%20insight%20into%20your%20workloads%20and%20end-to-end%20visibility%20into%20the%20performance%20of%20your%20SQL%20data%20warehouse%2C%20helping%20you%20to%20dramatically%20reduce%20the%20time%20it%20takes%20to%20isolate%20and%20fix%20data%20warehouse%20issues.%20The%20monitor%20provides%20an%20intuitive%20interface%20on%20a%20single%20pane%20of%20glass%20that%20visualizes%20data%20warehouses%20and%20server%20activity%20so%20you%20can%20see%20at%20a%20glance%20where%20problem%20areas%20are.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22UserName%20lia-user-name%20lia-user-rank-Occasional-Visitor%20lia-component-message-view-widget-author-username%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fazuremarketplace.microsoft.com%2Fen-us%2Fmarketplace%2Fapps%2Fcreativesoftware.synapse_sql_monitor_saas%3Ftab%3DOverview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fazuremarketplace.microsoft.com%2Fen-us%2Fmarketplace%2Fapps%2Fcreativesoftware.synapse_sql_monitor_saas%3Ftab%3DOverview%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Today, any organization who is ready to spin Azure service always curious of performance, load, design etc. The story is no different with data. With Azure Synapse DWH organization want to make sure they choose right skus and design to benefit customer and themselves. Any organization can come up with following questions 

 

  • Are we choosing right sku for current and future workload? 
  • Are we utilizing the resources well?
  • What about the latency?
  • Based on upcoming request, what will be the impact on allocated resources aka load testing?
  • How to make sure queries are performing well on DWH design?
  • How to build baseline matrix?
Well, one of the ways is to monitor (and setup alerts) the service on  production environment and adjust the sku. However this may impact the user experience  and become hard practice to follow. This blog post try to overcome such problems in advance to avoid any surprises on production environment. The focus will be on building a framework to simulate the load with multiple sql queries and get answer for above questions.

 

Reference Architecture
In this end to end architecture, we'll simulate the load from different regions with different queries. The outcome will help us understand if we choose right sku and setup good  DWH design like table distribution, index, cache etc . Here is the reference architecture of the framework
 
Architecture diagramArchitecture diagram

All scripts and step by step guide can be found here. However, below are the steps to build the framework along with few pictures.  

 
Setting up environment
  1. Azure Synapse Analytics (Data warehouse)
  2. Setup Data warehouse
  3. Download and configure Apache Jmeter
  4. Build Java Management Extension (aka jmx) file
  5. Move scripts to Azure storage
  6. Execute work load
JDBC Request DiagramJDBC Request Diagram

PowerShell Outcome DiagramPowerShell Outcome Diagram

Analyse the Test Results

  1. Investigate result over Azure portal dashboard
  2. Understand the bottleneck and performance
           1) Table Distribution
           2) Partition strategy
           3) Index
           4) Cache
           6) Views
  3. Apache Jmeter Report

PBI Dashboard DiagramPBI Dashboard Diagram

Query Execution DiagramQuery Execution Diagram

 

3 Comments
Occasional Visitor

Hi @Sudhir Rawat ,

Could you please help how to troubleshoot performance issues in Azure Synapse step by step like SQL server (on-prem db) ?

Microsoft

Hi @MallikarjunaAvula ,

 

I am sure you will agree that document performance issues and how to troubleshoot requires more time and efforts. So I am interested to know what, where and how you need my help.   

 

-Sudhir Rawat 

Occasional Visitor

@MallikarjunaAvula

 

Azure Synapse SQL Monitor gives you a comprehensive insight into your workloads and end-to-end visibility into the performance of your SQL data warehouse, helping you to dramatically reduce the time it takes to isolate and fix data warehouse issues. The monitor provides an intuitive interface on a single pane of glass that visualizes data warehouses and server activity so you can see at a glance where problem areas are.

 

https://azuremarketplace.microsoft.com/en-us/marketplace/apps/creativesoftware.synapse_sql_monitor_s...