January 26, 2012 at 3:18 pm
Product: ProductVersion=10.50.1600.1 ProductLevel=RTM Edition=Enterprise Edition (64-bit) EngineEdition=3
OS: Win7 with all updates installed
Problem #1:
C:\Projects>dta -s session3_30062871 -A 0 -D MessagingGateway -e Utility.dbo.Tuning_Log_Tbl -F -fk ALL -fp FULL -if "C:\Projects\Optimization\30062871.sql" -N OFF -of "C:\Projects\Optimization\30062871.recomm.sql" -rl ALL -S .\SQL2K8R2ENT -U sa -P MyS3cr3t -B 20 -ix "C:\Projects\Optimization\30062871.xml"
Microsoft (R) SQL Server Microsoft SQL Server Database Engine Tuning Advisor command line utility
Version 10.50.1600.1 ((KJ_RTM).100402-1540 )
Copyright (c) Microsoft Corporation. All rights reserved.
Session XML section is invalid. Schema validation error: The element 'TuningOptions' in namespace 'http://schemas.microsoft.com/sqlserver/2004/07/dta'
has invalid child element 'IgnoreConstantsInWorkload' in namespace 'http://schemas.microsoft.com/sqlserver/2004/07/dta'. List of possible elements ex
pected: 'ReportSet, TuningLogTable, NumberOfEvents, TuningTimeInMin, StorageBoundInMB, MaxKeyColumnsInIndex, MaxColumnsInIndex, MinPercentageImproveme
nt, TestServer, EvaluateConfiguration, FeatureSet, DropOnlyMode' in namespace 'http://schemas.microsoft.com/sqlserver/2004/07/dta'.
Note that http://schemas.microsoft.com/sqlserver/2004/07/dta/dtaschema.xsd definitely contains <xsd:element name="IgnoreConstantsInWorkload" minOccurs="0" maxOccurs="1"/> where one would expect it.
Contents of C:\Projects\Optimization\30062871.xml:
<?xml version="1.0" encoding="utf-16" ?>
<DTAXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/dta">
<DTAInput>
<Server>
<Name>.\SQL2K8R2ENT</Name>
<Database>
<Name>MessagingGateway</Name>
<Schema>
<Name>dbo</Name>
</Schema>
</Database>
</Server>
<Workload>
<File>C:\Projects\Optimization\30062871.sql</File>
</Workload>
<TuningOptions>
<IgnoreConstantsInWorkload/>
</TuningOptions>
</DTAInput>
</DTAXML>
Problem #2:
Per “Using an XML Input File for Tuning” (at ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/3f01d51f-84bb-40fd-9d2c-80b74512a16e.htm)
“The XML input file uses the published Database Engine Tuning Advisor XML schema, which can be found at the following location in your SQL Server 2008 installation directory:
C:\Program Files\Microsoft SQL Server\10\Tools\Binn\schemas\sqlserver\2004\07\dta\dtaschema.xsd”
No, it cannot, there is no such “schemas” subfolder under “Binn”, in fact the only XSDs under C:\Program Files\Microsoft SQL Server\ are 12 files “package.xsd”.
January 26, 2012 at 3:25 pm
P.S.: ... and "Send Feedback" button directs you to email to sqldocfb@microsoft.com, but when you do, the email is rejected: "The following organization rejected your message: mail.messaging.microsoft.com."
The most complicated way to effectively disable the button I ever saw...:-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply