Re: automating profiler

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jo (Jo_at_discussions.microsoft.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 08:32:01 -0700

Is there a SQL 7.0 soluthion?

"Andrew J. Kelly" wrote:

> Sure, take a look at fn_trace_gettable in BOL. By the way you almost never
> want to trace directly to a table if you care about performance.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Jo" <Jo@discussions.microsoft.com> wrote in message
> news:75FFDF10-B0AA-4AD4-8573-0A241F630717@microsoft.com...
> > I have created a stored proc that will automate the capture of traces. The
> trace is captured to a file instead of a table because tracing to a table on
> the same server has caused performance issues.
> >
> > The problem is that I really want the trace in a table so that we can
> produce reports with Reporting Services. I know that I can manually save the
> trace to a trace table. But is there a way to automate this process? I can't
> find any command line parameters for Profiler.
> >
> >
> >
>
>
>

Relevant Pages

  • Re: Simple timeout problem
    ... Brian, I haven't found anything specific on this error. ... We'd want to limit the trace to just the BizTalkRuleEngineDB. ... To run a trace go to SQL Profiler (under the SQL Server entry in the start ... | are reporting a timeout condition trying to connect to the SQL database. ...
    (microsoft.public.biztalk.general)
  • Re: Profiler Bug viewing trace flat file?
    ... Kalen Delaney, SQL Server MVP ... Run this code to create a trace capture of the RPC:Complete event: ... declare @error INT ... Now open the trace file in Profiler and you will see that the Textdata ...
    (microsoft.public.sqlserver.tools)
  • Re: How to look at parameter string
    ... I am tracing, but the problem I can't trace (at least, I haven't figured out ... string it is putting together to send to Sql. ... >> The problem is not coming from Sql Server but from my page. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Auditing sql server at runtime
    ... Use SQL Profiler to define your trace, ... User sp_procoption to mark the stored procedure for autoexecution when the SQL Server is restarted. ...
    (microsoft.public.sqlserver.clients)
  • I asked about DBI tracing a while ago
    ... A while ago I asked a question about how do I trace what SQL queries ... (please do not mention setting trace on on DBI, it does not do what I ... to speed it up 3 times by using better SQL and calling SQL less often. ... sub prepare { ...
    (comp.lang.perl.misc)