Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Nóta
This tool will be retired on December 15, 2024. We will stop supporting this tool for any issues that arise, and will not issue any bug fixes or further updates.
Database Experimentation Assistant (DEA) is an experimentation solution for SQL Server upgrades. DEA can help you evaluate a targeted version of SQL Server for a specific workload. Customers upgrading from earlier versions of SQL Server (starting with 2005) to more recent versions of SQL Server can use the analysis metrics that the tool provides.
DEA analysis metrics include:
Comparison data can lead to higher confidence and help ensure a successful upgrade experience.
To install DEA, download the latest version of the tool. Then, run the DatabaseExperimentationAssistant.exe file.
The following diagram shows the solution architecture for a workload comparison. The workload comparison uses DEA and Distributed Replay during an upgrade from SQL Server 2008 to SQL Server 2016.
Following are some prerequisites for running DEA:
In the prerequisite environment architecture, we recommend that you install DEA on the same machine as the Distributed Replay controller. This practice avoids cross-computer calls and simplifies configuration.
DEA connects to database servers using Windows authentication. Be sure that the user running DEA can connect to database servers (source, target, and analysis) using Windows authentication.
Capture configuration requirements
Capturing a trace requires that the user running DEA:
In addition, the service account running the source database server requires write access to the trace folder path.
For more information, see Frequently asked questions about trace capture.
Replay configuration requirements
Replaying a trace requires that the user running DEA:
In addition, replaying a trace requires that:
For more information, see Frequently asked questions about trace replay.
Analysis configuration requirements
Performing the analysis requires that the user running DEA:
For more information, see Frequently asked questions about analysis reports.
DEA has an internet-enabled feature that can send telemetry information to Microsoft for use in enhancing the product experience. The information that's collected is also saved on your computer for local audit, so you can always see what's collected. All DEA log files are saved in the %temp%\DEA folder.
Telemetry data can be collected on four types of events:
Collecting and sending telemetry data is optional. To specify which events are collected and whether collected events are sent to Microsoft, use the following steps:
DEA is governed by the Microsoft Privacy Statement.
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuOiliúint
Modúl
Use the SQL Server Query Tuning Assistant - Training
Learn how the Query Tuning Assistant (QTA) works alongside the Query Store to compare query performance statistics and find queries that are regressing due to changing compatibility levels.
Deimhniú
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Doiciméadúchán
SQL Server migration documentation - SQL Server
Choose the SQL Server migration path you're interested in.
Overview of Data Migration Assistant (SQL Server) - SQL Server
Learn how to use Data Migration Assistant to migrate SQL Server databases to other instances of SQL Server, Azure SQL Database, or Azure SQL Managed Instance.
Upgrade SQL Server using the Data Migration Assistant - SQL Server
Learn how to use Data Migration Assistant to upgrade an on-premises SQL Server to a later version of SQL Server or to SQL Server on Azure VMs