Re: Track changes made to SQL Server


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns9A56F06EF195DYazorman@xxxxxxxxxxxx
John Sheppard (nospam@xxxxxxxxxxxx) writes:
What do you mean profile on a server-side trace?

In the SQL Server program group, you find Profiler under Performance
tools. This tool permits you trace a whole bunch of things that goes
on in SQL Server. If you just press OK on all buttons that comes up,
you will see all command batches that are sent to the server. You can
set up filter to trace only a certain connection. And a lot more.

The Profiler is just the front-end. The trace engine itself lives in
SQL Server, and you can access it directly by setting up a server-side
traces. (The easiest way to do that is to set up the trace in Profiler and
then export the trace.) Server-side trace is the recommended for long-term
traces, and also when you trace in loaded production environments, as
it takes less load than a Profiler trace.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

ic! Thats what I want!

Now you're gonna tell me that it doesnt come with SQL Server Express, right? :) Im pretty sure it doesnt as theyre not there....

I'll look into it

Thanks for your help man, I'll see what I can find...
John

.

Relevant Pages

  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT deadlock question
    ... > Profiler to view a trace, SQL Server dumps rowsets across the network to ... > SQL Server doesn't feel like it can keep up with all the activity. ... > server-side trace to a trace file guarantees you'll see everything. ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Server 2000 Profiler (Bug?)
    ... could trace many Error 208 by using Profiler when you using SQL Server ... Enterprise Manager navigate around in the Server.Have I fully understood ...
    (microsoft.public.sqlserver.server)
  • RE: Insert Performance Degradation
    ... Use Profiler to trace the statements sent to sql server. ... duration template and filter for duration greater than, let us say, 1000 ...
    (microsoft.public.sqlserver.programming)
  • Re: Track changes made to SQL Server
    ... In the SQL Server program group, you find Profiler under Performance ... This tool permits you trace a whole bunch of things that goes ...
    (comp.databases.ms-sqlserver)