The SQL Access Advisor helps define appropriate access structures such as indexes and materialized views to optimize SQL queries. The advisor takes a SQL workload as an input and recommends which indexes, materialized views, or logs to create, drop, or retain for faster performance. You can select your workload from different sources including current and recent SQL activity, a SQL repository, or a user-defined workload such as from a development environment.
The SQL Access Advisor takes a SQL workload as input. You can select your workload from different sources, including current and recent SQL activity, a SQL repository, or a user-defined workload such as from a development environment. The advisor then makes recommendation to improve the performance of the workload as a whole.
The Workload Source page appears. Select your workload source as Current and Recent SQL Activity to analyze the most recent and ongoing activity. You can also select from other sources. The best workload is one that fully represents the statements that access all the underlying tables. Click Next.
≪ワークロード・ソース|Workload Source|emdw≫・ページが表示されます。ワークロード・ソースを≪現在と最近のSQLアクティビティ|Current and Recent SQL Activity|emdw≫として選択し、最新および継続中のアクティビティを分析します。その他のソースから選択することもできます。基礎となる表すべてにアクセスする文を完全に表すワークロードが最適です。≪次へ|Next|emdw≫をクリックします。
Alte rezultate
Returns the number of rows that were changed by the most recent SQL statement
直近のSQLステートメントにより変更されたレコード数を返す
Number of days information is retained in the SQL activity summary table.
SQLアクティビティ・サマリー・テーブルに情報が保存される日数。
Combo box containing all recent SQL commands.
すべての最新の SQL コマンドを含むコンボボックス。
Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement.
直近の SQL 文で変更 (あるいは挿入、削除) された行の数を返します。
The SQL Activity Metrics will be enabled if you have
次の場合には、SQLアクティビティ・メトリックは有効化されます。
Privileges Required to Monitor SQL Activity Metrics
SQLアクティビティ・メトリックの監視に必要な権限
The SQL Activity Metrics are listed in the table below
SQLアクティビティ・メトリックは、次の表のとおりです。
For additional details, check out the recent SQL Server blog post.
詳細については、最新のSQL Server Blog の記事 (英語) を参照してください。
The data is not collected if you have reduced the collection level to minimum. The database must be configured for SQL activity metrics.
You can use SQL statements from the cache as the workload source. However, only current and recent SQL statements are stored in the SQL cache, so this workload source may not be representative of the entire workload on your database.
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.