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: Kerberos Configuration Manager updated for Analysis Services and SQL 2014

    Kerberos Configuration Manager was released back in May of 2013.  It initially released with only SQL Server support . This was followed up with support for Reporting Services in November 2013. You can download the latest release from the following link: Microsoft® Kerberos Configuration Manager...
  • 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: Can’t Connect to SQL when provisioning a Project App in SharePoint

    The customers issue was that they were trying to provision a Project site within the Project SharePoint Application. This was done via a PowerShell script that they ran on one of the SharePoint App Servers. They had two SharePoint App Servers – AppServerA and AppServerB. They had indicated that the provisioning...
  • Blog Post: DReplay Message: “Active connections exceed 8192, connection 8409 is waiting.”

    This message was an interesting dive into the DReplay, session boundary logic that I thought I would share.  Internally DReplay maintains a progressive, session queue.  This queue is limited to 8192 entries and populated in connection replay order based on the connect/disconnect boundaries...
  • Blog Post: SQLIOSim Checksum Validations

    I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic.  It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the data and do the comparison.   1.     ...
  • Blog Post: SQL Server: Correlating Timestamps From Various Data Points

    I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging.   Some times are local to the SQL Server instance, others UTC and yet other utilities...
  • Blog Post: Management Studio tricks you may or may not know about

    I was sitting through SQL Server 2012 training, and Ajay Jagannathan was showing us Management Studio.  Eric Burgess had worked on this topic.  He started covering some neat things, that have apparently been there for a while, but I just never played around with it enough to see what all you...
  • Blog Post: Pssdiag/Sqldiag Configuration Manager released to codeplex

      A lot of you are probably familiar with pssdiag tool released for SQL Server 7.0 and 2000 and sqldiag.exe utility shipped with SQL Server 2005, 2008 and 2008 R2. These are data collection diagnostics tools that allow collecting data such as profiler trace, perfmon and DMV information. For sqldiag...
  • 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: SQLIOSim - Is Error: Unable to get disk cache info really an error?

    The short answer is that it is not an error and the message should be a WARNING. I looked at the latest, internal code base it has already been changed to a WARNING. if (!DeviceIoControl (volume, IOCTL_DISK_GET_CACHE_INFORMATION, NULL, 0, &m_diskCacheInfo, sizeof (m_diskCacheInfo), &dwBytes,...
  • Blog Post: It helps to read the “What’s New…” once in a while

    In the course of my job, I use ADPlus (a command-line tool that ships with Debugging Tools for Windows) to capture hang dumps on a regular basis.  For both low and high CPU scenarios, I generally need 2-3 hang dumps spaced out over about 10 minutes.  Historically, I have always given customers...
  • Blog Post: Did you start your SQL Server Engine correctly?

    Often we run into situations where there is a need to add a trace flag or a startup parameter other than the default startup parameters that SQL Server uses. What you may notice sometimes is that even after adding these parameters/flags, the desired behavior from those parameters/flags does not occur...
  • Blog Post: How It Works: SQLIOSim CTRL+C vs Close Window

    Today I had an interesting question about the CTRL+C handler for the SQLIOSim console execution.    After some investigation I found that a design change request is in order as the CTRL+C handler has a few holes-  (I am working on that part). The CTRL+C handler does not prompt you...
  • Blog Post: How It Works: Controlling SQL Server memory dumps

    I just completed a lengthy bit of research and thought I would share it with everyone.   There are several trace flags and registry keys outlined in this post.    !!! As always USE WITH APPROPRIATE CAUTION !!!   From: Robert Dorr Sent: Tuesday, November 17, 2009 3:23 PM...
  • Blog Post: RDTSCTest CPU Speed Output Clarified

    Starting with SQL Server 2005 SP3 and SQL Server 2008 the RDTSC counter is not used for timing in SQL Server but you may still have occasion to use RDTSCTest.   From: Robert Dorr Sent: Thursday, June 04, 2009 4:14 PM Subject: RE: SQL Troubleshooting - RDTSC   In the registry the speed is stored...
  • Blog Post: Troubleshooting sp_xp_cmdshell_proxy_account Errors

    I was attempting to establish the command shell proxy on my local machine and ran into a series of errors.   As I looked at them more I decided to file some work items with the SQL dev team to provide better context in the message text.   I hope this post will help provide some insight...
  • Blog Post: SQL 2005: SQL Server Configuration Manager Error: Connection to target machine could not be made in a timely fasion.

    There is a bug with the message spelling (fasion instead of fashion) but that is not the focus of this post. When launching the SQL Server Configuration Manager you may receive this message if the WMI connections and queries do not complete within 30 seconds.   For the customer case I just...
  • 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: WMI Provider Error Access is denied - while changing SQL Server account password

    Recently one of our blog readers reported that when they tried to change the SQL Server account password in SQL Server Configuration Manager they were getting "WMI Provider Error Access is denied [0x80070005]".  This was happening on two separate Windows Server 2008 machines that were...
  • 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: Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures

    This is an extension to by previous post about SQLIOSim data integrity testing. http://blogs.msdn.com/psssql/archive/2008/03/05/how-it-works-sqliosim-checksums.aspx SQLIOSim (.exe/.com) is the predecessor to SQLIOStress.   SQLIOSim is SQL Server independent utility, generating both SQL Server and...
  • Blog Post: How It Works: SQLIOSim - Running Average, Target Duration, Discarded Buffers ...

    The following is from a lengthy conversation I had with Kevin Kline.  I believe he will be posting more details along with his "Understanding SQLIOSim Output - http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx )   ********** Final Summary for file...
  • Blog Post: How it Works: SQL Command Mode Parsing

    I ran across a teaser this week that makes for a interesting blog post.  SQL Server uses a common batch parser for the SQLCMD, OSQL, SSMS Query Window in Command mode and various other locations. The primary job of this parser is to identify GO delimited batches.  However, it can also identify...
  • Blog Post: SQL Server 2008 Management Tools Basic vs Complete Explained....

    A few questions have come up about the differences between the features you can install on SQL Server 2008 called Management Tools - Basic   and Management Tools - Complete. So I thought I'd blog about these to resolve any questions you might have. Related to this are questions I've received on...
  • Blog Post: How It Works: SQLIOSim [Audit Users] and .INI Control File Sections with User Count Options

    The Page Audit User is one of the main execution paths for data integrity checking.   SQLIOSim runs test cycles and during each test cycle the [Audit User] section of the .INI configuration file is used.  These workers perform various page audit actives. After the cycle completes SQLIOSim...
Page 1 of 2 (35 items) 12