Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yaron-b
Starting Member
4 Posts |
 Posted - 2008-06-04 : 07:52:11
|
| 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 tables2. [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure '(some stored procedure name)'.Thanks in advance! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 08:04:34
|
| It may be because the backup is not a recent backup. It may not be having the stored porocedure which trace references. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 09:17:49
|
| I think because trace was created in other machine. |
|
|
|
yaron-b
Starting Member
4 Posts |
Posted - 2008-06-04 : 09:28:33
|
quote:
Originally posted by visakh16
It may be because the backup is not a recent backup. It may not be having the stored porocedure which trace references.
Thanks for your reply, but I don't think that this is the problem because all the stored procedures exist in the backup, and more important - I didn't get any suggestions at all. |
|
|
|
|
|
|
Help with DTA