Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Profiler Rss

Search for any content tagged profiler

   Items 1 to 20 of 35    Older >>
 

Set Up And Schedule a Server Side Trace

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace  Read more...
By Grant Fritchey 2013/12/31 (first published: 2010/12/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,275 reads

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

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.  Read more...
By Additional Articles 2012/05/17 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,571 reads

SQL Server Blocking Monitoring

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  Read more...
By BJ Hermsen 2011/05/19 | Source: SQLServerCentral.com | Category: blocking
Rating: |  Discuss |   Briefcase | 9,234 reads

Working with SQL Server Profiler Trace Files

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.   Read more...
By Additional Articles 2011/02/16 | Source: MSSQLTips.com | Category: trace files
Rating: (not yet rated)  Rate this |   Briefcase | 3,690 reads

Fun with SQL Server Profiler trace files and PowerShell

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.  Read more...
By Additional Articles 2010/12/22 | Source: SimpleTalk | Category: profiler
Rating:  Rate this |   Briefcase | 3,013 reads

Set Up And Schedule a Server Side Trace

How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace  Read more...
By Grant Fritchey 2013/12/31 (first published: 2010/12/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,275 reads

SQL Profiler Through StreamInsight Sample Solution

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.  Read more...
By Additional Articles 2010/09/21 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,814 reads

Performance testing and tuning for a beginner

How to test and tune a stored procedure?  Read more...
By Arup Chakraborty 2010/09/10 (first published: 2008/11/17) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,206 reads

Streaming Profiler Data Through StreamInsight

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.  Read more...
By Additional Articles 2010/08/31 | Source: sqlis.com | Category: streaminsight
Rating: (not yet rated)  Rate this |   Briefcase | 1,915 reads

Determining Object Access Using SQL Server Profiler

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.  Read more...
By Additional Articles 2010/06/30 | Source: Database Journal | Category: profiler
Rating: (not yet rated)  Rate this |   Briefcase | 2,239 reads

Profiling SSIS packages for component level change tracking

In this tip we will look at an add-in that helps you better identify changes between two versions of an SSIS package.  Read more...
Rating:  Rate this |   Briefcase | 2,504 reads

Troubleshooting Performance Problems in SQL Server 2008

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...
By Additional Articles 2009/07/31 | Source: TechNet Blogs | Category: troubleshooting
Rating:  Rate this |   Briefcase | 4,155 reads

Auditing with SQL Profiler

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.  Read more...
By Thom Bolin 2009/07/16 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 5,593 reads

Testing with Profiler Custom Events and Database Snapshots

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.  Read more...
By Additional Articles 2009/07/15 | Source: SQLTeam.com | Category: profiler
Rating: (not yet rated)  Rate this |   Briefcase | 1,957 reads

SQL Server Profiler Part 2: Custom Templates and Saving Data

In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.  Read more...
By Jack Corbett 2009/06/15 | Source: SQLServerCentral.com | Category: profiler
Rating: |  Discuss |   Briefcase | 3,826 reads

Trace File Source Adapter

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  Read more...
By Additional Articles 2009/05/27 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 1,557 reads

Mastering SQL Server Profiler - Part 6: Creating Custom Traces

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.  Read more...
By Brad McGehee 2009/05/21 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 8,068 reads

Mastering SQL Server Profiler - Part 5: Data Columns

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.  Read more...
By Brad McGehee 2009/05/19 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 9,355 reads

Mastering SQL Server Profiler - Part 4: Profiler Events

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.  Read more...
By Brad McGehee 2009/05/14 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 8,076 reads

Mastering SQL Server Profiler - Part 3: Getting Started

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.  Read more...
By Brad McGehee 2009/05/12 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 8,488 reads
   Items 1 to 20 of 35    Older >>