You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/dea/database-experimentation-assistant-capture-trace.md
+5-6Lines changed: 5 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -35,20 +35,19 @@ Query caching in SQL Server might affect evaluation results. We recommend that y
35
35
-**Duration**: Select the length of time (in minutes) that you want the trace capture to run.
36
36
-**Capture Location**: Select the destination path for the trace file.
37
37
38
+
> [!NOTE]
39
+
> The file path to the trace file must be on the computer that's running SQL Server. If the SQL Server service isn't set for a specific account, the service might need write permissions to the specified folder for the trace file to be written.
38
40
39
-
> [!NOTE]
40
-
> The file path to the trace file must be on the computer that's running SQL Server. If the SQL Server service isn't set for a specific account, the service might need write permissions to the specified folder for the trace file to be written.
41
+
3. Verify that you have taken a backup by selecting the **Yes, I have manually taken the backup…** check box.
41
42
42
-
Also be sure to select the **Yes, I have manually taken the backup…** check box.
43
-
44
-
3. Under **Capture details**, enter or select the following information:
43
+
4. Under **Capture details**, enter or select the following information:
45
44
46
45
-**Server Type**: Specify the type of the SQL server (**SqlServer**, **AzureSqlDb**, **AzureSqlManagedInstance**).
47
46
-**Server name**: Specify the server name or IP address of your SQL Server.
48
47
-**Authentication Type**: For the authentication type, select **Windows**.
49
48
-**Database name**: Enter a name for a database on which to start a database trace. If you don't specify a database, trace is captured on all the databases on the server.
50
49
51
-
Also be sure to select or deselect the **Encrypt connection** and **Trust server certificate** check boxes as appropriate for your scenario.
50
+
5. Select or deselect the **Encrypt connection** and **Trust server certificate** check boxes as appropriate for your scenario.
0 commit comments