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 |
|
vitoco
Starting Member
22 Posts |
 Posted - 2007-12-13 : 16:30:21
|
I'm running Database Engine Tuning Advisor over a huge workload table, and getting many errors like the following:quote:
E000 declare @p19 intset @p19=228exec MySProc @Cod='T12',@Nro=default,@IdM=727,@Rec=@p19 outputselect @p19 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'MySProc'.
MySProc exists in the database to tune, and I'm not sure if every record that references that SP fails or it is random, because once it also logged S001 messages for the declare, set and select lines of the same call with other parameters.What's going on?BTW, I uploaded my trace ([url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93801[/url]) to another 2K5 server where I also restored a backup of the traced database taken a couple of days later. It's strange that DETA requires that the database to tune and the database where the workload table resides must be on the same server!!!Oh, DETA is still running after 23 hours of analisys  Thanks in advance.++Vitoco |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-13 : 17:31:48
|
| must be one hell of a database...._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
vitoco
Starting Member
22 Posts |
Posted - 2007-12-14 : 11:03:54
|
This DB has more than 500 tables, 1500 SPs and a lot of FKs.When I run DETA over a single 50MB trace file, it took about 20-30 minutes to give a report. Now, for the total workload of 102 trace files loaded into a table (about 7GB), I expect it will take about 50 hours... more than 2 days. This started about 39 hours ago!BUT, this morning I found other errors messages in the log, all of them saying that something is not found:quote:
[Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.OneLargeTable'.
quote:
Event does not reference any tables
The events for the latest are alter index, update statistics or even one of the big queries inside sp_execsql.I'm very curious about these errors. I don't want to spend more days waiting for nothing. The worst part of this, is that a Microsoft consultant require us to run this analisys for a complete month!!!  Help!++V |
|
|
|
vitoco
Starting Member
22 Posts |
Posted - 2007-12-19 : 13:20:03
|
I think that I found the explanation for the "not found" error: I missunderstood what the field "Database for workload analysis" was for. I put the name of the database where the workload resides, not the default database to analyze. I guess that most of my records does no include "use" (ref: [url]http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2483028&SiteID=1[/url]).BTW, my analysis crashed after more than 72 hours (I started it a week ago, but I left it unattended for the last 4 days)... It didn't generate any report  Now I'm running the same analysis with the first 69949 records (50MB of trc) instead of the total 7165375 (I had to create a new table with the partial workload). Still running...Is there a way to speed up things?++Vitoco |
|
|
|
|
|
|
|
|
Tuning Advisor: "Could not find stored procedure"