Introduction to Profiler

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jack Corbett » Introduction to Profiler

18 posts, Page 1 of 2

1 2 »»

Introduction to Profiler

Rate Topic

Display Mode

Topic Options

Author

Message

Jack Corbett

Posted Wednesday, April 15, 2009 11:30 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Comments posted to this topic are about the item Introduction to Profiler

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #698152

Ross McMicken

Posted Thursday, April 16, 2009 3:41 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:39 PM
Points: 346, Visits: 1,816

Profiler is probably the most valuable tool I use for troubleshooting, especially with vendor provided applications. With Profiler, I can frequenetly determine the cause of an nissue and the fix in just a few minutes, rather than trying to work with the vendor. One of our vendor apps builds SQL code from a library, and Profiler allows us to determine not only what code is executed, but also where teh code was stored.

Post #698252

WILLIAM MITCHELL

Posted Thursday, April 16, 2009 5:47 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 1,441, Visits: 2,485

Thanks Jack, great introduction to Profiler. Looking forward to the next installment.

Post #698315

john.w.walker

Posted Thursday, April 16, 2009 11:29 AM

Valued Member

Group: General Forum Members
Last Login: Monday, December 17, 2012 7:10 AM
Points: 73, Visits: 35

I have been doing SQL Server development for 8 years and have never gone far enough with profiler to run a trace. I read through the article and setup my first trace. I use ColdFusion as my application server so all events are execution of prepared SQL. How can I find the actual SQL, I thought it would be in Text Data?

Post #698724

raj more-489942

Posted Thursday, April 16, 2009 11:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 01, 2012 7:10 AM
Points: 148, Visits: 104

Great intro. I like it.

I have seen tools like Intuit (now Quest S/w) Coefficient that do a phenomenal job of analyzing the output of a trace and posting the results in an extremely easy to use format.

Can you post some useful trace templates that you use for Profiler 2008 and how to use them?

Also, how do you baseline a server using Profiler and how can this info be best used when something starts acting up.

Post #698743

Jack Corbett

Posted Thursday, April 16, 2009 12:50 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

john.w.walker (4/16/2009)

John,

What events are you including in your trace?

Post #698778

j.a.c

Posted Thursday, April 16, 2009 1:09 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:16 PM
Points: 494, Visits: 3,002

Profiler is great when tracking down problems with Service Broker.

Post #698799

john.w.walker

Posted Thursday, April 16, 2009 1:11 PM

Valued Member

Group: General Forum Members
Last Login: Monday, December 17, 2012 7:10 AM
Points: 73, Visits: 35

I am pretty much including all events because I don't know how to choose what I really need. But 99% of what I see is prepared SQL execution and I expected as much due to my application configuration which sends SQL via Data Direct drivers from Java to SQL Server. I se some slower SQL, but I want to know what the SQL statement is or I can't track it down.

Post #698805

john.w.walker

Posted Thursday, April 16, 2009 1:16 PM

Valued Member

Group: General Forum Members
Last Login: Monday, December 17, 2012 7:10 AM
Points: 73, Visits: 35

The events I am seeing that I want to see the SQL for are RPC Completed. Object is sp_prepexec or sp_execute.

Post #698812

Jack Corbett

Posted Thursday, April 16, 2009 1:35 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

John,

I think the issue is that, if you started with the Standard Template, the TextData column is NOT selected for the RPC:Completed event. If you go in and modify the properties of the trace and check the TextData column under the RPC:Completed event I believe you will see something like this in the TextData column:

declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@contact_id int',N'Select Count(*) as persons from Person.Contact Where contactid = @contact_id',@contact_id=541
select @p1

This is from a quickie .NET application where I used Command.Prepare() and queried the AdventureWorks DB.

Post #698842

« Prev Topic | Next Topic »

18 posts, Page 1 of 2

1 2 »»

Permissions