Re: Read log files

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 08:31:44 -0500

I suggest you start with the Books Online
<adminsql.chm::/ad_mon_perf_88c3.htm>. You can save the results to a table
for ad-hoc analysis. The events of interest here are the 'completed' events
for batches and RPCs. You can also add sp:statement completed if needed. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@discussions.microsoft.com> wrote in message
news:9BF8F3EE-D25B-4089-9E4D-9B34CB99BF69@microsoft.com...
> Hi Dan
>
>    Thanks a lot u'r suggestion was of great help. Can u suggest some site
where i can get good help on making use of the SQL Profiler.
>
> Regards
>
>
> "Dan Guzman" wrote:
>
> > You might consider running a Profiler trace to track application
activity.
> > This can be saved to a table for subsequent analysis.
> >
> > -- 
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "sim sim" <simsim@discussions.microsoft.com> wrote in message
> > news:266C54C8-505E-46BF-8CFB-4C55C6838D40@microsoft.com...
> > > hi Greg,
> > >
> > >    thanks 4 the reply, but this site give a 3rd party software 2 do
the
> > same... can't we read the log file without this. or is there any way by
> > which i can find which tables are getting updated by recent
transactions.
> > >
> > > regards,
> > >
> > >
> > > "Greg Linwood" wrote:
> > >
> > > > Check out Lumigent's "Log Explorer" product - it's built for
performing
> > log
> > > > analysis etc.
> > > >
> > > > www.lumigent.com
> > > >
> > > > Regards,
> > > > Greg Linwood
> > > > SQL Server MVP
> > > >
> > > > "sim sim" <sim sim@discussions.microsoft.com> wrote in message
> > > > news:73057BCA-FDEB-4D07-B5DA-40867DE76678@microsoft.com...
> > > > > hi,
> > > > >
> > > > >  how do i read the transaction log file. Actualy i've got a
database
> > given
> > > > my some 1 else, we do not have the db diagrams and no relationship
> > between
> > > > the tables and no source code, can we find out that when the front
end
> > > > application updates the tables, which are the table where entries r
> > made? I
> > > > wanted to use that data futher?...
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Relevant Pages

  • Re: Status Column in sysobjects table...SQL2000
    ... Please post a sample proc that demonstrates the ... >> Dan Guzman ... >> SQL Server MVP ... even though there are no compilation errors. ...
    (microsoft.public.sqlserver.programming)
  • Re: Status Column in sysobjects table...SQL2000
    ... The QUOTED_IDENTIFER setting may or may not prevent the proc from being ... > Quoted_Identifiers and/or ANSI_NULLS it would not even compile. ... >> Dan Guzman ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: how to scramble data in a table
    ... >> accomplish this with set-based processing using CASE expressions. ... >> Dan Guzman ... >> SQL Server MVP ... >>> Does anyone have a neat way to scramble data in one table? ...
    (microsoft.public.sqlserver.programming)