SQL Server Profiler Templates

This videos exlains how to create a new template in SQL Server 2005 Profiler

I have been working with SQL Server since 1999 and have worked with versions 6.5 - 2005. I have experience in VB 6 and .NET (ASP.NET, VB.NET, C#). I currently work as a Software Developer for New Tribes Mission (www.ntm.org)

ravi on 11/28/2008

visually not that clear.

Prasanna Prabhu on 11/28/2008

Even though you saved the template as "JumpStart" and then started a new trace to open the "JumpStart" template, you should have navigated to "Events Selection" TAB to ensure your change/selection was still persisted, just to prove the thoery

Venkata Taduri on 2/24/2009

Is audio missing in the video? Very nice.

Gerard Sacay on 5/20/2009

I am using a SQL Profiler 8, i am just wondering why such pop-up menu for connecting to db server is not appearing when i open my profiler.

Jimmya11 on 8/3/2009

can you create a SQL profiler template, and save it locally, then import it on another totally different SQL DB?

Jack Corbett on 8/4/2009

Sorry Gerard I must have missed your comment earlier. To get the connect to server dialog you have to select new trace from the file menu or the toolbar.

Jack Corbett on 8/4/2009

Jimmya11, You can export a template and import it onto any PC with Profiler installed. On the PC you designed the template on open Profiler and go to File -> Templates -> Export Template. Being sure to export to a location accessible to the other PC or onto removable media. Then on the other PC do File -> Templates -> Import Template

Eric Moreau on 2/10/2011

quick and straight to the point. I like this.

Kasey Wheeler on 2/10/2011

Old video.

Rich on 2/10/2011

Jack, thank you. One thing I notice on my server (Windows 2K3, SQL 2005 Enterprise) is that user-defined trace files are stored per user, not per server. The dummy tdf file I created is saved to C:\Documents and Settings\myusername\Application Data\Microsoft\SQL Profiler\9.0\Templates\Microsoft SQL Server\90\testtemplate.tdf So if you log in to a server, other users won't be able to see the trace templates you create, apparently. You'll need to either copy the template to another user's folder or go through Export/Import.

huruy yohannes on 2/10/2011

Thank you. I was hoping for a more indepth look into profiler, but i guess the video shows what the title promises. Thanks for the upload.

Julio Santos on 2/10/2011

too trivial

chapas on 2/10/2011

This is to simple.

MohanD on 2/10/2011

Good.

Leonard Peoples on 2/10/2011

?

RangeValidator on 2/10/2011

I was just wondering how to save the template yesterday. Very timely.

Robert Djabarov on 2/10/2011

You did not show where templates are stored.

Maurice Ivory on 2/11/2011

This good knowledge to know, so I don't have to recreate a template.

Bridget on 2/14/2011

Too small, couldn't see presentation well.

Jacqueline Mornan on 2/14/2011

video window too small. When zoomed in, it was still small. Please make window bigger.

Jason Scott on 2/15/2011

Pretty superficial.

Charles Prawin on 2/22/2011

its nice

T. Carnahan on 5/3/2011

Good series on Profiler! I wish you had something on Performance Tuning.