Help with DTA

• • Reply

  12 years ago

  by yaron-b

  Yaron Ben-Ami

  , United Kingdom

  Joined 13 years ago

  Hello!
  
  My hosting company gave me a backup of my online DB (a BAK file), which I've attached to my local SQL Server, in order to perform the tuning locally at first, and then on the online DB.
  
  I use a trace file, which was created by the Profiler, that ran on the online DB.
  I get no suggestions at all, but errors. The most frequent errors are:
  
  1. Event does not reference any tables
  
  2. [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure '(some stored procedure name)'.
  
  
  Thanks in advance!
  

  Report abuse