FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

Gäller för: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Standard

Symptoms


Assume that you have a Microsoft SQL Server 2012 instance that uses a supplementary character collation on the server level. When you first start the Database Engine Tuning Advisor (DTA), you receive the following error message when the DTA connects to a SQL Server instance:
Could not find stored procedure ' msdb..sp_DTA_help_session '. (Microsoft SQL Server、error: 2812)

Note
In a Japanese environment, the error message is as follows:
ストアド プロシージャ 'msdb..sp_DTA_help_session' が見つかりませんでした。 (Microsoft SQL Server、エラー: 2812)

Cause


This issue occurs because some large object (LOB) data types are used to create necessary data structures in some tables or stored procedures that are used by the DTA when it is first started. However, the use of LOB data types is precluded in the supplementary character collation.

Resolution


Service pack information for SQL Server 2012

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. We will update this article when there is an update.

More Information


For more information about supplementary character collation, go to the following MSDN website: