PROFILER - Trace Templates that include Groups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » PROFILER - Trace Templates that include...

PROFILER - Trace Templates that include Groups

Rate Topic

Display Mode

Topic Options

Author

Message

YSLGuru

Posted Wednesday, September 16, 2009 1:02 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:18 AM
Points: 848, Visits: 1,453

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,

A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.

Post #789230

Jack Corbett

Posted Thursday, September 17, 2009 7:35 AM

SSChampion

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

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

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 Attachments

Template With Group.zip (3 views, 297 bytes)

Post #789631

YSLGuru

Posted Thursday, September 17, 2009 9:20 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:18 AM
Points: 848, Visits: 1,453

Jack Corbett (9/17/2009)

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,

A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.

Post #789733

Jack Corbett

Posted Thursday, September 17, 2009 9:26 AM

SSChampion

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

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

Post #789739

YSLGuru

Posted Thursday, September 17, 2009 10:00 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:18 AM
Points: 848, Visits: 1,453

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,

A Democracy works great until the day you find yourself on the sheep side of a vote between 5 wolves and 4 sheep on what’s for dinner when neither have eaten in many days. A free Republic where the rights of the few and the individual are protected is the only one in which Freedom and Prosperity for all have a chance to blossom.

Post #789786

Jack Corbett

Posted Thursday, September 17, 2009 10:11 AM

SSChampion

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

Yup. It was using Profiler 2008 as well.

Post #789793

SpiderDK

Posted Wednesday, May 08, 2013 2:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:49 AM
Points: 39, Visits: 116

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

Post #1450447

Jack Corbett

Posted Tuesday, May 14, 2013 7:30 AM

SSChampion

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

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.

Post #1452567

SpiderDK

Posted Tuesday, May 14, 2013 7:50 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:49 AM
Points: 39, Visits: 116

Thanks

Post #1452587

« Prev Topic | Next Topic »

Permissions