RE: What is the Profiler saying?
From: Pankaj Agarwal [MSFT] (pankaja_at_online.microsoft.com)
Date: 09/02/04
- Next message: Webbee: "RE: Problems with variables"
- Previous message: Russell Fields: "Re: Problems with variables"
- In reply to: Willianto: "What is the Profiler saying?"
- Next in thread: Willianto: "Re: What is the Profiler saying?"
- Reply: Willianto: "Re: What is the Profiler saying?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 02 Sep 2004 20:07:25 GMT
Hello Willanto
If I understand your question - you would like to know what information is
being captured in Profiler.
If this is indeed your question, then let's start with the basics -
1. Bascially to cut the long story short, SQL Server has several code hooks
that trigger a Profiler capture if the event is being profiled.
2. To see what events you are actually capturing, you need to look at the
trace properties under the Events tab.
3. Each event has several associated properties. These properties are shown
in Data Columns tab.
4. You can also filter the trace based on several criteria. You can
configure this from the Filters tab.
For more information on what each Event Category means, refer to the
following Books Online topic :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_mon_perf_6koi.asp
I would suggest you to play with it a little bit to really understand its
potential.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
- Next message: Webbee: "RE: Problems with variables"
- Previous message: Russell Fields: "Re: Problems with variables"
- In reply to: Willianto: "What is the Profiler saying?"
- Next in thread: Willianto: "Re: What is the Profiler saying?"
- Reply: Willianto: "Re: What is the Profiler saying?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|