PROFILER - Trace Templates that include Groups

Question

PROFILER - Trace Templates that include Groups

YSLGuru

SSC-Insane

Points: 21661
More actions
September 16, 2009 at 1:02 pm

#210927

Does anyone know if it is possible to save to template a Trace file that includes 1 or more GROUP items? When I setup a Trace Temploate and within the ORGANIZE COLUMNS feature I move a column up until it is in the GROUP area I can use the trace but it will not let me save that as a Template. The SAVE menu items are all dimmed out.
If I edit a template to include that change, moving a column up into a GROUP, it will let me save the Template but that change is not actually saved and this can be verified because then next trace created from this template does not include any columns in the GROUP area.
Thanks
Kindest Regards,
Just say No to Facebook!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Instead of doing new trace and then save as a template have you you tried using File -> Templates -> New Template? I was able to create a template that has a group via this method. I am attaching the file.

Jack Corbett
Consultant - Straight Path Solutions
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

YSLGuru SSC-Insane Points: 21661 More actions · Answer 2

Jack Corbett (9/17/2009)
Instead of doing new trace and then save as a template have you you tried using File -> Templates -> New Template? I was able to create a template that has a group via this method. I am attaching the file.

Well that did work. I guess this is just a bug in Profiler, that you can't set a template to include Column Grouping unless you do it as you have described above,

Thanks

Kindest Regards,

Just say No to Facebook!

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Yeah, I'd say it might be bug. It's definitely an interesting problem regardless.

Jack Corbett
Consultant - Straight Path Solutions
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

YSLGuru SSC-Insane Points: 21661 More actions · Answer 4

I assume then that it happened to you as well when trying to do this Template edit/save in some way other then you described as the solution?

Kindest Regards,

Just say No to Facebook!

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

Yup. It was using Profiler 2008 as well.

Jack Corbett
Consultant - Straight Path Solutions
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

SpiderDK SSC Veteran Points: 271 More actions · Answer 6

Hey All

I have made a Server Side Trace, and have TRC file.

I need to load data, and group this data

template with group only groups on eventid.

If I have following statements

exec usp_GetData @personid=1000

exec usp_GetData @personid=1001

exec usp_GetData @personid=1002

exec usp_GetData @personid=1003

exec usp_GetData @personid=1004

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1000

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1001

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1002

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1003

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1004

select count(1) members, role from dbo.servicelog where personid < 10000 and personid > 999 group by role order by members

Then I want to end up with 3 rows

TextData Hits Duration

----- ----- ------

exec usp_GetData 5 15101

select personid, fullname, role, last_login_time from dbo.servicelog where personid = ... 5 16126

select count(1) members, role from dbo.servicelog where personid < ... and personid > ... group by role order by members 1 244335

This will give me a impression on how many times a statements has been run, how long time users has spend waiting, what average is on a single run

From what I can see is this not possible using group by ;(

Hope someone can help me

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

SpiderDK,

Your issue really should be a separate thread as it doesn't really have to do with Trace Templates. Having said that, you need to find a way to "normalize" your queries. Basically you need to have a way that converts your values to parameters. Fortunately there is an application that will do all this for you and it is called ClearTrace. The only issue you might have with this application is that it creates it's own database to handle the results.

Jack Corbett
Consultant - Straight Path Solutions
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

SpiderDK SSC Veteran Points: 271 More actions · Answer 8

SpiderDK

SSC Veteran

Points: 271

May 14, 2013 at 7:50 am

#1614999

Thanks