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/dma/dma-sku-recommend-sql-db.md
+5-4Lines changed: 5 additions & 4 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -47,10 +47,10 @@ The collected data includes limited information about the hardware configuration
47
47
48
48
2. Run the SKU Recommendations console application with the following arguments:
49
49
50
-
-**sqlConnectionStrings**: Required. Quote-enclosed formal connection string(s) for the target SQL instance(s).
51
-
-**perfQueryIntervalInSec**: Optional. Interval at which to query performance data, in seconds. (Default: 30)
52
-
-**staticQueryIntervalInSec**: Optional. Interval at which to query and persist static configuration data, in seconds. (Default: 60)
53
-
-**numberOfIterations**: Optional. Number of iterations of performance data collection to perform before persisting to file. For example, with default values, performance data will be persisted every 30 seconds * 20 iterations = 10 minutes. (Default: 20)
50
+
-**sqlConnectionStrings**: Required. Quote-enclosed formal connection string(s) for the target SQL instance(s).
51
+
-**perfQueryIntervalInSec**: Optional. Interval at which to query performance data, in seconds. (Default: 30)
52
+
-**staticQueryIntervalInSec**: Optional. Interval at which to query and persist static configuration data, in seconds. (Default: 60)
53
+
-**numberOfIterations**: Optional. Number of iterations of performance data collection to perform before persisting to file. For example, with default values, performance data will be persisted every 30 seconds * 20 iterations = 10 minutes. (Default: 20)
54
54
-**outputFolder**: Optional. Folder which performance data, reports, and logs will be written to/read from. (Default: current directory)
55
55
56
56
@@ -171,6 +171,7 @@ For SQL Server on Azure VM recommendations, the output will look as follows:
171
171
172
172
-**insertphoto**
173
173
174
+
The output of the SKU recommendations covers the following sections:
174
175
175
176
176
177
The final recommended tier and configuration values for that tier reflect the minimum SKU required for your queries to run in Azure with a success rate similar to your on-premises databases. For example, if the recommended minimum SKU is S4 for the standard tier, then choosing S3 or below will cause queries to time out or fail to execute.
0 commit comments