Home
%3CLINGO-SUB%20id%3D%22lingo-sub-436694%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-436694%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20the%20tutorial%20links%20are%20broken.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-567421%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-567421%22%20slang%3D%22en-US%22%3E%3CDIV%3EHi!%26nbsp%3B%3CSPAN%3EI'm%20planning%20to%20implement%20DEA%20and%20I%20wonder%20if%20I%20will%20be%20able%20to%20use%20my%20Amazon%20Relational%20Database%20Service%20SQL%20Server%20Databases%20as%20target%20where%20I%20can%20run%20the%20load%20against.%20I%20saw%20that%20on%20this%20release%20of%20DEA%20you%20added%20SQL%20authentication%20feature%2C%20but%20not%20sure%20if%20Amazon%20Relational%20Database%20Service%20could%20be%20used%20as%20target%20server.%3CBR%20%2F%3EThanks!!%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686327%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686327%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help.%20I%20have%20installed%20DEA%202.6%20and%20the%20reporter.exe%20is%20missing.%20I%20use%20RML%20Utilities%20a%20lot%20so%20know%20how%20useful%20this%20tool%20could%20be.%20Any%20suggestions%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-368689%22%20slang%3D%22en-US%22%3ERelease%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2006%2C%202018%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CI%3E%20Authored%20by%20rajsell%40microsoft.com%20%3C%2FI%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1704673539%22%3EOverview%3C%2FH2%3E%0A%3CP%3EThe%20Database%20Experimentation%20Assistant%20(DEA)%20is%20a%20new%20A%2FB%20testing%20solution%20for%20SQL%20Server%20upgrades.%20The%20utility%20will%20assist%20in%20evaluating%20a%20targeted%20version%20of%20SQL%20for%20a%20given%20workload.%20Customers%20who%20are%20upgrading%20from%20previous%20SQL%20Server%20versions%20(SQL%20Server%202005%20and%20above)%20to%20any%20newer%20version%20of%20the%20SQL%20Server%20will%20be%20able%20to%20use%20the%20analysis%20metrics%20provided%2C%20such%20as%20queries%20that%20have%20compatibility%20errors%2C%20degraded%20queries%2C%20query%20plans%2C%20and%20other%20workload%20comparison%20data%2C%20to%20help%20them%20build%20confidence%20and%20better%20ensure%20a%20successful%20upgrade%20experience.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%20id%3D%22toc-hId--847483422%22%3EWhat's%20new%20in%20v2.6%3F%3C%2FH2%3E%0A%3CP%3EThe%20v2.6%20release%20of%20DEA%20has%20the%20following%20improvements%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ECapture%20and%20replay%20of%20production%20database(s)%20workloads%20through%20automated%20set%20up.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ESupport%20for%20server%20side%20traces%20and%20%3CSTRONG%3E%20XEvents%20%3C%2FSTRONG%3E%20.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EPerform%20%3CSTRONG%3E%20statistical%20analysis%20on%20traces%20and%2For%20XEvents%20%3C%2FSTRONG%3E%20collected%20using%20both%20old%20and%20new%20instances.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EVisualize%20data%20through%20analysis%20report%20via%20rich%20user%20experience.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EUse%20%3CSTRONG%3E%20SQL%20Authentication%20%3C%2FSTRONG%3E%20to%20both%20capture%20and%20replay.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EAn%20Inbuilt%20replay%20tool%20in%20addition%20to%20already%20supported%20SQL%20Server%20Distributed%20Replay%20for%20simple%20workloads.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ERemoves%20the%20dependencies%20of%20R%20and%20R-Interop.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ECapture%20and%20replay%20workloads%20to%20%3CSTRONG%3E%20Azure%20SQL%20Database%20%3C%2FSTRONG%3E%20%2C%20%3CSTRONG%3E%20Azure%20SQL%20Managed%20Instance%20%3C%2FSTRONG%3E%20%2C%20and%20%3CSTRONG%3E%20SQL%20Server%20on%20Linux%20%3C%2FSTRONG%3E%20.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EReporting%20enhancements%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ENew%20error%20categorization%20chart%20to%20easily%20find%20upgrade%20%2F%20migration%20blockers.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%3CBR%20%2F%3E%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ENew%20error%20pie%20chart%20grouped%20by%20error%20id%20to%20easily%20identify%20the%20root%20cause%20of%20the%20errors.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EBug%20fixes%20and%20other%20performance%20improvements.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%20id%3D%22toc-hId-895326913%22%3ETutorials%3C%2FH2%3E%0A%3CP%3EThe%20following%20postings%20provide%20step-by-step%20guidance%20for%20leveraging%20DEA%20to%20perform%20a%20workload%20comparison%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-overview%3Fview%3Dsql-server-2017%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOverview%20of%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-get-started%3Fview%3Dsql-server-2017%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGet%20started%20with%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-capture-trace%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECapture%20a%20trace%20in%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-configure-replay%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EConfigure%20replay%20in%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-replay-trace%3Fview%3Dsql-server-2017%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EReplay%20a%20trace%20in%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-create-report%3Fview%3Dsql-server-2017%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%20analysis%20reports%20with%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-view-report%3Fview%3Dsql-server-2017%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EView%20analysis%20reports%20with%20Database%20Experimentation%20Assistant%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fsql%2Fdea%2Fdatabase-experimentation-assistant-run-command-prompt%3Fview%3Dsql-server-2017%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERun%20Database%20Experimentation%20Assistant%20at%20a%20command%20prompt%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CH2%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%20id%3D%22toc-hId--1656830048%22%3EInstallation%3C%2FH2%3E%0A%3CP%3EYou%20can%20download%20and%20install%20DEA%20from%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D54090%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Microsoft%20Download%20Center%3C%2FA%3E.%20Run%20%E2%80%98DatabaseExperimentationAssistant.exe%E2%80%99%20to%20install%20the%20Database%20Experimentation%20Assistant.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%20id%3D%22toc-hId-85980287%22%3EExisting%20features%3C%2FH2%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fdatamigration%2F2017%2F03%2F24%2Fdea-2-0-release-overview-database-experimentation-assistant%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Database%20Experimentation%20Assistant%20(DEA)%20v2.0%20%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fdatamigration%2F2016%2F10%2F24%2Fdatabase-experimentation-assistant-v1-0-preview%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Database%20Experimentation%20Assistant%20(DEA)%20v1.0%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%20id%3D%22toc-hId-1828790622%22%3ESupported%20sources%20and%20target%20versions%3C%2FH2%3E%0A%3CP%3ESource%3A%20SQL%20Server%202005%20and%20above%20%3CBR%20%2F%3ETarget%3A%20SQL%20Server%202005%20and%20above%20%3CBR%20%2F%3EAnalysis%3A%20SQL%20Server%202008%20and%20above%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%20id%3D%22toc-hId--723366339%22%3EHow%20to%20contact%20the%20DEA%20team%3F%3C%2FH2%3E%0A%3CP%3ECustomers%20can%20submit%20feedback%20by%20using%20a%20simple%20interface%20within%20the%20DEA%20tool%20or%20by%20sending%20an%20email%20to%20%3CEM%3E%20deafeedback%40microsoft.com%3C%2FEM%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-368689%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20MSDN%20on%20Aug%2006%2C%202018%20Authored%20by%20rajsell%40microsoft.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-368689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDEA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-688447%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688447%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20tutorials%20and%20links%20in%20this%20post%20have%20been%20refreshed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-715257%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-715257%22%20slang%3D%22en-US%22%3E%3CP%3EFamily%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnable%20to%20use%20the%20GUI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20laptop%20resolution%20is%20configured%20for%201366%20by%20768.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20import%20Extended%20Events%20%5C%20Trace%20files%20the%20bottom%20portion%20of%20the%20screen%20is%20not%20visible%20and%20I%20am%20unable%20to%20access%20any%20buttons.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20resize%2C%20but%20the%20application%20is%20intentionally%20preventing%20window%20resize.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20reason%20why%20this%20application%20is%20intentionally%20%22eating%22%20up%20this%20event.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaniel%20Adeniji%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718100%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718100%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Daniel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20your%20Display%20Settings%2C%20please%20make%20sure%20that%20%3CSTRONG%3EScale%20and%20layout%20%3C%2FSTRONG%3Eis%20set%20no%20higher%20than%20100%25%20to%20ensure%20full%20visibility%20of%20the%20DEA%20interface.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20452px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120483i35A590DA51A4B2ED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Scale.png%22%20title%3D%22Scale.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718309%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718309%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BJim%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20pointer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20went%20back%20and%20looked%20at%20my%20MS%20Windows%2010.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20it%20does%20not%20have%20the%20%22Scale%20and%20Layout%22%20settings%20easily%20accessible.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20actually%20worked%20for%20me%20is%20to%20change%20my%20desktop%20view%20from%202%20monitors%2C%20the%20laptop%20and%20projected%20screen%20to%20a%20single%20display%2C%20the%20projected%20screen%20alone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInterestingly%20enough%2C%20while%20troubleshooting%20I%20installed%20the%20application%20on%20one%20of%20my%20servers%20that%20I%20was%20accessing%20via%20Remote%20Desktop.%26nbsp%3B%20It%20did%20not%20help%20at%20the%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%2C%20now%20that%20works%2C%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EBefore%20Change%3C%2FSTRONG%3E%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20905px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120493iF5004244F5CB3890%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22DatabaseExperimentationAssistant.Change.Before.20190624.0108PM.PNG%22%20title%3D%22DatabaseExperimentationAssistant.Change.Before.20190624.0108PM.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EChange%26nbsp%3B%20(%26nbsp%3BChose%20to%20Show%20Only%20On%202..%20)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20945px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120492iDD875237AC9753EE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22settings.display.20190624.0103PM.PNG%22%20title%3D%22settings.display.20190624.0103PM.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EPost%20Change%20Visual%3C%2FSTRONG%3E%3C%2FP%3E%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%2F120495i33334B4D39658117%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22DatabaseExperimentationAssistant.Change.After.20190624.0121PM.PNG%22%20title%3D%22DatabaseExperimentationAssistant.Change.After.20190624.0121PM.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaniel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718371%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718371%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20heads%20up%2C%20Daniel!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-718475%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718475%22%20slang%3D%22en-US%22%3E%3CP%3ECovered%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApplication%20Window%2C%20Does%20Not%20Fit%20on%20Screen%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Application%20Window%2C%20Does%20Not%20Fit%20on%20Screen%22%20href%3D%22https%3A%2F%2Flearningintheopen.org%2F2019%2F06%2F24%2Fapplication-window-does-not-fit-on-screen%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELink%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722100%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722100%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20come%20across%20the%20absence%20of%20reporter.exe%20in%20the%20DEA%202.6%20release%20too%2C%20as%20noted%20above%20by%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358685%22%20target%3D%22_blank%22%3E%40edd_tintin%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20error%20message%20is%3A%3C%2FP%3E%3CP%3E06%2F26%2F19%2015%3A18%3A28.951%20%5B0X000004AC%5D%20The%20file%20%5BC%3A%5CProgram%20Files%20(x86)%5CMicrosoft%20Corporation%5CReporter%5CBin%5CRelease%5CReporter.exe%5D%20does%20not%20exist%20with%20operating%20system%20error%200x00000003%20(The%20system%20cannot%20find%20the%20path%20specified)%3CBR%20%2F%3E06%2F26%2F19%2015%3A18%3A28.951%20%5B0X000004AC%5D%20Attempt%20to%20launch%20Reporter%20failed.%20Check%20the%20error%20log%20and%20your%20RML%20installation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thought%20Id%20be%20able%20to%20work%20around%20by%20downloading%20and%20installing%20RML%20but%20there%20doesn't%20seem%20to%20be%20a%20recent%20version...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722121%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722121%22%20slang%3D%22en-US%22%3E%3CP%3EJulian%20Dixon%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20access%20SQL%20Server%202016%20Feature%20Pack%20from%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D52676%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20want%20to%20download%20the%20following%20packages%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20SQL%20System%20CLR%20TYpes%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%20ENU%5Cx86%5CSQLSysClrTypes.msi%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2)%26nbsp%3BReport%20Viewer%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3BENU%5Cx86%5CReportViewer.msi%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20downloaded%2C%20please%20install%20both%20msi%20packages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%2C%20you%20should%20be%20good.%3C%2FP%3E%3CH2%20id%3D%22toc-hId-1704673539%22%20id%3D%22toc-hId-1019443996%22%20id%3D%22toc-hId-1019443996%22%20id%3D%22toc-hId-1019443996%22%20id%3D%22toc-hId-1019443996%22%20id%3D%22toc-hId-1019443996%22%20id%3D%22toc-hId-1019443996%22%3E%26nbsp%3B%3C%2FH2%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-722762%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722762%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F367077%22%20target%3D%22_blank%22%3E%40JulianDixon%3C%2FA%3E%2C%20see%20Daniel's%20comment%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724634%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724634%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360057%22%20target%3D%22_blank%22%3E%40DanielAdeniji%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20installed%20the%20packages%20as%20you%20suggest%20and%20the%20error%20messages%20I%20previously%20posted%20have%20cleared%20from%20the%20ReadTraceLog.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20think%20the%20lack%20of%20reporter.exe%20I%20was%20seeing%20in%20the%20ReadTrace.log%20might%20have%20been%20a%20red%20herring.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20previously%20(and%20am%20still)%20getting%20an%20error%20onscreen%20in%20DEA%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22An%20error%20occurred%20while%20creating%20Analysis%20Database.%20DacPac%20publishing%20failed.%22%3C%2FP%3E%3CP%3EThis%20occurs%20repeatably%20at%20the%20stage%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E36%25%20complete%2C%20Creating%20report%20database%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDespite%20this%20error%20message%20I%20can%20see%20the%20A%20%26amp%3B%20B%20databases%20have%20been%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20see%20in%20the%20ReadTrace.Log%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22*%20ReadTrace%20encountered%20one%20or%20more%20WARNINGS.%20A%20warning%20condition%20typically%20*%3CBR%20%2F%3E*%20continues%20processing%20with%20reduced%20functionality%2C%20but%20the%20ReadTrace%20output%20*%3CBR%20%2F%3E*%20may%20be%20adversely%20affected.%20Review%20the%20log%20file%20for%20details.%20*%3CBR%20%2F%3E*******************************************************************************%3CBR%20%2F%3E06%2F27%2F19%2009%3A57%3A39.489%20%5B0X000003D4%5D%20*****%20ReadTrace%20exit%20code%3A%200%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20warnings%20in%20the%20ReadTrace.Log%20are%3A%3C%2FP%3E%3CP%3E%2206%2F27%2F19%2009%3A57%3A35.596%20%5B0X000003D4%5D%20WARNING%3A%20The%20following%20trace%20events%20were%20not%20captured%3A%20%5BAudit%3ALogin%2C%20Audit%3ALogout%5D.%20Review%20the%20help%20file%20to%20ensure%20that%20you%20have%20collected%20the%20appropriate%20set%20of%20events%20and%20columns%20for%20your%20intended%20analysis.%22%3C%2FP%3E%3CP%3Eand%3C%2FP%3E%3CP%3E%2206%2F27%2F19%2009%3A57%3A36.290%20%5B0X000003D4%5D%20WARNING%3A%20One%20or%20more%20warning%20conditions%20exist%20that%20may%20affect%20the%20quality%20of%20the%20analysis%20data.%20See%20BFunctionTest636972226440609604.ReadTrace.tblWarnings%20table%20and%20the%20ReadTrace%20log%20for%20complete%20details.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20BFunctionTest636972226440609604.ReadTrace.tblWarnings%20table%20contains%20a%20single%20row%20with%20the%20warning%20message%20value%20of%20%22One%20of%20more%20warning%20conditions%20exist%20that%20may%20affect%20the%20quality%20of%20the%20analysis%20data.%20Review%20tblWarnings%20and%20the%20ReadTrace%20log%20for%20details.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20further%20assistance%20happily%20received!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724756%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724756%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20DEA%20seemed%20to%20be%20struggling%20to%20deploy%20the%20DacPac%20to%20my%20SQL%20Server%20(SQL%20Server%202017)%20I%20installed%20an%20instance%20of%20SQL%20Server%202016%20on%20the%20same%20server%2C%20pointed%20DEA%20at%20that%20and%20to%20my%20delight%20I%20have%20no%20more%20errors%20and%20can%20see%20the%20reports.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20reason%20you%20can%20think%20of%20to%20explain%20why%20DEA%20Analysis%20seems%20to%20work%20in%20my%20environment%20with%20SQL%20Server%202016%20but%20not%20SQL%20Server%202017%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-725068%22%20slang%3D%22en-US%22%3ERe%3A%20Release%3A%20Database%20Experimentation%20Assistant%20(DEA)%20v2.6%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725068%22%20slang%3D%22en-US%22%3E%3CP%3EJulian%20Dixon%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20you%20made%20such%20great%20progresses%20with%20so%20much%20fight%20in%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20quite%20sure%20why%20SQL%20Server%202017%20will%20not%20work%2C%20yet%202016%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20do%20the%20following%20%3A-%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20There%20are%20a%20few%20major%20steps%20in%20DEA%2C%20which%20specific%20one%20are%20you%20failing%20on%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20Can%20you%20please%20review%20the%20SQL%20Server%20Error%20Log%20on%20the%20SQL%20Server%202017%20machine%3B%20especially%20along%20the%20timeline%20when%20the%20errors%20was%20encountered%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20The%20other%20test%20is%20to%20re-run%20the%20process%20against%20SQL%20Server%202017%20while%20engaging%20extended%20events%20or%20SQL%20Server%20Profiler%20and%20been%20sure%20to%20include%20error%20capture%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20have%20made%20a%20lot%20of%20progress%20and%20done%20an%20exemplary%20job%20truly%20observing%20the%20steps%20and%20results%20and%20documenting%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgain%2C%20thanks%20for%20greatly%20expanding%20the%20knowledge%20base.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaniel%20Adeniji%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

