SQL Server Performance

Database Tunig Advisor

Discussion in 'SQL Server 2005 General DBA Questions' started by Luis Martin, Feb 24, 2005.

  1. Luis Martin Moderator

    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.



Share This Page