We create for demonstration purposes in the AdventureWorks2012 database a table named

The Database Engine Tuning Advisor (DTA short, or Database Engine nigella bread bin Tuning Advisor ...) is known to be a quite handy tool to verify the effectiveness of the database structures with queries and possibly improve. Include such queries, however, "typical European" special characters like ä, ö, ü, ß, á ô or the DTA itself seems to need a piece of advice, for he knows not how a workload file can be opened with such queries.
We create for demonstration purposes in the AdventureWorks2012 database a table named "_About" that contains only an index column and want to count the number of entries with a simple SQL statement:
The query in SSMS to execute works as expected, flawlessly. We will save you under SpecialCharTest.sql and start the DTA. In the DTA window we configure the session with the name SpecialCharTest and the connection to the AdventureWorks2012 DB. As a workload file, we select the newly saved SQL file.
To German: "Error: The specified input file can not be opened". Unfortunately, this is not very meaningful, after a few attempts but it was clear that the umlaut is the problem. The underscore causes no error message, just as, for example, the dollar nigella bread bin sign $. Google is at this point also, merely an indication of possible problems with the code page can be found. Saving SQL Files with different code pages (1252/ANSI, 65001/UTF-8 etc.) but did not solve the problem as well.
A solution of the problem is currently does not seem to exist. In the meantime, there are probably only two solutions: rewrite the object names accordingly, ie UE instead of T, a instead of á, etc. Amazingly, the DTA has no problems with the query when it is opened directly from the query out in SQL Server Management Studio. If SSMS or the query is not already open, you can quickly open the file from the DTA out on View à Preview workload nigella bread bin file. After the connection data is set correctly, right click on the query is executed.
When the DTA opens again, a new session has been created with the correct connection data and the query as a workload (the session name should be adjusted). Run by clicking nigella bread bin Start Analysis, and lo and behold:
This entry was posted in SQL Server and tagged query, Database Engine Tuning Advisor, DTA, special characters, umlauts, workload files. Leave a Reply Click here to cancel reply.
You may use these HTML tags and attributes: nigella bread bin <a href="" title=""> <abbr title=""> <acronym nigella bread bin title=""> <b> <blockquote cite=""> <cite> <code> < del datetime = ""> nigella bread bin <em> <i> <q cite=""> <strike> <strong>
. German Categories NET General Analysis Services work results Corporate Information Design Excel Integration Services Master Data Services MDX Mobile BI Planning & Consolidation Products Programming Reporting Services SAP SAP BI SAP BO SAP HANA SharePoint SQL Server Windows Azure Windows Server Search Social Media Corporate Information Design - XING orangeBI PTSGroup on Facebook PTSGroup in XING Recent Posts Special characters in DTA workload Files - "The specified input file can not be opened" nigella bread bin Dynamic nigella bread bin data sources in reports with Shared Data Sets? Links, Linked Reports, Subreports determining the Measurenutzung in SQL Server Analysis Services O Holy Night - gave-making Christmas? Archives January 2014 December 2013 November 2013 September 2013 August nigella bread bin 2013 June 2013 May 2013 April 2013 March 2013 February 2013 January 2013 December 2012 November 2012 October 2012 September 2012 August 2012 July 2012 June 2012 May 2012 April 2012 March 2012 February 2012 January 2012 December 2011 November 2011 October 2011 September 2011 August 2011 July 2011 June 2011 May 2011 April 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October nigella bread bin 2010 September 2010 Meta Log in Entries (RSS) Comments RSS WordPress.org
Proudly powered by WordPress.