SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


PROFILER - Trace Templates that include Groups


PROFILER - Trace Templates that include Groups

Author
Message
YSLGuru
YSLGuru
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2358 Visits: 1665
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!
Jack Corbett
  Jack Corbett
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23850 Visits: 14905
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
Attachments
Template With Group.zip (8 views, 297 bytes)
YSLGuru
YSLGuru
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2358 Visits: 1665
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
  Jack Corbett
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23850 Visits: 14905
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
YSLGuru
YSLGuru
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2358 Visits: 1665
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
  Jack Corbett
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23850 Visits: 14905
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
SpiderDK
SpiderDK
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 131
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
  Jack Corbett
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23850 Visits: 14905
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
SpiderDK
SpiderDK
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 131
Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search