azure-synapsetempdbsql-data-warehouse

tempdb usage at Azure SQLDW

Can I track or get a report every 30 minutes to sum the tempdb usage by user id for AZureSQlDW?

Any suggestions are highly appreciated

Thanks, Cherishma.

Solution

  • This documentation page has a query that will return the info you need. It primarily uses the sys.dm_pdw_nodes_db_session_space_usage DMV. You could run that query and insert it to a table or CREATE EXTERNAL TABLE AS SELECT to export to files on some regular basis for later monitoring.