Re: best practice analyzer help

From: Christian Kleinerman [MS] (ckleiner_at_online.microsoft.com)
Date: 06/08/04


Date: Tue, 8 Jun 2004 10:15:12 -0700

Dimitris
Based on your other post I'm guessing it is related to the trace files
you're feeding to BPA. Trace files should be files generated by SQL Server
profiler, not .sql files.

Let's try two things to isolate the errors you're seeing:
1) clear any specified Trace Files from the servers registered. Try to run
BPA. I'm guessing things should succeed.
2) Try with a .trc file generated by Profiler.

If this doesn't help, search for LOG folder under BPA installation folder
and post the log files.

- Christian

-- 
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"dimitris" <dimitris@microsoft.com> wrote in message
news:ubtp0bSTEHA.1732@TK2MSFTNGP09.phx.gbl...
> Hi,
> I have downloaded and run hte analyzer, but the result I get have lots of
> exeption errors that contain the message:
>
>       Error while executing the Best Practice Group. See the log file
> loadtraced_antodxp_0003_mshfsql_sqlbpa.log. Error message:
>
> the log file cannot be found anywhere on the server or in my pc that I run
> it from...
> regards,
>
>


Relevant Pages

  • Re: imp issue on 9.2.0.7 windows nt
    ... Can you post the relevent contents of the log file that was specified ... Are there multiple oracle homes on the server? ... Are there any trace files generated in bdump, cdump, udump? ...
    (comp.databases.oracle.server)
  • Re: Strange Exchange server 2003 on SBS 2003 behaviour
    ... SBS BPA 2 errors: ... So I change settings recommended from SBS BPA and will see whether it helps. ... the server is original IBM x206 server and we also thought that this ... Information store database seems ...
    (microsoft.public.exchange.admin)
  • Re: The target principal name is incorrect. (-2146893022)
    ... I was reading about the BPA, I will give these a try. ... I did re-run the CEICW ... Microsoft Internet Security and Acceleration Server Best Practices ... Are you running ISA Server on your SBS box? ...
    (microsoft.public.windows.server.sbs)
  • Re: End-of-file Not connected errors on Apache/mod-perl/Oracle on Solaris system.
    ... where I would, in general, find trace files for Apache. ... we find our server comming back from all requests with 3113 and 3114 ... oracle errors, end of file and not connected to Oracle.. ...
    (perl.dbi.users)
  • Re: Strange Exchange server 2003 on SBS 2003 behaviour
    ... we decided to move exchange databases to separate disk. ... Users can connect work with outlook and server does not freez. ... SBS BPA 2 errors: ... etc.) and also discovered broken information store databes so we ...
    (microsoft.public.exchange.admin)