October 18, 2013 at 9:49 am
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.
October 18, 2013 at 12:42 pm
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.:cool:
Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
October 18, 2013 at 1:15 pm
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.
October 18, 2013 at 1:20 pm
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
October 19, 2013 at 4:05 am
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 😀
October 19, 2013 at 11:23 am
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply