Re: sql profiler newbie
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 09/22/04
- Next message: Hari Prasad: "Re: Set up a mail profile"
- Previous message: Ed: "Set up a mail profile"
- In reply to: JT: "sql profiler newbie"
- Next in thread: JT: "Re: sql profiler newbie"
- Reply: JT: "Re: sql profiler newbie"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 16:23:59 -0700
Hi JT
The profiler GUI will definitely have an impact when monitoring a production
server. The degree of impact will depend on what events you are tracing.
You might consider defining the trace with the Profiler, but then use the
option to save the trace as a SQL Script, and then run the trace totally on
the server, storing the results in a file.
You can read about sp_trace_create and other sp_trace* procedures for more
details.
Note that you cannot save directly to a table when using server side
tracing, but that is a good thing. It is the row at a time processing of
event data that is one of the things that adds the most overhead to
profiler. Saving to a table has to be done one row at a time, but when
saving to a file SQL Server does large block writes that are much more
efficient.
After you have collected the data in a file, you can use the function
fn_trace_gettable to copy the data to a table for analysis.
And you are right, the profiler (and tracing in general) is a wonderful
feature!
-- HTH ---------------- Kalen Delaney SQL Server MVP www.SolidQualityLearning.com "JT" <jt@nospam.com> wrote in message news:e7up%23eOoEHA.868@TK2MSFTNGP10.phx.gbl... > wow - just discovered the wonders of the sql profiler.. > > i'd like to monitor our live database using the sql profiler to get a > better > understanding of the performance under real conditions, however i'm afraid > that by adding the profiler to the mix i will be slowing down the system > even more. is my assumption correct that running the sql profiler itself > hinders performance?? > > what is the best method to do this type of logging? > > can i run the profiler against the live system and have it store the > results > in a table on our development sql server machine? > >
- Next message: Hari Prasad: "Re: Set up a mail profile"
- Previous message: Ed: "Set up a mail profile"
- In reply to: JT: "sql profiler newbie"
- Next in thread: JT: "Re: sql profiler newbie"
- Reply: JT: "Re: sql profiler newbie"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
