Skip to content

SQL LogScout version 5.23.06.06
Compare
Choose a tag to compare
@PiJoCoder PiJoCoder released this 16 Jun 20:03
· 12 commits to main since this release
v5.23.06.06
74af3ed
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.

Download

Scroll down to the bottom of this page and find the Assets section. Expand it and select SQL_LogScout_v5.23.06.06_Signed.zip to download it

Verify downloaded file:

You can verify the download by computing the hash of the SQL_LogScout_5.23.06.06_Signed.zip file, using this command:

certutil -hashfile SQL_LogScout_5.23.06.06_Signed.zip SHA512

Compare to this:

b0516098ecc4688da01f9965ccf5eab5432f5988dbd1941222f935990d56444f772082db7a2ab590da118d3b90ea835cb2256737e40d157f54a475657110dd28

Enhancements

  • Update Network trace scenario - optimize shutdown and remove .bat files
  • Increase the output size for variable data types from T-SQL scripts to 512 from default 256 in SQLCMD calls -y parameter
  • Incorporate the Lease and HealthCheck timeout values in SQLLogScout collection
  • Move all files except SQL_LogScout.cmd into a subfolder to make it easy to invoke
  • Allow user to select and de-select entire group of Xevents in the GUI
  • Get disk and LUN information in Basic scenario
  • Gather logs for Azure Arc Enabled SQL Server as part of Basic scenario
  • Refactor Testing infrastructure items - rename or remove files, improve output in test files, better SQL Nexus testing
  • Create a T-SQL workload that we can run with Testing Infrastructure suites while testing various scenarios (GeneralPerf, DetailedPerf, LightPerf)
  • Limit the number of ERRORLOGs collected from a system that has tens/hundreds of them
  • Ensure that heavy collectors are stopped first upon SQL LogScout shutdown (Xevents, Procmon, Storport Wpr, Netmon)
  • Update the Readme.md file to state that SQL LogScout should be executed on a fast drive
  • Collect installation related registry keys in the Setup Scenario
  • Improve error message when SQL LogScout fails due to connectivity issues
  • Document issues caused by non-alpha characters in folder names
  • Introduce conditional checks for file existence in testing infrastructure
  • Uniform formatting of messages when a collector is not invoked due to missing component (Assessment API and Azure Arc)
  • Optimize the shutdown of Network trace - make it asynchronous to shutdown with other processes running
  • Refactor StartNewProcess to return the process object and also handle the output when parent call does not use the return
  • Update Query Store (QDS) script with additional DMVs including some from SQL 2022
  • Capture DBCC LOGINFO or sys.dm_db_log_info information to help troubleshoot VLF issues
  • Capture Perfmon for a short duration in Basic Scenario
  • Capture top 10 high-CPU query plans in XML format (.plan)
  • Collect the last 2 months SQL memory dumps form the \Log folder, no greater than 50 MB in size
  • Prompt user to delete job or inform them that the job is retained - ScheduleSQLLogScoutAsTask
  • Enable option to "run if user is not logged in" - ScheduleSQLLogScoutAsTask
  • Rename the Testing infra logs to have the datetime at the end of file name
  • Improve the logging information for file validation outputs
  • Disable "Do you want to use GUI" prompt if Scenario, ServerName, CustomOutputPath and DeleteExistingOrCreateNew parameters are passed (not null)
  • Create conditional exclusions for SQLNexus related tables in TestingInfrastucture component
  • Update the Readme file that we capture QDS (Query Store) info with Perf scenarios
  • Refactor sqlnexus_tablecheck_proc.sql to insert rows only once for Basic scenario
  • Optimizations in Testing infrastructure when calling Get-Content with Select-String in FileCountAndTypeValidation.ps1
  • Create a test infra exclusion for Backup Restore scenario for Xevent on SQL 2014 or less
  • Create a test infra exclusion for AlwaysOn data movement scenario for Xevent on SQL 2014 SP2 or less
  • Rename the file validation test file by adding abbreviations to file name to be able to identify the scenarios that ran
  • Add parameter to ScheduleSQLLogscoutTask on whether User is Logged In or Not
  • Updated Perf Stats scripts to support SQL Server 2022
  • Improve SQLNexus_Test.ps1 logging to capture scenarios where Nexus failed or SQLCMD failed
  • Introduce a Scenarios parameter to ConsistentQualityTesting to allow for individual scenario testing
  • Refactor Testing Infrastructure - simplify code, remove un-needed components, reorganize
  • Created video training for diagnosing Always On Lease Timeout with SQL LogScout
  • Cleanup queries with string filtering to improve performance
  • Allow PowerPlan output to be imported into SQL Nexus by adding an identifier
  • Get IP Config, TCP and UDP endpoint info, and DNS cache info
  • Print the entire Summary.txt output on screen after ConsistentQualityTesting has completed at the end
  • Move the cluster log collection from Basic to Always On scenario.
  • Add tables and create exclusions in testing infrastructure for the QDS rowsets
  • Add exclusion for cluster log testing on systems that are not WSFC
  • Generate XML file required for AlwaysOn Data movement Xevent analysis
  • Add CTRL+C functionality in the function that generates Cluster logs to increase chance to cancel in case it's too long

