In this release, a whole bunch of stuff.
sp_QuickieStore:
The main updates to the code are to:
- Add support for SQL Server 2022 views
- Add the ability to search by query hash, plan hash, and SQL handle
The new search functionality is really important though, at least for how I use sp_QuickieStore much of the time. Often, you'll find hashes and handles in other parts of the database:
- Plan cache
- Deadlock XML
- Blocked process report
- Query plans
/*Search by query hashes*/
EXEC dbo.sp_QuickieStore
@include_query_hashes = '0x1AB614B461F4D769,0x1CD777B461F4D769';
/*Search by plan hashes*/
EXEC dbo.sp_QuickieStore
@include_plan_hashes = '0x6B84B820B8B38564,0x6B84B999D7B38564';
/*Search by SQL Handles*/
EXEC dbo.sp_QuickieStore
@include_sql_handles =
'0x0900F46AC89E66DF744C8A0AD4FD3D3306B90000000000000000000000000000000000000000000000000000,0x0200000AC89E66DF744C8A0AD4FD3D3306B90000000000000000000000000000000000000000000000000000';
Other minor updates:
- Improve the help section
- Improve code comments throughout
- Remove the filter to only show successful executions (sometimes you need to find queries that timed out or something)
- If you filter on any hash or handle, I'll display that in the final output so they're easy to identify
- Replace TRY_CONVERT with TRY_CAST, which throws errors in fewer circumstances
sp_PressureDetector:
I've added a few small things:
- Total physical memory in the server (not just max server memory)
- CPU details (NUMA nodes, schedulers; if they're off line, etc.)
- A debug mode for the dynamic SQL
The CPU details column is an XML clickable that looks like this:
<cpu_details> <offline_cpus>0</offline_cpus> <cpu_count>8</cpu_count> <hyperthread_ratio>8</hyperthread_ratio> <softnuma_configuration_desc>OFF</softnuma_configuration_desc> <socket_count>1</socket_count> <cores_per_socket>4</cores_per_socket> <socket_count>1</socket_count> </cpu_details>
sp_HumanEvents:
Bug Fixes And Performance Improvements
Okay, so just one bug fix, and then a bunch of tidying up and tiny tweaks to hopefully make your life easier.
Enjoy!