Cleanup data on some new imported tables: tbl_SystemInformation, tbl_ActiveProcesses_OS

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

Cleanup data on some new imported tables: tbl_SystemInformation, tbl_ActiveProcesses_OS #153

Closed gambit9009 closed 2 years ago

gambit9009 commented 2 years ago

tbl_SystemInformation remove : from Property col

tbl_ActiveProcesses_OS Mem Usage is text with "," and "K". For easier sorting or math work on memory used, remove those, divide by 1024 to get MB and store as a decimal in MemUsageMB.

gambit9009 commented 2 years ago

Associated with: 6c407717f5a2a31605055fc24c6bdd7c56e29efb