search

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
356 stars 101 forks source link

Add columns in TextRowsets.xml for sys.dm_tran_persistent_version_store_stats and sys.dm_tran_aborted_transactions #168

Closed gambit9009 closed 2 years ago

gambit9009 commented 2 years ago

PSSdiag issue #44 (https://github.com/microsoft/DiagManager/issues/44) is adding these tables.

select From sys.dm_tran_persistent_version_store_stats select From sys.dm_tran_aborted_transactions

Add those columns in Nexus

gambit9009 commented 2 years ago

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-aborted-transactions?view=sql-server-ver16 https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-persistent-version-store-stats?view=sql-server-ver16

PiJoCoder commented 2 years ago

tested