0

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.

princy
  • 3
  • 2

1 Answers1

0

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.

Community
  • 1
  • 1
GregGalloway
  • 11,355
  • 3
  • 16
  • 47