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

Content with tag Profiler Rss

   Items 1 to 20 of 46    Older >>
 

Reading, Writing, and Riskmetic

By Andy Warren 2014/06/19 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,487 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,461 reads

Read large C2 Audit Mode trace files

Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.  Read more...
By Michael Lascuola 2012/10/18 | Source: SQLServerCentral.com | Category: profiler
Rating: (not yet rated) |  Discuss |   Briefcase | 363 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,589 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 945 reads

Profiler

By FOR SQLSERVER 2011/06/15 | Category: profiler
Rating: (not yet rated) |  Discuss |   Briefcase | 2,358 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,333 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,717 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,026 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,461 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,826 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,229 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,928 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,253 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,520 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,168 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,595 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,966 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,832 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,570 reads
   Items 1 to 20 of 46    Older >>
 
Tags
video (9)    
training (7)    
performance tuning (5)    
sql server 2005 (5)    
sql server 2008 (5)    
trace (4)    
auditing (3)    
sql trace (3)    
administration (2)    
blocking (2)    
integration services (ssis) (2)    
monitoring (2)    
security (2)    
server side trace (2)    
streaminsight (2)    
trace files (2)    
analysis services (ssas) (1)    
books (1)    
c2 audit mode (1)    
data collector (1)    
database snapshots (1)    
ddl (1)    
deadlock (1)    
default trace (1)    
dml tracking (1)    
dmv (1)    
extended events (1)    
fn_trace_gettable (1)    
high performance sql server series (1)    
mdw (1)    
performance metrics (1)    
powershell (1)    
production support (1)    
stored procedures (1)    
system monitor (1)    
traces (1)    
troubleshooting (1)