October 17, 2016 at 5:30 am
SQL Server 2014 Enterprise (Initially installed SSMS only). I am getting this exception:
===================================
Cannot initialize tuning. (.Net SqlClient Data Provider)
===================================
Failed to load Msxmlsql.dll. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.5532&EvtSrc=MSSQLServer&EvtID=6610&LinkId=20476
------------------------------
Server Name:xxxxxxxxxxxxxx
Error Number: 6610
Severity: 16
State: 1
Procedure: sp_xml_preparedocument
Line Number: 1
------------------------------
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.DTA.Client.NonQuery.BeginQuery(ServerConnection connection)
at Microsoft.SqlServer.Management.DTA.Client.TuningConnection.RunSyncQuery(IQuery query)
at Microsoft.SqlServer.Management.DTA.Client.TuningConnection.ExecuteNonQuery(SqlCommand command)
at Microsoft.SqlServer.Management.DTA.Client.TuningSession.StoreSessionXml(Boolean isNvarcharColumns)
at Microsoft.SqlServer.Management.DTA.Client.TuningSession.Start(Boolean withProgressEvents)
at Microsoft.SqlServer.Management.DTA.Shell.SessionForm.ProgressThread()
I tried copying Msxmlsql.dll file from another instance but didn't work.
Any ideas?
October 17, 2016 at 5:57 am
I have to say, that tool is a potential disaster area, and you really shouldn't, if you run it, implement its recommendations without some serious further investigation, as if you just whack in everything it suggests you will almost certainly kill whatever system you're trying to tune stone dead.
A better starting point might be sp_blitzIndex or
https://sqlperformance.com/2013/06/t-sql-queries/missing-index
Apologies if you're already aware of all this
Edit typo
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
October 17, 2016 at 6:07 am
There is, apparently a workaround, but it does require a server restart, and I have to say it's not something I've tested because, frankly, the DTA is not something I'd run.
If you do, I'd run sp_blitzIndex afterwards as the DTA can leave a bit of a mess behind itself
https://www.brentozar.com/blitz/hypothetical-indexes-index-tuning-wizard/
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
October 17, 2016 at 6:34 am
Thank you, I will check those links out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply