How to use Database Experimentation Assistant tool

Capabilities The tool has three main features: Capture Trace: Ability to automatically capture a production workload trace with only a few inputs. Replay Trace: Ability to replay a trace on current and new/proposed instances of SQL. Workload Analysis Reports: Ability to generate new reports which provide insight into how workload performance changes across versions of…

0

Database Experimentation Assistant – Capture Trace

Capture trace allows you to easily produce a trace file (.trc) containing a log of what events occurred on the specified server within a given period of time. This action needs to be performed once per server. Note: Before starting your trace capture, please make sure to backup all your target databases. Query caching in…

1

Database Experimentation Assistant – Upcoming features

Here are the features that will be available for upcoming release. Stay tuned.. Automated script for capture and replay workload traces via command line options Support for the ability to capture multiple servers. Support validation checks to address ring fencing scenarios.

0

Database Experimentation Assistant – New Analysis Report

STEP ONE: CLICK “NEW ANALYSIS REPORT” Open the tool and click the hamburger icon on the left side of screen. This will open the left side bar menu. Next, click “Analysis Reports” next to the checklist icon . This will open the Analysis Reports section. From the Analysis Reports screen, click “New analysis report”. From…

0

Database Experimentation Assistant – FAQ

Distributed Replay Recommendations 1. How much additional hard drive space is required on Dreplay Controller machine? Given the production trace, additional 78% hard drive space is needed to create IRF files on the controller machine 2. What is the ideal trace rollover size used for capturing production and/or performance traces? 200 MB or 512 MB…

0

Database Experimentation Assistant – View Existing Analysis Reports

STEP ONE: CLICK ON ANALYSIS REPORTS Provide a SQL Server name which has the analysis database and click on “Connect” Note: if you are missing any dependencies, this screen will prompt you with links to install them. Please install the requirements and click Try Again STEP TWO: SELECT EXISTING ANALYSIS REPORTS Double click on a…

1