Database Tunig Advisor | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Tunig Advisor

Situation 1: Open a trace file with profiler.
Find some query, copy.
Open Managment Studio. New Query, conect to server, paste query.
See execution plan. All ok.
Call Database Tuning Advisor, select database and run. All ok, suppose with new index to implementate. Situation 2: Call Database Tuning Advisor.
Select database, select trace file (same like before), run. Same query than before give the followin error: [Microsoft][SQL Native Client][SQL Server]Invalid object name ‘Cheques’ Cheques is a table belong to database. Futhermore in situation 1, reccomend a non cluster index on Cheques. I’ll try to configure SQL Native Client, no lucky.
Any clue?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>