Skip to content

SQL LogScout v6.24.02.18
Compare
Choose a tag to compare
@PiJoCoder PiJoCoder released this 19 Feb 01:08
· 6 commits to main since this release
v6.24.02.18
ac483ee
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.

Download

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

Verify downloaded file:

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

certutil -hashfile SQL_LogScout_v6.24.02.18_Signed.zip SHA512

Compare to this:

b5a41a93f147b19cc34eb7beb92acc776a51d45e05eb861a4744db77b44b59316710ccec27800755c5772faf664fa6c11220e7234b99ede81062952ee912fcee

Known Issue(s)

  1. When invoking SQL_LogScout as a scheduled task and passing the -Daily parameter, the first execution of LogScout will work properly but all subsequent attempts to launch SQL_LogScout will result in the execution to immediately terminate. Workaround is to use the -Once switch instead. We intend to fix this issue in the next release.

Enhancements

  • Create the Never-Ending Query scenario in SQL LogScout
  • Add a new scenario for Service Broker/Database Mail
  • Add support for diagnosing out-of-memory for memory-optimized tempdb collector
  • Refactor: Remove spaces in script file names like "Profiler Traces.sql", "Query Store", "SQL Server Perf Stats", "SQL Server Perf Stats Snapshot.sql"
  • Wrap T-SQL scripts in TRY..CATCH blocks to avoid overall script failures (Perfstat, High CPU queries, SQL_Server_Mem_Stats.sql)
  • Create offline option: enhance the Basic log scenario to get Errorlogs and configuration, and other SQL static logs when instances are stopped (offline)
  • SQLLogScout Code Refactor: Re-wrote multiple queries the MiscPSSDiagInfo.sql and renamed file to MiscDiagInfo.sql
  • Change new folder timestamp to use ISO format (yyyyMMddTHHmmss)
  • Add a function to detect whether the current instance is HADRenabled
  • Move capturing of loaded modules inside SQL Server from Perf scenarios to Basic scenario
  • Collect Exception.log as part of capturing dump information
  • Include the last 200 .txt files generated from memory dumps (SQLDump*.txt files)
  • Add collection of memory DMVs for In-Memory OTLP (XTP)
  • Add sys.dm_io_pending_io_requests to the High_IO_Perfstats.sql in the IO scenario
  • Add collection of Environment Variables in the Basic scenario
  • Add encryption to the SQLCMD connections -C -N to ensure traffic is protected over the wire when server supports encryption
  • Automate the test execution of Testing suite - have the Pipeline test upon every merge
  • Refactor: Remove GetErrorlogs() function and corresponding .sql file - as it's not used
  • Gather SQL VM configuration json file - Azure Instance Metadata Service
  • Examine the Pipeline sequence and ensure that PostAnalysis task is set in proper location and executed successfully
  • Update testing for SQL Nexus for XTP tables after they are introduced in SQL Nexus
  • Complete the Azure Pipeline to perform full suite testing. Include return values to mark task as failed if there's a failure in intermediate steps
  • Minor adjustments on the In-memory data collection from the SQL_Server_Mem_Stats script.
  • Make SystemInfo output importable into SQL Nexus
  • Change behavior to collect all Errorlog files regardless of file length (0 bytes or more)
  • Rename SQLAgent logs by appending servername to file name for consistency
  • Add support to collect dumps with new format name + compressed dumps
  • SQL Server dumps: increase size of memory dumps collected from 50 MB to 100 MB
  • Add the XTP memory scenario on the testing infrastructure
  • Integrate SQL Nexus in testing Pipeline - install components from command line
  • Add parallel compressed dumps as an option on the MemoryDump scenario
  • Collect sysaltfiles in MiscDiagInfo.sql for use with VSS non-component backup failures
  • Always attempt to collect SQLDUMPER_ERRORLOG
  • Create GUI for Service Broker and Database Mail scenario
  • Create Service Broker and DbMail testing for tables imported via SQL Nexus
  • Generate Software Bill of Materials (SBOM) in Pipeline
  • Add service status of SQL instance to SQL_LogScout GUI
  • Remove Service Broker-related Xevents from General and Detailed Perf scenarios as they are part of ServiceBroker scenario now
  • Skip the AG latency xevents and topology collection when isHADRenable = $false
  • Update Azure pipeline with a dynamic link for downloading SQLNexus (aka.ms)
  • Change the order SQL LogScout stops the T-SQL sessions - kill the sessions before Invoke-OnShutdown
  • Ensure testing infrastructure writes detailed output to screen when it fails for the purposes of Pipeline

Fixes

  • Fixed a test failure due to SQLAgent files not being present when SQL Agent service is not running
  • Fix arithmetic overflow error in memory script \SQL_Server_Mem_Stats.sql
  • Define the TCP and UDP Perfmon counters correctly to use TCPv4, TCPv6 and UDPv4 , UDPv6
  • Fix issue where /? or -help or -? causes an error instead of producing help menu and build a test for it
  • Fix issues with testing infrastructure logic with logs when \output folders missing
  • Fix Perfstats - there's a missing column alias for two SELECT statements
  • Fix UTC to local server time offset to be negative if time zone "before" UTC and positive if time zone "after" UTC
  • Fix SQLDUMPER_ERRORLOG.log was not being captured even though it's designed to do it
  • Fix issue where SQL \Log folder may be incorrectly constructed if the word "errorlog" is in the path name
  • Fix on the AG Topology XML data collector: duplicated file extension and blank space in the error output file.
  • Fix invocation of SQL_LogScout in testing infrastructure to use Start-Process instead of & call operator
  • Fix column name not using proper case in SQL Server Perf Stats Snapshot.sql script
  • Remove ucs.ucs_connection_rejected_by_proxy_whitelist Xevent from SSB scenario as it's not supported in SQL 2012 and not really needed
  • Fix failure to collect some data when Primary in AG is set to ReadWrite connections only and there's a secondary AG with read-intent only on same server
  • Fix error 'Write-LogInformation' is not recognized as the name of a cmdlet, function when SQL LogScout is terminated with CTRL+C
  • Fix a failure to collect Xevents when xevent_core is unchecked in the UI with scenarios that use Xevent_Core
  • Fix Azure Arc Logs zip may be empty in some cases
  • Fix differences between memory grant data sets in Perfstats script
  • Fix incorrect entry for Broker Activation perfmon counters in LogmanConfig.txt
  • Fix testing failure for Arc agent logs because file name not in the Basic scenario array
  • Fix Network Scenario collection failure due to connection string being empty
  • Update testing infrastructure to exclude files where isHADRenabled = $false
  • Fix Initialize-ScheduledTaskLog to use incorrect date format
  • Handle the Basic scenario more gracefully when invalid instance is passed as a parameter
  • Fix instance name in the list of instances to be in alphabetical order
  • Fix proccache_summary query in Memory scenario produces an arithmetic overflow error
  • AlwaysOn Test on SQL2019 AG instance failed with missing tables in the SQL Nexus db due to insufficient time to run LogScout
Assets 3
Loading