qpi
qpi copied to clipboard
JocaPC
Query Performance Insight - analyze performance of your SQL Server Database Engine
Hi there, just realized there is a small errror in the view qpi.volumes, used_gb should be total_gb and total_gb should be used_gb while substracting available_bytes from total_bytes. CREATE VIEW qpi.volumes...
Column names in each view or function must be unique. Column name 'resourceGroup' in view or function 'diagnostics' is specified more than once. error in line 387 CREATE OR ALTER...
"nvarhar" rather than "nvarchar" is in the SQL code for the CREATE OR ALTER VIEW qpi.recommendations for Serverless SQL Pools. This causes the view to not return any recommendations if...
Isn't there a typo in snippet prefix in your extension ? There is the snippet with prefix "qpi:snapshot wait stats" calling "exec qpi.snapshot_wait_stats;" and second snippet with the same prefix...
https://github.com/JocaPC/qpi/blob/d483e9c826103e4092e36cd0c47ad65e04432b6c/build/qpi.tmpl.sql#L510 Hello, At end of this line, it seems there is missing comma (,).
Executing the SQL Server 2017+ installation script on a SQL Server 2019 database fails due to two invalid references to a nonexistent "auto_drop" column in two views.
When running the SQL Server 2017+ installation script on a SQL Server 2019 database, it fails due to two invalid references to a non-existing "auto_drop" column defined in two views....
Can you add a feature for transaction log size and growth history?
When running this sql: select top 50 start_time, [type] = execution_type_desc, [queries/s] = sum(count_executions)/ min(interval_mi) /60, [cpu %] = ROUND(100. * (sum(count_executions*cpu_time_ms) /1000.) / ( min(interval_mi) * 60) / (SELECT...
kind of a small thing, but the link to fabric installation seems missing in the installation page. While the installation code is there (in /src)
