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 rows inserted, lines processed and other information in the sqlnexus001.log for debugging #147

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

Discovered it is already present in the log. For example:

SQLNexus Information: 0 : (Importer:Rowset Importer) Done. (0 sec, 0MB), 77 lines processed; 2 rows inserted. DateTime=2023-01-25T05:35:39.4507213Z

SQLNexus Information: 0 : (Importer:Rowset Importer) Done. (0 sec, 0MB), 393 lines processed; 389 rows inserted. DateTime=2023-01-25T05:35:39.4867935Z