This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.
2021-12-24 (first published: 2019-12-02)
11,433 reads
A diagnostic tool for identifying Performance features of active SQL Queries. It collects performance detail from DMVs for queries with executing requests and is designed to demonstrate and quantify Query Shaping optimisation techniques by: quantifying query workload and throughput characteristics providing behavioural descriptors of potential performance inhibitors - refer column ThrottlePotential The ThrottlePotential column is […]
2019-11-07
4,066 reads
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
I have query which is filling TEMPDB I need suggestion how to modify this...
I have query which is filling TEMPDB I need suggestion how to modify this...
Hello, We recently made the following observation working with VS2022 combined with the SSIS...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers