MS-SQL Server - Azure Guidance for Sarbanes Oxley (SOX)

Azure Guidance for Sarbanes Oxley (SOX).

https://azure.microsoft.com/en-in/resources/microsoft-azure-guidance-for-sarbanes-oxley-sox/

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors

Additionally,

Long Running jobs

https://learn.microsoft.com/en-us/answers/questions/231173/long-running-sql-jobs

Waittypes

CXPACKET

THREADPOOL

WRITE_COMPLETION

PARALLEL_BACKUP_QUEUE

SQLCLR_QUANTUM_PUNISHMENT

WAIT_XTP_RECOVERY

FT_IFTS_RWLOCK

FT_IFTS_SCHEDULER_IDLE_WAIT

BROKER_ENDPOINT_STATE_MUTEX

BUILTIN_HASHKEY_MUTEX

QUERY_NOTIFICATION_UNITTEST_MUTEX

Internal Use

ASYNC_OP_CONTEXT_WRITE

PREEMPTIVE_OLE_UNINIT

A Fix of 98% RAM used by SQL Server

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8bf8be70-ecb9-476e-93bc-528d77c14edb/sql-server-is-using-98-of-ram?forum=sqldatabaseengine

ALTER DATABASE [MyDatabase] SET PAGE_VERIFY CHECKSUM WITH NO_WAIT;

https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/set-the-page-verify-database-option-to-checksum?view=sql-server-ver16

Hierarchyid to a String

https://learn.microsoft.com/en-us/sql/t-sql/data-types/tostring-database-engine?view=sql-server-ver16

Failover Clustering and Always On

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver16

Best Regards

T. Amit Vaid S.