microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
MIT License
348 stars 99 forks source link

New xml rowsets for In-Memory OLTP and memory #253

Closed asavioliMSFT closed 12 months ago

asavioliMSFT commented 1 year ago

Adding nem in-memory related tables to Nexus (related to Log Scout tasks 502 and 453). Also included on this PR to old tables that were not being loaded: tbl_proccache_summary and tbl_proccache_pollution

How to test:

https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/sample-database-for-in-memory-oltp?view=sql-server-ver16

select * from dbo.tbl_proccache_summary

select * from dbo.tbl_proccache_pollution

select * from tbl_dm_db_xtp_index_stats

select * from tbl_dm_db_xtp_hash_index_stats

select * from tbl_dm_db_xtp_table_memory_stats

select * from tbl_dm_db_xtp_memory_consumers

select * from tbl_dm_db_xtp_object_stats

select * from tbl_dm_xtp_system_memory_consumers

select * from tbl_dm_xtp_system_memory_consumers_summary

select * from tbl_dm_xtp_gc_stats

select * from tbl_dm_xtp_gc_queue_stats

select * from tbl_dm_db_xtp_transactions

select * from tbl_dm_xtp_transaction_stats