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…


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…


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…


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…


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…


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…


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…


PRB: RML Utilities – ReadTrace processing fails with "Attempt to use an invalid variant type"

Summary ReadTrace processing may unexpectedly fail with the following error: A serious error condition (true == pVariant->FIsUnknownType()) has been encountered.                 Utility Error: Attempt to use an invalid variant type                 File: .rpcbinary.cpp                 Line: 264                 Return Address: 0x000000013FB650A2                 Function: FConvertNCharStringFromRPC More Information A fix is available for this issue.  To request the…


RML Utilities: Recommended SQL Server 2008 updates for ReadTrace processing

There have been a couple of SQL Server 2008 fixes shipped in recent Cumulative Updates, that address issues you may encounter during ReadTrace processing and .RML generation, or OStress replay.  Here are the updates we recommend if you use SQL Server 2008 for your ReadTrace processing, or as the target of your OStress replay: http://support.microsoft.com/kb/959796…