Skip to content

Commit e0d4dee

Browse files
committed
newcommit
1 parent 1ccb87b commit e0d4dee

1 file changed

Lines changed: 5 additions & 4 deletions

File tree

docs/dma/dma-sku-recommend-sql-db.md

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -47,10 +47,10 @@ The collected data includes limited information about the hardware configuration
4747

4848
2. Run the SKU Recommendations console application with the following arguments:
4949

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)
5454
-**outputFolder**: Optional. Folder which performance data, reports, and logs will be written to/read from. (Default: current directory)
5555

5656

@@ -171,6 +171,7 @@ For SQL Server on Azure VM recommendations, the output will look as follows:
171171
172172
-**insertphoto**
173173
174+
The output of the SKU recommendations covers the following sections:
174175
175176
176177
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

Comments
 (0)