Error: DESCRIPTION: Always On Availability Groups transport has detected a missing log block for availability database “xxxxx”. LSN of last applied log block is (85862:908824:0). Log scan will be restarted to fix the issue. This is an informational message only. No user action is required. Low transaction throughput on Always On Availability Group primary replica... » read more
Problem: Job history window takes a long time or timeout. Fix: Make sure you purge the sql job history log. SQL Server Agent Properties -> History -> Check the 2 options. Note: “Remove agent history” is an one time event. Have to set the “Limit size of job history log” option to make it a... » read more
Trace flags are switches that adminstrators or developers can use to change the behavior of SQL Server. These are added by the development team, often to help debug or diagnose performance issues, according to BOL, but they are increasingly being used as feature flags to enable behavior that some customers may want, but Microsoft doesn’t want... » read more
Last Commit Redo Possible Fixes for Slow Sync Performance between Primary and Secondary Server Make sure Alwlays On is running without errors. Reboot the Always On secondary database server. Sources:
How do I set up a password on Excel files? This method only works with Windows 10 and beyond versions of Excel. Open up the Excel file you want to protect. Go to File. Then click on Info. Go to Protect Workbook. Then click on Encrypt with Password. Enter and confirm the password you want.... » read more
Fill a column with a series of numbers Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value in the next cell to establish a pattern. … Select the cells that contain the starting values. … Drag the fill handle. Sources: https://support.microsoft.com/en-us/office/automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6
Use Repo Brower to move files to retain log history of file. Method #1 – Copy files to new folder and delete files in old folder This will not retain history. Method #2 – Move and Drag files to new folder via Repo Brower This will retain history.
What Are Symbolic Links? Symbolic links are basically advanced shortcuts. Create a symbolic link to an individual file or folder, and that link will appear to be the same as the file or folder to Windows—even though it’s just a link pointing at the file or folder. For example, let’s say you have a program... » read more
https://docs.microsoft.com/en-us/sysinternals/downloads/rammap RAMMap v1.61 Article 05/11/2022 2 minutes to read 4 contributors By Mark Russinovich Published: May 11, 2022 Download RAMMap (671 KB)Run now from Sysinternals Live. Have you ever wondered exactly how Windows is assigning physical memory, how much file data is cached in RAM, or how much RAM is used by the kernel and device drivers? RAMMap... » read more