First published on MSDN on Aug 06, 2018

Authored by rajsell@microsoft.com

 

Overview

The Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. The utility will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any newer version of the SQL Server will be able to use the analysis metrics provided, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data, to help them build confidence and better ensure a successful upgrade experience.

 

What's new in v2.6?

The v2.6 release of DEA has the following improvements:

    • Capture and replay of production database(s) workloads through automated set up.
    • Support for server side traces and XEvents .
    • Perform statistical analysis on traces and/or XEvents collected using both old and new instances.
    • Visualize data through analysis report via rich user experience.
    • Use SQL Authentication to both capture and replay.
    • An Inbuilt replay tool in addition to already supported SQL Server Distributed Replay for simple workloads.
    • Removes the dependencies of R and R-Interop.
    • Capture and replay workloads to Azure SQL Database , Azure SQL Managed Instance , and SQL Server on Linux .

 

    • Reporting enhancements:

        • New error categorization chart to easily find upgrade / migration blockers.

        • New error pie chart grouped by error id to easily identify the root cause of the errors.
    • Bug fixes and other performance improvements.

 

Tutorials

The following postings provide step-by-step guidance for leveraging DEA to perform a workload comparison:

Installation

You can download and install DEA from the Microsoft Download Center. Run ‘DatabaseExperimentationAssistant.exe’ to install the Database Experimentation Assistant.

 

Existing features

 

Supported sources and target versions

Source: SQL Server 2005 and above
Target: SQL Server 2005 and above
Analysis: SQL Server 2008 and above

 

How to contact the DEA team?

Customers can submit feedback by using a simple interface within the DEA tool or by sending an email to deafeedback@microsoft.com.

15 Comments
Occasional Visitor

All the tutorial links are broken.

Occasional Visitor
Hi! I'm planning to implement DEA and I wonder if I will be able to use my Amazon Relational Database Service SQL Server Databases as target where I can run the load against. I saw that on this release of DEA you added SQL authentication feature, but not sure if Amazon Relational Database Service could be used as target server.
Thanks!!
Visitor

Hi,

 

I hope someone can help. I have installed DEA 2.6 and the reporter.exe is missing. I use RML Utilities a lot so know how useful this tool could be. Any suggestions? 

Microsoft

The tutorials and links in this post have been refreshed.

Regular Visitor

Family :-

 

Unable to use the GUI.

 

My laptop resolution is configured for 1366 by 768.

 

When I try to import Extended Events \ Trace files the bottom portion of the screen is not visible and I am unable to access any buttons.

 

I tried to resize, but the application is intentionally preventing window resize.

 

Is there any reason why this application is intentionally "eating" up this event.

 

Please help!

 

Daniel Adeniji

 

Microsoft

Hi Daniel.

 

In your Display Settings, please make sure that Scale and layout is set no higher than 100% to ensure full visibility of the DEA interface.

 

Scale.png

Regular Visitor

 Jim :-

 

Thanks for the pointer.

 

I went back and looked at my MS Windows 10.  

 

Unfortunately, it does not have the "Scale and Layout" settings easily accessible.

What actually worked for me is to change my desktop view from 2 monitors, the laptop and projected screen to a single display, the projected screen alone.

 

Interestingly enough, while troubleshooting I installed the application on one of my servers that I was accessing via Remote Desktop.  It did not help at the time.

 

And, now that works, as well.

 

Before Change :-

 

DatabaseExperimentationAssistant.Change.Before.20190624.0108PM.PNG

 

Change  ( Chose to Show Only On 2.. )

 

settings.display.20190624.0103PM.PNG

 

Post Change Visual

DatabaseExperimentationAssistant.Change.After.20190624.0121PM.PNG

 

Daniel

 

 

Microsoft

Thanks for the heads up, Daniel!

Regular Visitor

Covered here.

 

Application Window, Does Not Fit on Screen

Link

 

 

Frequent Visitor

I've come across the absence of reporter.exe in the DEA 2.6 release too, as noted above by @edd_tintin.

 

