SQLServerCentral.com Articles tagged Profiler

Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass

Thu, 17 May 2012 06:00:00 UT

A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.

SQL Server Blocking Monitoring

Thu, 19 May 2011 06:00:00 UT

Monitoring blocking can be problematic when you cannot catch it in the act. This article will show you an easy way to configure a SQL Server Profiler Trace to monitor blocking

Working with SQL Server Profiler Trace Files

Wed, 16 Feb 2011 07:00:00 UT

In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.

Fun with SQL Server Profiler trace files and PowerShell

Wed, 22 Dec 2010 07:00:00 UT

Running Profiler traces against multiple servers becomes a painful process when it’s time to collate and filter all that data. It would be time-consuming, frustrating and messy if Laerte hadn’t written this handy PowerShell script (complete with examples) to help you out.

Set Up And Schedule a Server Side Trace

Thu, 02 Dec 2010 07:00:00 UT

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace

SQL Profiler Through StreamInsight Sample Solution

Tue, 21 Sep 2010 06:00:00 UT

In this postI show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight. Here is the solution for that post. The download contains Project that reads events from a previously recorded trace file Project that starts a trace and captures events in real-time from a custom trace definition file (Included) It is a very simple solution and could be extended.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Performance testing and tuning for a beginner

Fri, 10 Sep 2010 06:00:00 UT

How to test and tune a stored procedure?

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Streaming Profiler Data Through StreamInsight

Tue, 31 Aug 2010 06:00:00 UT

Using the Trace Management objects API it is possible to capture the events happening on SQL Server or indeed Analysis Services. I got to thinking that this would be a good thing to stream out in real time in StreamInsight and do some analysis “In Flight”. So here is a short video of me doing just that.

Determining Object Access Using SQL Server Profiler

Wed, 30 Jun 2010 06:00:00 UT

Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.

Profiling SSIS packages for component level change tracking

Thu, 10 Dec 2009 07:00:00 UT

In this tip we will look at an add-in that helps you better identify changes between two versions of an SSIS package.

Troubleshooting Performance Problems in SQL Server 2008

Fri, 31 Jul 2009 06:00:00 UT

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.

Auditing with SQL Profiler

Thu, 16 Jul 2009 06:00:00 UT

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.

Testing with Profiler Custom Events and Database Snapshots

Wed, 15 Jul 2009 06:00:00 UT

We've all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they're so complex and have so many logic offshoots that it's very easy to get lost when you're trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code.

SQL Server Profiler Part 2: Custom Templates and Saving Data

Mon, 15 Jun 2009 06:00:00 UT

In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.

Trace File Source Adapter

Wed, 27 May 2009 06:00:00 UT

The Trace File Source adapter is a useful addition to your SSIS toolbox. It allows you to read 2005 and 2008 profiler traces stored as .trc files and read them into the Data Flow. From there you can perform filtering and analysis using the power of SSIS

Mastering SQL Server Profiler - Part 6: Creating Custom Traces

Thu, 21 May 2009 06:00:00 UT

The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Mastering SQL Server Profiler - Part 5: Data Columns

Tue, 19 May 2009 06:00:00 UT

The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.

Mastering SQL Server Profiler - Part 4: Profiler Events

Thu, 14 May 2009 06:00:00 UT

The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.

Mastering SQL Server Profiler - Part 3: Getting Started

Tue, 12 May 2009 06:00:00 UT

This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Mastering SQL Server Profiler - Part 2: Profiler Architecture

Thu, 07 May 2009 06:00:00 UT

This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.

Mastering SQL Server Profiler - Part 1: Introduction to Profiler Concepts

Tue, 05 May 2009 06:00:00 UT

In this video written by MVP Brad McGehee you can learn how to get started using the Profiler GUI.

Mastering SQL Server Profiler - Introduction

Thu, 30 Apr 2009 06:00:00 UT

This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.

Mastering SQL Server Profiler - Video Training Course

Tue, 21 Apr 2009 11:32:02 UT

In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering the basics of SQL Server Profiler, a powerful performance monitoring and analysis tool.

How to Identify Blocking Problems with SQL Profiler

Tue, 31 Mar 2009 06:00:00 UT

Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking issues. But since SQL Server 2005, it's a good idea to use the SQL Profiler for all but the most complex problems. Brad McGehee takes us through the steps...

Mastering SQL Server Profiler

Mon, 09 Feb 2009 18:33:43 UT

SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.

Performance testing and tuning for a beginner

Fri, 10 Sep 2010 06:00:00 UT

How to test and tune a stored procedure?

Blog: How to Script a Profiler Trace as a SQL Trace Data Collection Set

Wed, 01 Oct 2008 06:00:00 UT

MVP Brad McGehee shows how you can use Trace data as a source for your data collections for the new Management Data Warehouse

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Using Profiler - SQL School Video

Tue, 02 Sep 2008 06:00:00 UT

A basic tutorial that examines how Profiler can be used in SQL Server 2005 to monitor your SQL Server instance. MVP Brian Knight shows how to create a trace and the various options you have for monitoring events.

How to Track Down Deadlocks Using SQL Server 2005 Profiler

Mon, 21 Jul 2008 06:00:00 UT

It is irritating, sometimes alarming, for the user to be confronted by the 'deadlock message' when a deadlock happens. It can be a tiresome business to prevent them from occurring in applications. Fortunately, the profiler can be used to help DBAs identify how deadlocking problems happen, and indicate the best way of minimising the likelihood of their reappearance.

Scripting Trace's for SQL 2005

Thu, 19 Jun 2008 06:00:00 UT

How to Script Traces for SQL and Analysis Services