|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Tuning Wizard cannot find SPAfter capturing some activity into a profile using the SQL2005 Profiler,
The database Tuning wizard seems to be unable to locate one and only one of the stored Procedures that was called and gives me an E001 error/warning. I have tried recreating the SP it still reports it missing. Since it was run it is obviously there. It belongs to dbo and is called as such via ADO. Any advice on how to help the Tuning engine see it? Thanks. Otis Bricker I assume it is in the database you selected in the tuning advisor. One
thing to try may be to edit the workload file and make sure that the object is referenced using three-part naming database.owner/schema.object Show quote "Otis Bricker" <obric***@my-dejanews.com> wrote in message news:Xns987C7CDDB9302obrickermydejanewsco@216.196.97.136... > After capturing some activity into a profile using the SQL2005 Profiler, > The database Tuning wizard seems to be unable to locate one and only one > of > the stored Procedures that was called and gives me an E001 error/warning. > > I have tried recreating the SP it still reports it missing. Since it was > run it is obviously there. It belongs to dbo and is called as such via > ADO. > > Any advice on how to help the Tuning engine see it? > > Thanks. > > Otis Bricker
Show quote
"Aaron Bertrand [MVP]" <ten.xoc@dnartreb.noraa> wrote in Thanks. I'll give it a try. It would be odd if this was it though since it news:e4ZUJ$QCHHA.4256@TK2MSFTNGP04.phx.gbl: > I assume it is in the database you selected in the tuning advisor. > One thing to try may be to edit the workload file and make sure that > the object is referenced using three-part naming > database.owner/schema.object > > > > > > "Otis Bricker" <obric***@my-dejanews.com> wrote in message > news:Xns987C7CDDB9302obrickermydejanewsco@216.196.97.136... >> After capturing some activity into a profile using the SQL2005 >> Profiler, The database Tuning wizard seems to be unable to locate one >> and only one of >> the stored Procedures that was called and gives me an E001 >> error/warning. >> >> I have tried recreating the SP it still reports it missing. Since it >> was run it is obviously there. It belongs to dbo and is called as >> such via ADO. >> >> Any advice on how to help the Tuning engine see it? >> >> Thanks. >> >> Otis Bricker > > > manages to work out all the other SPs that are also called via ADO the same way. But it is worth trying and I'll pass back the results. Thanks again. Otis I'm having the same problem. Can you tell me how to edit the workload file?
I can't find any documentation about that. Show quote "Aaron Bertrand [MVP]" wrote: > I assume it is in the database you selected in the tuning advisor. One > thing to try may be to edit the workload file and make sure that the object > is referenced using three-part naming database.owner/schema.object > > > > > > "Otis Bricker" <obric***@my-dejanews.com> wrote in message > news:Xns987C7CDDB9302obrickermydejanewsco@216.196.97.136... > > After capturing some activity into a profile using the SQL2005 Profiler, > > The database Tuning wizard seems to be unable to locate one and only one > > of > > the stored Procedures that was called and gives me an E001 error/warning. > > > > I have tried recreating the SP it still reports it missing. Since it was > > run it is obviously there. It belongs to dbo and is called as such via > > ADO. > > > > Any advice on how to help the Tuning engine see it? > > > > Thanks. > > > > Otis Bricker > > > > I'm having the same problem. Can you tell me how to edit the workload Open it, find references to dbo.tablename, and change them to > file? dbname.dbo.tablename, save it. A  |
|||||||||||||||||||||||
Other interesting topics