Josiah Siegel JosiahSiegel
🌌
JosiahSiegel
/ azure_sql_quick_analysis.sql
Last active
October 11, 2024 17:51
Azure SQL Quick Analysis
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| req.session_id AS [session], | |
| ses.program_name AS [program], | |
| sqltext.TEXT AS [query], | |
| DB_NAME(req.database_id) AS [database], | |
| req.status, | |
| wg.name AS [resource_group], | |
| req.command, | |
| CONVERT(varchar(10), (req.cpu_time / 86400000)) + ':' + | |
| CONVERT(varchar(10), ((req.cpu_time % 86400000) / 3600000)) + ':' + |
OlderNewer