Fixes

  • GUI: Made all the Perfmon and Xevent checkboxes disabled (grayed out) when no scenario is selected
  • Enabled Quiet mode for Replication Scenario
  • Changed Readme to better document DoProcmonTest parameter
  • Fixed WPR scenario failure on Windows Server 2016/2019 due to unsupported -skippdbgen parameter
  • Created UX consistency between GUI and command-line with regard to \output and \output_ddMMyyhhmmss folders
  • Fixed Perfmon .BLGs taking a long time to import in SQL Nexus as compared to BLGs from PSSDIAG due to Thread object being present
  • Fixed issue with output file names containing gibberish instead of datetime when using PS 4.0
  • Fixed issue where Xevent session [xevent_SQLLogScout] gets created but doesn't get started when GeneralPerf +AlwaysOn scenarios are run together
  • Fixed issue where CleanupIncompleteShutdown.ps1 prints only the first character of an instance name on Win 2012 R2
  • Resolve XTP Perfmon counters differences between versions 2016, 2017, 2019, 2022
  • Detailed Xevent scenario incorrectly enables xevent_core instead of xevent_detailed when global:xevent_on = true
  • Fixed issue where AlwaysOn scenario does not collect 'Basic' logs by default
  • Improved -daily switch behavior of ScheduleSQLLogScoutAsTask
  • RunIndividualTest.bat reports no results when run against any 2-digit scenario such as LightPerf, IO, BackupRestore
  • Resolve minor issue with sys.database_scoped_configurations columns to ensure that this can be imported in SQL Nexus tables
  • Fixed tests where IO+NoBasic, Memory+NoBasic incorrectly report missing files from the Basic scenario
  • Fixed testing issue where Network trace file validation incorrectly reports that Basic files are missing
  • Fixed issue where SQL Audit Xevents are not showing up in --XEvent Session Details-- output in MiscPssdiagInfo.out
  • Cleanup script not recognizing SQL FCI instances
  • Ensure that the memory grant diagnostic queries do not use memory grant themselves or will get stuck waiting
  • Perf Extended Events trace creation fails when you uncheck the ExistingConnection xevent in Core and file_write_completed xevent in AlwaysOn
  • Remove digital signature from GUIHandler.psm1 file in the code as this is handled during release.
  • Script collecting existing XE sessions is returning duplicate events
  • Fixed documentation: clarify that AlwaysOn scenario collects some core Xevents (RPC and Batch started and completed, login/logout, errors)
  • Fixed Xevent core not being stopped with AlwaysOn scenario during regular clean up
  • Fixed an issue with blank Instance name when SQL LogScout is executed on an OS with non-English language
  • Fixed issue with GetRunningDrivers on Windows with non-English Language
  • Fixed memory stats script failure on SQL 2022
Assets 3
Loading