Microsoft distributes Microsoft SQL Server 2012 and 2014 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release.

Summary

This update makes the following changes to the Showplan XML schema:

  • Adds the following new attribute to the SpillToTempDbType complex type. This is referenced by the SpillToTempDb element of the WarningsType complex type.

    Attribute

    Type

    Description

    SpilledThreadCount

    Xsd:unisignedLong

    Total amount of spilled threads.

  • Adds the following new complex types to the XML schema.

    Complex Type

    SortSpillDetailsType

    HashSpillDetailsType

  • Adds the following new elements to the WarningsType complex type:

    Element

    Type

    Description

    SortSpillDetails

    Shp:SortSpillDetailsType

    References to the SortSpillDetailsType complex type.

    HashSpillDetails

    Shp:SortSpillDetailsType

    References to the HashSpillDetailsType complex type.

    SortSpillDetailsType This is referenced by the SortSpillDetails element contains the following attributes.

    Complex Type

    Type

    Description

    GrantedMemoryKb

    Xsd:unsignedLong

    Total amount of memory actually granted in kilobytes.

    UsedMemoryKb

    Xsd:unsignedLong

    Physical memory used at this moment in kilobytes.

    WritesToTempDb

    Xsd:unisignedLong

    Include both worktable and workfile IO as one counter.

    ReadsFromTempDb

    Xsd:unisignedLong

    Include both worktable and workfile IO as one counter.

    • SortSpillDetailsType: This is referenced by the SortSpillDetails element, contains the following attributes.

    • HashSpillDetailsType: This is referenced by the HashSpillDetails element and contains the following attributes.The newly added HashSpillDetailsType complex type that's referenced by the HashSpillDetails element contains the following attributes:

      Complex Type

      Type

      Description

      GrantedMemoryKb

      Xsd:unsignedLong

      Total amount of memory actually granted in kilobytes.

      UsedMemoryKb

      Xsd:unsignedLong

      Physical memory used at this moment in kilobytes.

      WritesToTempDb

      Xsd:unisignedLong

      Include both worktable and workfile IO as one counter.

      ReadsFromTempDb

      Xsd:unisignedLong

      Include both worktable and workfile IO as one counter.

Note After you apply this update, the Showplan XML schema is available with the SQL Server installation files at the following location:

C:\Program Files\Microsoft SQL Server\110\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsd

Resolution

This functionality was fist introduced in the following Service Packs for SQL Server. 

For more information about SQL Server 2012 Service Pack 3 (SP3), see bugs that are fixed in SQL Server 2012 Service Pack 3.

Service Pack 2 for SQL Server for SQL Server 2014About Service packs for SQL ServerService packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. Our recommendation is to apply the latest service pack and the latest cumulative update for that service pack. You do not have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article for finding more information about the latest service pack and latest cumulative update.How to determine the version, edition and update level of SQL Server and its components

More Information

The memory grant information and the storage I/O information that was mentioned earlier is also available in the Warning section of the tooltip for the Sort operation or the Hash operation in the graphical execution plan output in SQL Server Management Studio. Additionally, the same information is also available in the Warning section of the Properties window of the Sort operation or the Hash operation.Note This information is available only when the SET STATISTICS XML option is set ON.Sort Hash Match

References

Learn about the terminology that Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.