Category: Uncategorized
-
Monitoring SQL Server Deadlocks using Extended Events
Extended Events were first introduced in SQL Server 2008, and therefore you will not face any problem implementing them in our environment. Extended Events is a lightweight performance monitoring feature that enables users to collect data to monitor and troubleshoot problems. A deadlock is a situation where two or more processes or threads are blocked indefinitely,…
//
-
Process ##:#:# (0x1aac) Worker #### appears to be non-yielding on Scheduler #.
The error message “Worker appears to be non-yielding on Scheduler” in SQL Server typically indicates a performance issue where a worker thread is stuck and not yielding CPU time back to the scheduler. This can lead to performance degradation, blocking, or even system instability. Possible Causes of the Non-Yielding Scheduler Issue Long-Running Query or Blocking…
//
-
Template for formatting Requirements for font size, style, and type and spacing, changing the Default Paragraphs Styles
Section 1: Format Requirement for font size, style, and type and Spacing Font size, style, and type: · The font must be a Standard style that is clear and readable. · All document text with the exception of item embedded in figures must be black. · Font size should be…
//
-
Read a big file using PowerShell
# Command-Format: Get-Content ‘your-file-path’ -Tail <number-of-line>Get-Content ‘.\mylargefile.txt’ -Tail 5000 # Get-Content D:\MyBigFeedFile.txt | Select-Object -skip 123798766555672 -first 6
//