Version 9.04.0013 of the RML Utilities for x86 and x64 has been released to the download center

        X64: http://download.microsoft.com/download/0/a/4/0a41538e-2d57-40ff-ae85-ec4459f7cdaa/RMLSetup_AMD64.msi X86: http://download.microsoft.com/download/4/6/a/46a3217e-f523-4cc6-96e9-df73dd0fdd04/RMLSetup_X86.msi   This build encompasses previous features, fixes and enhancements designed from recent case work.    ·         SQL Server 2014 compliant ·         SQL Server 2012 and 2014 XEL input to ReadTrace compliant (sample .XEL capture script shipped with help documentation) no need for .TRC anymore. (PSSDiag updates align…

1

Cumulative Update 2 to the RML Utilities for Microsoft SQL Server Released

  Version 9.04.004 of the RML Utilities for Microsoft SQL Server has been released.  This release of the RML Utilities provides support for: SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 CTP2 on Windows 7 Windows 8 Windows 8.1 Windows Server 2008 Windows Server 2008 R2 Windows…

11

SQL Server 2012: RML, XEvent Viewer and Distributed Replay

Bob Ward, Keith Elmore and I establish goals for every release of SQL Server.   A primary goal is always to make supporting the SQL Server easier.  Not just in the sense of Microsoft support, although it does play a factor, but more so for you (the customer). During SQL Server 2012 planning we spent a…

5

RML: ReadTrace Appears To Hang at "Doing Post-Load Data Cleanup" Phase

Keith and I continue to field the question as to why the Post-Load Data Cleanup appears to take a long time (hours) and can cause SQL Server to use large amounts of CPU. Notes from Keith: “What that step does it try to correlate stmt-level events with the batch in which they ran, and show…

0

RML Questions

  The following questions have surfaced several times recently so I decided to post the answers to assist others.   String is missing proper closing quote near (Char Pos: 0xC1 Byte Pos: 0x182) This is not a utility bug.   It is a command found in the trace that was malformed.  For example:   select * from…

1

Trace shows the incorrect Session Login Name

The is more of an FYI blog post but I have read several blog and forum posts on this subject and I decided to dig into the behavior which revealed a trace bug. For the vast majority of events the Session Login Name represents the originating session credentials where as the Login Name represents the…

3

Dipping My Toes Into SQL Azure – Part 2 – Protection Mechanisms

I left off my previous post stating that I was going to start looking at performance and reliability issues associated with SQL Azure.   In doing this work I discovered and encountered some of the protection mechanisms   SQL Azure Protection Mechanisms SQL Azure is secure, isolated, multi-tenant system.  As such, the system is designed with…

1

Dipping My Toes Into SQL Azure

My high school English teacher once told me that I should always have a spell checker on my computer.   This might help explain why I never make it past the first couple of chapters in any technical publication before I have to ‘try-it-out.’ Over the last month I have spent several of my evenings learning…

0

RML How Are Comparison Diffs Calculated

A short but good discussion about the RML comparison DIFF calculations.   From: Robert Dorr Sent: Wednesday, January 26, 2011 10:21 AM Subject: RE: MSDN Blogs: Contact request: RML Tools: Estimated Comparison Differences   Thanks for the question and feedback.   For example ProjectedCPUDiff is one of the columns in tblComparisonBatchPartialAggs   ·         The hash…

0

Profiler Shows Negative (Strange) EventSequence Values

I ran into an issue yesterday where the EventSequence column appears negative (or could be truncated and won’t sort correctly) in the Profiler display. Here is an example of the display from a trace that I debugged. When I looked at the raw format I could see the storage for the EventSequence was 8 bytes…

0