My error message is:

06/26/19 15:18:28.951 [0X000004AC] The file [C:\Program Files (x86)\Microsoft Corporation\Reporter\Bin\Release\Reporter.exe] does not exist with operating system error 0x00000003 (The system cannot find the path specified)
06/26/19 15:18:28.951 [0X000004AC] Attempt to launch Reporter failed. Check the error log and your RML installation.

 

I thought Id be able to work around by downloading and installing RML but there doesn't seem to be a recent version...

 

Any thoughts?

 

 

Regular Visitor

Julian Dixon :-

 

Please access SQL Server 2016 Feature Pack from here

 

You want to download the following packages :-

 

1) SQL System CLR TYpes

    ENU\x86\SQLSysClrTypes.msi

2) Report Viewer
    ENU\x86\ReportViewer.msi

 

Once downloaded, please install both msi packages.

 

And, you should be good.

 

Microsoft

@JulianDixon, see Daniel's comment above.

Frequent Visitor

Thanks @DanielAdeniji,

 

I've installed the packages as you suggest and the error messages I previously posted have cleared from the ReadTraceLog.

 

However, I think the lack of reporter.exe I was seeing in the ReadTrace.log might have been a red herring.

 

I was previously (and am still) getting an error onscreen in DEA:

 

"An error occurred while creating Analysis Database. DacPac publishing failed."

