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 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
References
Learn about the terminology that Microsoft uses to describe software updates.
