Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PROFILER - Trace Templates that include Groups Expand / Collapse
Author
Message
Posted Wednesday, September 16, 2009 1:02 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:15 AM
Points: 891, Visits: 1,553
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!
Post #789230
Posted Thursday, September 17, 2009 7:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 10,268, Visits: 13,242
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
Posted Thursday, September 17, 2009 9:20 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:15 AM
Points: 891, Visits: 1,553
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!
Post #789733
Posted Thursday, September 17, 2009 9:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 10,268, Visits: 13,242
Yeah, I'd say it might be bug. It's definitely an interesting problem regardless.



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 #789739
Posted Thursday, September 17, 2009 10:00 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:15 AM
Points: 891, Visits: 1,553
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!
Post #789786
Posted Thursday, September 17, 2009 10:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 10,268, Visits: 13,242
Yup. It was using Profiler 2008 as well.



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 #789793
Posted Wednesday, May 8, 2013 2:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 4, 2014 9:51 AM
Points: 41, Visits: 125
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
Posted Tuesday, May 14, 2013 7:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 10,268, Visits: 13,242
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

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 #1452567
Posted Tuesday, May 14, 2013 7:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 4, 2014 9:51 AM
Points: 41, Visits: 125
Thanks
Post #1452587
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse