We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
In tune mode, a database administrator already knows that a part of the database physical design should be fixed, but he wants Database Engine Tuning Advisor to recommend the best physical design structures for the rest of the configuration.
If you do not explicitly specify the initial database connection for a tuning session, Database Engine Tuning Advisor uses the default database that is defined for the login you specify on the server where tuning occurs.
Specifies that Database Engine Tuning Advisor should only offer recommendations for which the estimated improvement meets or exceeds the supplied value (in percents). If no value is specified recommendations will be provided regardless of the degree of improvement.
If you specify the same number of events that Database Engine Tuning Advisor should tune for each configuration, you can be sure that the two tuning sessions are equivalent and are thus comparable.
When you evaluate an existing session as described in the previous procedure, Database Engine Tuning Advisor also creates a new tuning session, but you cannot change the tuning options.
按照前面的过程来评估现有会话时,数据库引擎优化顾问也会创建新的优化会话,但您不能更改优化选项。
Like Database Engine Tuning Advisor, the dta utility analyzes a workload and recommends physical design structures to improve server performance for that workload.
Launches the graphical Database Engine Tuning Advisor user interface and passes all supplied command line arguments as the initial configuration settings.
启动数据库引擎优化顾问图形用户界面,并传递提供的所有命令行参数作为初始配置设置。
Specifies that Database Engine Tuning Advisor will evaluate usefulness of existing physical design structures and will follow up with recommendations to drop low-use structures. This option cannot be used with -fa and -fp options.
The maximum amount of time, in minutes, that Database Engine Tuning Advisor will spend tuning. In general, longer times produce higher quality 0 is specified as a value, the tuning time is unlimited. When a value is not specified, the tuning time is limited to 8 hours.
You can view the log during the tuning session to determine whether Database Engine Tuning Advisor can tune the events in your workload.
可以在优化会话过程中查看日志,以确定数据库引擎优化顾问是否能够优化工作负荷中的事件。
The name of a table or file where Database Engine Tuning Advisor writes log messages that occurred during tuning. The table name should be supplied in the form [database].[schema].[table]. That table will be created on the server against which tuning is conducted. The file name must have xml extension. If no table or file name is passed, the default table will be used.
数据库引擎优化顾问将优化过程中出现的日志消息写入到的表或文件的名称。应该以 [数据库].[架构].[表] 格式提供表名。将在进行优化的服务器上创建该表。文件名必须使用 xml 扩展名。如果未传递任何表名或文件名,将使用默认表。
When using a trace table as a workload, that table must exist on the same server where Database Engine Tuning Advisor is tuning.
使用跟踪表作为工作负荷时,该表必须位于数据库引擎优化顾问正在优化的那台服务器上。
When Database Engine Tuning Advisor creates recommendations, it automatically creates names for the objects that it recommends.
数据库引擎优化顾问创建建议时,会自动为所建议的对象创建名称。
Potentieel gevoelige of ongepaste informatie
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.