View Single Post

   
  #17 (permalink)  
Old 03-17-2008, 07:12 AM
John Sheppard
 
Posts: n/a
Default Re: Track changes made to SQL Server


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A56F06EF195DYazorman@127.0.0.1...
> John Sheppard (nospam@spamspam.com) 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@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx


I've installed the developer edition and I dont have a Microsoft SQL
Server -> performance tools -> profiler in the start menu

Why am i having no luck, this is so frustrating...


Reply With Quote