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
348 stars 99 forks source link

Import the systeminfo file from SQL LogScout and Pssdiag - add XML rowset #245

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

Something like this (prototype)

-- Windows System Info -- 
Config option              Value
-------------------------- -------------------------------------------------------------------------------------
Host Name:                 MYMACHINE
OS Name:                   Microsoft Windows 11 Enterprise
OS Version:                10.0.22621 N/A Build 22621
OS Manufacturer:           Microsoft Corporation
OS Configuration:          Standalone Workstation
OS Build Type:             Multiprocessor Free
Registered Owner:          N/A
Registered Organization:   N/A
Original Install Date:     10/5/2022, 12:44:17 AM
System Boot Time:          8/8/2023, 6:24:48 PM
System Manufacturer:       IBM
System Type:               x64-based PC
hacitandogan commented 1 year ago

@PiJoCoder we have one rowset , reading identifier -- system_info -- and filling tbl_SystemInformation. Do we have a different goal on this ?

image
PiJoCoder commented 1 year ago

Excellent point. We did get this done previously. We just need to get the output right in SQL LogScout. Only available in PSSDIAG currently. Thanks!