Tuesday, March 27, 2012

Error when running Tuning advisor

When I try to launch the tuning advisor, I get this error - Any help will be much appriciated.

===================================

Failed to connect to an IPC Port: The system cannot find the file specified.
(mscorlib)


Program Location:


Server stack trace:
at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel level, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.SqlServer.Management.UI.VSIntegration.ISessionController.CreateSessionFromQuery(SqlConnectionInfo connectionInfo, String sqlQuery, String batchSeparator)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnDatabaseTuningAdvisor(Object sender, EventArgs a)

What is the service pack level on SQL Server?

Any recent changes to the server and client machine you are using, such as automatic updates?

|||Hi,

I had got the same error when I tried to tune my query.

However after I click "OK" button of the Error message, in few seconds the "Tuning Adviser" window opens but it is not connected to the session of the query editor (in which the query was executed).

Now without closing this tuning adviser window, if I again click on Analyser button, the analyser opens fine and the query is also tunned properly.

Let me know if this works for you too.

Regards,

Shweta

No comments:

Post a Comment