alivarzeshi’s gists

alivarzeshi / Optimizing WordPress performance.txt

Last active September 21, 2024 21:06

Optimizing WordPress performance

alivarzeshi / prevent split-brain scenarios.txt

Last active July 5, 2024 08:56

What strategies does WSFC use to prevent split-brain scenarios?

alivarzeshi / SQL_Server_Error_Logs_Part_01.txt

Last active June 21, 2024 22:08

	Date/Time: 2023-06-22 09:00:00
	Log Level: Information
	Source: SQL Server
	Message: Database 'MyNewDatabase' was created by user 'admin'.


	Date/Time: 2023-06-22 10:00:00
	Log Level: Information
	Source: SQL Server
	Message: Database 'OldDatabase' was deleted by user 'admin'.

alivarzeshi / SQL_Server_Error_Logs_Part_09.txt

Last active June 21, 2024 22:02

	Date/Time: 2023-06-22 17:00:00
	Log Level: Information
	Source: Custom Application
	Message: Custom log entry from Application X: Task completed successfully.


	Date/Time: 2023-06-22 17:30:00
	Log Level: Information
	Source: Third-Party Tool
	Message: Backup completed by Third-Party Backup Tool. Database: MyDatabase, Backup Location: C:\Backups\MyDatabase.bak.

alivarzeshi / SQL_Server_Error_Logs_Part_08.txt

Last active June 21, 2024 22:02

	Date/Time: 2023-06-22 14:00:00
	Log Level: Warning
	Source: SQL Server
	Message: High CPU usage detected. SQL Server is utilizing 90% of the available CPU resources.


	Date/Time: 2023-06-22 14:30:00
	Log Level: Warning
	Source: SQL Server
	Message: SQL Server has detected memory pressure. The buffer cache hit ratio is below the recommended threshold.

alivarzeshi / SQL_Server_Error_Logs_Part_07.txt

Created June 21, 2024 21:56

	Date/Time: 2023-06-22 08:00:00
	Log Level: Information
	Source: Replication
	Message: Publication 'SalesDataPublication' was created successfully.


	Date/Time: 2023-06-22 09:00:00
	Log Level: Information
	Source: Replication
	Message: Subscription to publication 'SalesDataPublication' was initialized successfully for subscriber 'SubscriberServer'.

alivarzeshi / SQL_Server_Error_Logs_Part_06.txt

Last active June 21, 2024 21:55

	Date/Time: 2023-06-22 10:23:54.32
	Log Level: Information
	Source: Always On
	Message: The state of the availability group 'AG1' has changed from 'RESOLVING' to 'PRIMARY'.


	Date/Time: 2023-06-22 10:25:03.78
	Log Level: Warning
	Source: Always On
	Message: An automatic failover occurred in availability group 'AG1'. The primary replica is now 'Replica

alivarzeshi / SQL_Server_Error_Logs_Part_05.txt

Created June 21, 2024 21:42

	Date/Time: 2023-03-03 09:00:00
	Log Level: Information
	Source: SQL Server
	Message: Login succeeded for user 'username'. Connection: Non-Trusted.


	Date/Time: 2023-03-03 09:05:00
	Log Level: Error
	Source: SQL Server
	Message: Login failed for user 'username'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]

alivarzeshi / SQL_Server_Error_Logs_Part_04.txt

Created June 21, 2024 21:40

	Date/Time: 2023-03-03 10:00:00
	Log Level: Information
	Source: Backup
	Message: Database backed up. Database: MyDatabase, creation date(time): 2023/02/02(14:00:00), pages dumped: 350, first LSN: 73000000009200037, last LSN: 73000000009600001, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Backups\MyDatabase.bak'}).


	Date/Time: 2023-03-03 11:00:00
	Log Level: Information
	Source: Restore
	Message: Database restored. Database: MyDatabase, backup start date(time): 2023/03/03(10:00:00), backup end date(time): 2023/03/03(10:30:00), number of backup devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Backups\MyDatabase.bak'}).

alivarzeshi / SQL_Server_Error_Logs_Part_03.txt

Created June 21, 2024 21:35

	Date/Time: 2023-03-03 09:00:00
	Log Level: Information
	Source: SQL Server
	Message: Database 'MyNewDatabase' created successfully.
	Database Name: MyNewDatabase
	Event ID: 1800


	Date/Time: 2023-03-03 10:00:00
	Log Level: Information

Ali varzeshi alivarzeshi