Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 plans...
  • Blog Post: 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. ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: SQL Denali - DReplay/XEProfiler or RML Utilities

    Many of you have used the RML utilities that Keith Elmore and I built and provided to the community on the download center. One of the features of the RML utilities was the ability to do sophisticated replay operations. I was queried about the new DReplay and thought this would make a nice post. As my...
  • Blog Post: PRB: RML Utilities – OStress QryBindColumnStorage: unknown/unhandled SQL datatype

    Summary During OStress replay you encounter an error like the following and processing stops: 07/21/09 08:05:39.697 [0x00001C0C] QryBindColumnStorage: unknown/unhandled SQL datatype (-152), column number 25 (YourColumn) 07/21/09 08:05:40.697 [0x00001C0C] [spid 75] Encountered previous error condition...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: PRB: RML Utilities - Reporter errors during report rendering

    Summary On a sporadic basis you may encounter any one of the following errors while rendering reports in Reporter: Index was outside the bounds of the array. Object reference not set to an instance of an object. Fix The following Reporting Services hotfix resolves this issue: http://support.microsoft...
  • Blog Post: INF: Multi-Machine Replay Using ORCA and OSTRESS

    You can place ORCA on a central computer and allow it to control the sequencing from multiple client computers running OSTRESS.    To accomplish this you must configure the firewall properly. Note: Be sure to install the same version of the RML utilities on all machines.   ...
  • Blog Post: PRB: RML Utilities - ReadTrace and how to workaround MARS

    Summary We've lately gotten several questions from users regarding ReadTrace and how to workaround when your input trace files contain MARS (Multiple Active Result Sets).  ReadTrace currently does not support processing MARS and you will need to use one of the following two workarounds to continue...
  • Blog Post: 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 events.   The logical is indicated...
  • Blog Post: Filtering Trace Data Without Loading In Profiler or Database Table

    We are often asked how to extend the filtering of RML (ReadTrace/OStress) or Profiler.  Filtering during trace production is the preferred method because it typically reduces the overall impact of the Trace on the SQL Server throughput.   For late filtering you can generally use the Profiler...
  • Blog Post: INF: RML Utilities: Turning on Trace Flags

    Summary When using the RML utilities the logged message or documentation can indicate that use of a trace flag is necessary to change behavior. More Information The RML Utilities use command line parameter ( -T ) as a trace flag to alter the utilities behavior.  The term trace flag is a hold over...
  • Blog Post: PRB: RML Utilities - ReadTrace -M or -MF parameters cause processing to fail with SQL 2008 trace files

    Summary ReadTrace processing may unexpectedly stop with an assertion if you use the -M or -MF parameters with SQL 2008 trace files. Workaround Do not use the -M or -MF parameters with SQL 2008 trace files. More Information This problem is currently being investigated and I will post back with any updates...
  • Blog Post: INF: RML Utilities - You cannot use 9.01 Reporter against performance analysis database loaded by down-level ReadTrace

    Summary If you use the latest 9.01 release of Reporter and point to a performance analysis database that was loaded by a down-level version of ReadTrace, you may get errors about missing stored procedures such as the following: "Could not find stored procedure 'ReadTrace.usp_CheckSchemaVersion'"...
  • Blog Post: PRB: RML Utilities - Setup may Always Prompt for Report Viewer 2008 Redistributable

    Summary In rare circumstances on systems with UAC enabled, setup of Cumulative Update 1 of the RML Utilities may continue to prompt you for the Microsoft Report Viewer 2008 Redistributable (SP1 or later) even after you have already installed the redistributable: “The RML Utilities require the Microsoft...
  • Blog Post: Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released

        Version 9.01 of the RML Utilities for Microsoft SQL Server has been released.  This release of the RML Utilities provides support for SQL Server 2000, SQL Server 2005 and SQL Server 2008.  Additionally this release of the RML Utilities for SQL Server contains important software...
  • Blog Post: RML Utilities: ReadTrace may encounter assertion building the partial aggregates

    Summary In rare circumstances ReadTrace may encounter the following SQL Server 2008 assertion error when attempting to execute a parallel query. 11/03/08 00:05:35.139 [0X00003B94] Dumping error record 1 of 2: 11/03/08 00:05:35.139 [0X00003B94] --------------------------------------------------------...
Page 1 of 2 (28 items) 12