This occurs repeatably at the stage:

36% complete, Creating report database

 

Despite this error message I can see the A & B databases have been created.

 

I also see in the ReadTrace.Log:

 

"* ReadTrace encountered one or more WARNINGS. A warning condition typically *
* continues processing with reduced functionality, but the ReadTrace output *
* may be adversely affected. Review the log file for details. *
*******************************************************************************
06/27/19 09:57:39.489 [0X000003D4] ***** ReadTrace exit code: 0"

 

The only warnings in the ReadTrace.Log are:

"06/27/19 09:57:35.596 [0X000003D4] WARNING: The following trace events were not captured: [Audit:Login, Audit:Logout]. Review the help file to ensure that you have collected the appropriate set of events and columns for your intended analysis."

and

"06/27/19 09:57:36.290 [0X000003D4] WARNING: One or more warning conditions exist that may affect the quality of the analysis data. See BFunctionTest636972226440609604.ReadTrace.tblWarnings table and the ReadTrace log for complete details."

 

The BFunctionTest636972226440609604.ReadTrace.tblWarnings table contains a single row with the warning message value of "One of more warning conditions exist that may affect the quality of the analysis data. Review tblWarnings and the ReadTrace log for details."

 

Any further assistance happily received!

 

 

Frequent Visitor

 

As DEA seemed to be struggling to deploy the DacPac to my SQL Server (SQL Server 2017) I installed an instance of SQL Server 2016 on the same server, pointed DEA at that and to my delight I have no more errors and can see the reports.

 

Is there any reason you can think of to explain why DEA Analysis seems to work in my environment with SQL Server 2016 but not SQL Server 2017?

Regular Visitor

Julian Dixon :-

 

Glad you made such great progresses with so much fight in you.

 

I am not quite sure why SQL Server 2017 will not work, yet 2016 works.

 

Please do the following :-  

 

1) There are a few major steps in DEA, which specific one are you failing on 

 

2) Can you please review the SQL Server Error Log on the SQL Server 2017 machine; especially along the timeline when the errors was encountered

 

3) The other test is to re-run the process against SQL Server 2017 while engaging extended events or SQL Server Profiler and been sure to include error capture

 

You have made a lot of progress and done an exemplary job truly observing the steps and results and documenting them.

 

Again, thanks for greatly expanding the knowledge base.  

 

Daniel Adeniji