Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Tracing   (RSS)
Monday, May 11, 2009 5:41 PM

How Do I Determine Which Dump Triggers Are Enabled

_____________________________________________ Subject: RE: dumptrigger question They don't survive service restart. SQL 2000 did not have dumptrigger enabled for all error messages and I think 1105 is an ex_callprint instead of ex_raise so it won't work
Posted by psssql | 1 Comments
Filed under: , ,
Thursday, April 30, 2009 4:44 PM

Why Should I Use Extended Events in SQL Server 2008?…

You may or may not have heard of a new diagnostic technology in SQL Server 2008 called Extended Events (XEvent). I thought I would post an example of why this technology can do things nothing else we have can when you deploy SQL Server 2008. Someone internally
Posted by psssql | 2 Comments
Monday, January 12, 2009 11:14 PM

ReadTrace Generates Unexpected Connect Node - Not Really

At first glance it appears that ReadTrace has generated an unexpected connect node.  Upon closer inspection the behavior is correct in order to maintain the proper set options for the connection. Trace has both physical and logical connect/disconnect
Posted by psssql | 0 Comments
Tuesday, December 16, 2008 11:47 PM

How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)

Many of you have encountered the RDTSC timing variances that I outlined in an earlier blog post:   http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx
Posted by psssql | 3 Comments
Friday, December 12, 2008 8:46 PM

How It Works: SQL Trace and MARS Connections

MSDN, TechNet, Books Online and other sources outline what Multiple Active Result Sets (MARS) is, how to use it and transaction scopes.   Working on an issue this week I found I needed to understand what the trace looked like.  In doing
Posted by psssql | 1 Comments
Filed under: ,
Tuesday, December 02, 2008 5:02 PM

How It Works: What is behind the SQLCLR wait category in SQL Server 2008 Activity Monitor

I was asked a question as the CSS First Aid Station at SQL PASS 2008 where the Activity Monitor kept showing the SQLCLR wait category as the top waiter, even when no other activity was going on.  After some digging I found that this is a bug and
Posted by psssql | 1 Comments
Wednesday, July 23, 2008 9:01 PM

How It Works: Attention, Attention or Should I say Cancel the Query and Be Sure to Process Your Results

I ran into this issue the other day and decided it would make a good post.  Since I have seen this issue more times that I can count I will again attempt to provide details. The attention event in SQL Server trace output indicates a query cancellation.  
Posted by psssql | 2 Comments
Wednesday, June 25, 2008 3:01 PM

How It Works: Trace (.TRC) File Security

SQL Server 2000 shipped with different trace file security than later builds of SQL Server 2000, SQL Server 2005 and SQL Server 2008. The SQL Server process (sqlservr.exe) writes the trace files to the specified destination.   The SQL Server
Posted by psssql | 3 Comments
Thursday, January 24, 2008 3:30 PM

How It Works: Conversion of a Varchar, RPC Parameter to Text from a Trace (.TRC) Capture

The Senior Escalation Engineers do various training and mentoring activities. As I do this I thought I would try to propagate some of this information on the blog. This was an interesting issue I ran into this week. The reported problem was that the data
Posted by psssql | 1 Comments
Thursday, March 29, 2007 8:52 PM

SQL Server 2005 SP2 – Trace Event Change – Connection Based Events

Starting with SQL Server 2005 SP2 the connection based events are also produced for sp_reset_connection activities, indicating the connection was reset. The pattern will look like the following. RPC:Starting sp_reset_connection Disconnect Subclass = 2
Posted by psssql | 3 Comments
Filed under: , ,
Wednesday, February 21, 2007 1:47 AM

The Importance of the Trace Event Sequence Column and SQL Server 2005 SP2 Changes

Many of us are used to looking at a SQL Trace and making the assumption that the order of display is what occurred during the capture. SQL Server 2005 introduced a new column named ‘Event Sequence’ that you should capture for any trace events. The Event
Posted by psssql | 0 Comments
Filed under: ,
 
Page view tracker