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 and 2014 fix release.

Summary

This update adds a new extended event hash_spill_details. This new extended event contains the following columns (event fields).

Column

Type

Description

query_operation_node_id

UInt(32)

Identifies the node ID of the operation that causes the hash spill

thread_id

UInt(32)

Identifies worker thread ID which matches to showplan thread ID

dop

UInt(32)

Degree of parallelism

granted_memory_kb

UInt(64)

Granted memory in KB

used_memory_kb

UInt(64)

Used memory in KB

workfile_physical_reads

UInt(64)

Number of pages read from workfile

workfile_physical_writes

UInt(64)

Number of pages written to workfile

worktable_physical_reads

UInt(64)

Number of pages read from worktable

worktable_physical_writes

UInt(64)

Number of pages written to worktable

actual_row_count

UInt(64)

Actual number of processed rows



This update also adds the following columns (event fields) to the following existing extended events.

sort_warning

Column

Type

Description

thread_id

UInt32

Identifies worker thread ID which matches to showplan thread ID

dop

UInt32

Degree of parallelism.

granted_memory_kb

UInt64

Granted memory in KB

used_memory_kb

UInt64

Used memory in KB

worktable_physical_reads

UInt64

Number of pages read from worktable

worktable_physical_writes

UInt64

Number of pages written to worktable

actual_row_count

UInt64

Actual number of sorted rows


hash_warning

Column

Type

Description

thread_id

UInt32

Identifies worker thread ID that matches the showplan thread ID

dop

UInt32

Degree of parallelism

granted_memory_kb

UInt64

Granted memory in KB

used_memory_kb

UInt64

Used memory in KB

workfile_physical_writes

UInt64

Number of pages written to workfile

worktable_physical_writes

UInt64

Number of pages written to worktable

actual_row_count

UInt64

Actual number of processed rows


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 Server

Service 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

References

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×