Are My Statistics Correct?

The question is often “Are my statistics up-to-date?” which can be a bit misleading.   I can make sure I have up-to-date statistics but the statistics may not be accurate.  I recently engaged in an issue where the statistics were rebuilt nightly.   A maintenance job change had been made moving from FULLSCAN to WITH SAMPLE statistics…

1

Pssdiag Manager update 12.0.0.1001 released

We just released a pssdiag Manager update to codeplex. Where to download You can download both binary and source code at http://diagmanager.codeplex.com/. What’s New This version support SQL Server 2012 and 2014 Requirements Diag Manager requirements Windows 7 or above (32 or 63 bit) .NET framework 2.0 installed Data collection The collector can only run…

4

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

SQL Nexus 4.0 Released to codeplex

  We have just released SQL Nexus 4.0 (https://sqlnexus.codeplex.com/) which supports latest SQL Server (2012) with enhanced reports.  In addition to read release notes, make sure you also read the top issues. Please report any issues under the Issues page under https://sqlnexus.codeplex.com/. New Release Notes (4.0.0.64): You must meet the following requirements: Operation systems supported:…

2

Interpreting the counter values from sys.dm_os_performance_counters

The performance counters exposed by SQL Server are invaluable tools for monitoring various aspects of the instance health. The counter data is exposed as a shared memory object for the windows performance monitoring tools to query. It is also available as a Dynamic Management View (DMV) within SQL Server, namely, sys.dm_os_performance_counters. The VIEW SERVER STATE…

1

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

How It Works: sys.dm_io_pending_io_requests

I have been working an issue where the DMV was returning io_pending_ms_ticks incorrectly.  The following output is an example of ~164 hour delay. Unlikely to occur without any other side effects noted. select * from sys.dm_io_pending_io_requests In the process of this investigation I uncovered several details that I found helpful to share. Full Text and…

3

Tracking Down Missing Indexes in SQL Azure

One of the challenges of SQL Azure is that not all of the TSQL that you are used to using is supported yet.  Since the underlying engine is plain ole’ SQL Server, the engine can understand the TSQL, but we just block its use because we haven’t yet made it work in the multi-tenant, multi-server…

7