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 Expand / Collapse
Author
Message
Posted Friday, October 18, 2013 9:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 9:15 AM
Points: 19, Visits: 60
This may not fit this category.

Does anybody know how to create a template in SQL Profiler 2008r2 that would allow you to use that on a 2012 server?

I Profiler can trace what I am doing in the software which is on 2012 but I won't let me save my template to use it again. I have to continually change the settings.
Post #1506242
Posted Friday, October 18, 2013 12:42 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 7:22 AM
Points: 77, Visits: 150
Hi cdl_9009, welcome to the forum

I don't know if i did understand your question but you can create templates within sql server profiler this way :

Click File > Templates > New Template

Hope it helps.


Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
Post #1506299
Posted Friday, October 18, 2013 1:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 9:15 AM
Points: 19, Visits: 60
Correct,

I was creating my template that way but when tried to tie it to my SQL2012 database, it wouldn't save the template for me to use it when I got in the next time. I always have to manually set it up.

I am thinking maybe I can't save it because I don't have SQL2012 client utilities on my machine. I only have the 2008r2 but I can use 2008r2 to access 2012 database and query it.


Post #1506314
Posted Friday, October 18, 2013 1:20 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 7:22 AM
Points: 77, Visits: 150
Not related, but with sql server 2012 you have now Extended events, pretty similar to SQL Server profiler but with better performances and scalability. Check it out !

Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
Post #1506318
Posted Saturday, October 19, 2013 4:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:20 PM
Points: 112, Visits: 802
If you are using the GUI for Profiler Trace (Taking a guess, but I believe you are)

Have you considered scripting from your template out with appropriate options to run a server side trace? Additionally a server side trace is less resource intensive that client side. Be sure to filter as many things out as possible to make trace more specific.


--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1506381
Posted Saturday, October 19, 2013 11:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:13 AM
Points: 307, Visits: 475
cdl_9009 (10/18/2013)
This may not fit this category.

Does anybody know how to create a template in SQL Profiler 2008r2 that would allow you to use that on a 2012 server?

I Profiler can trace what I am doing in the software which is on 2012 but I won't let me save my template to use it again. I have to continually change the settings.


Create a profiler trace on the 2008R2 machine. Export the trace as a TSQL script and run that script on the 2012 server. You shouldn't have any problems.

In essence you would be creating a server-side trace and using it on another server.
Post #1506410
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse