Descrição do script de limpeza do banco de dados ajuste Advisor (DTA) para SQL Server 2005

IMPORTANTE: Este artigo foi traduzido por um sistema de tradução automática (também designado por Machine Translation ou MT), não tendo sido portanto traduzido ou revisto por pessoas. A Microsoft possui artigos traduzidos por aplicações (MT) e artigos traduzidos por tradutores profissionais, com o objetivo de oferecer em português a totalidade dos artigos existentes na base de dados de suporte. No entanto, a tradução automática não é sempre perfeita, podendo conter erros de vocabulário, sintaxe ou gramática. A Microsoft não é responsável por incoerências, erros ou prejuízos ocorridos em decorrência da utilização dos artigos MT por parte dos nossos clientes. A Microsoft realiza atualizações freqüentes ao software de tradução automática (MT). Obrigado.

Clique aqui para ver a versão em Inglês deste artigo: 899634
INTRODUÇÃO
Você pode ter problemas se você usar uma versão da Community Technology Preview (CTP) de pré-junho do cliente do Microsoft SQL Server 2005 Database ajuste Advisor (DTA) para ajustar o Microsoft SQL Server 2000 ou pré-junho versões CTP do SQL Server 2005. Essas versões do CTP de pré-junho do SQL Server 2005 incluem servidores SQL Server 2005 Beta 2 DTA.

Este artigo lista o script de limpeza DTA que você pode usar para evitar esses problemas.
Mais Informações
Para executar o script do Transact-SQL a seguir no servidor, você deve usar uma conta que é um membro da função de servidor fixa sysadmin . Esse script remove algumas tabelas e procedimentos armazenados do banco de dados msdb .

Aviso Se você executar esse script, qualquer DTA anterior ajuste sessões que estão no servidor será excluída.
/*	Purpose of the Script	This script cleans up objects created by DTA client on the target server 	(server being tuned). DTA creates support tables and stored procedures on the target server. 	The schema of the DTA tables and the DTA SP interfaces changed from Beta 2. 		When to use it	If a Beta 2 DTA client was used to tune/evaluate against the target server then	this script needs to be executed (against the target server) for later versions 	of DTA to function properly.		Impact	Previous session details are lost.*/gouse msdbgo-- Drop DTA msdb Tablesif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_indexcolumn') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_indexcolumnif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_querycolumn') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_querycolumnif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_querytable') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_querytableif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_tableview') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_tableviewif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_querydatabase') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_querydatabaseif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_queryindex') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_queryindexif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_column') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_columnif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_index') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_indexif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_table') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_tableif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_query') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_queryif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_partitionscheme') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_partitionschemeif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_partitionfunction') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_partitionfunctionif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_tuninglog') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_tuninglogif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_reports_database') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_reports_databaseif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_progress') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_progressif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_output')and (type = 'U')and (uid = user_id('dbo'))))	drop table dbo.DTA_outputif (exists (select * from msdb.dbo.sysobjects where (name = N'DTA_input') and (type = 'U') and (uid = user_id('dbo'))))	drop table dbo.DTA_input	-- Drop DTA msdb SP'sif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_check_permission' and type = 'P') 	drop procedure dbo.sp_DTA_check_permission if exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_add_session' and type = 'P') 	drop procedure dbo.sp_DTA_add_session if exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_delete_session' and type = 'P')	drop procedure dbo.sp_DTA_delete_session if exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_session_tuning_results' and type = 'P')	drop procedure dbo.sp_DTA_get_session_tuning_resultsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_set_interactivestatus' and type = 'P')	drop procedure dbo.sp_DTA_set_interactivestatusif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_help_session' and type = 'P')	drop procedure dbo.sp_DTA_help_sessionif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_update_session' and type = 'P')	drop procedure dbo.sp_DTA_update_sessionif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_tuninglog' and type = 'P')	drop procedure dbo.sp_DTA_get_tuninglogif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_index_usage_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_index_usage_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_index_usage_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_index_usage_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_database_access_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_database_access_helper_xmlif exists (select name from msdb.dbo.sysobjects where name = 'sp_DTA_database_access_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_database_access_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_table_access_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_table_access_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_table_access_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_table_access_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_column_access_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_column_access_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_column_access_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_column_access_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_costrange_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_query_costrange_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_costrange_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_query_costrange_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_cost_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_query_cost_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_cost_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_query_cost_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_event_weight_helper_xml' and type = 'P') 	drop procedure dbo.sp_DTA_event_weight_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_event_weight_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_event_weight_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_detail_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_query_detail_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_detail_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_query_detail_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_indexrelations_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_query_indexrelations_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_query_indexrelations_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_query_indexrelations_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_index_current_detail_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_index_current_detail_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_index_recommended_detail_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_index_recommended_detail_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_index_detail_current_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_index_detail_current_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_index_detail_recommended_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_index_detail_recommended_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_view_table_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_view_table_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_view_table_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_view_table_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_wkld_analysis_helper_xml' and type = 'P')	drop procedure dbo.sp_DTA_wkld_analysis_helper_xmlif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_wkld_analysis_helper_relational' and type = 'P')	drop procedure dbo.sp_DTA_wkld_analysis_helper_relationalif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_session_report' and type = 'P')	drop procedure dbo.sp_DTA_get_session_reportif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_set_tuninglogtablename' and type = 'P')	drop procedure dbo.sp_DTA_set_tuninglogtablenameif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_tuningoptions' and type = 'P')	drop procedure dbo.sp_DTA_get_tuningoptionsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_interactivestatus' and type = 'P')	drop procedure dbo.sp_DTA_get_interactivestatusif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_progressinformation' and type = 'P')	drop procedure dbo.sp_DTA_insert_progressinformationif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_set_progressinformation' and type = 'P')	drop procedure dbo.sp_DTA_set_progressinformationif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_set_outputinformation' and type = 'P')	drop procedure dbo.sp_DTA_set_outputinformationif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_database' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_databaseif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_partitionscheme' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_partitionschemeif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_partitionfunction' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_partitionfunctionif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_column' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_columnif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_tableview' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_tableviewif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_query' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_queryif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_index' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_indexif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_table' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_tableif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_queryindex' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_queryindexif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_indexcolumn' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_indexcolumnif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_querytable' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_querytableif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_querydatabase' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_querydatabaseif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_reports_querycolumn' and type = 'P')	drop procedure dbo.sp_DTA_insert_reports_querycolumnif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_insert_DTA_tuninglog' and type = 'P')	drop procedure dbo.sp_DTA_insert_DTA_tuninglogif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_databasetableids' and type = 'P')	drop procedure dbo.sp_DTA_get_databasetableidsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_pftableids' and type = 'P')	drop procedure dbo.sp_DTA_get_pftableidsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_pstableids' and type = 'P')	drop procedure dbo.sp_DTA_get_pstableidsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_tableids' and type = 'P')	drop procedure dbo.sp_DTA_get_tableidsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_columntableids' and type = 'P')	drop procedure dbo.sp_DTA_get_columntableidsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_get_indexableids' and type = 'P')	drop procedure dbo.sp_DTA_get_indexableidsif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_update_tuninglog_errorfrequency' and type = 'P')	drop procedure dbo.sp_DTA_update_tuninglog_errorfrequency	-- Drop unused SP's if they exist.		if exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_columnaccesshelper' and type = 'P')	drop procedure dbo.sp_DTA_columnaccesshelperif exists (select name from msdb.dbo.sysobjects where name = 'sp_DTA_databaseaccesshelper' and type = 'P')	drop procedure dbo.sp_DTA_databaseaccesshelperif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_indexusagehelper' and type = 'P')	drop procedure dbo.sp_DTA_indexusagehelperif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_queryCRhelper' and type = 'P')	drop procedure dbo.sp_DTA_queryCRhelperif exists (select name from msdb.dbo.sysobjects	where name = 'sp_DTA_tableaccesshelper' and type = 'P')	drop procedure dbo.sp_DTA_tableaccesshelper

Aviso: este artigo foi traduzido automaticamente

Eigenschappen

Artikel-id: 899634 - Laatst bijgewerkt: 11/20/2007 17:43:24 - Revisie: 3.3

Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbmt kbscript kbhowto kbinfo KB899634 KbMtpt
Feedback