How to check MSSQL installation logs and how to set trace flags in MSSQL instance in HINDI

MSSQL ADMINISTRATION IN HINDI | MSSQL DBA CLASS IN HINDI | LEARN MSSQL IN HINDI — Common trace flags that should be enabled in most cases
— TF 1117 – When growing a data file, grow all files at the same time so they remain the same size, reducing allocation contention points
— https://bit.ly/2GY1kOl
—
— TF 1118 – Helps alleviate allocation contention in tempdb, SQL Server allocates full extents to each database object,
— thereby eliminating the contention on SGAM pages (more important with older versions of SQL Server)
— Recommendations to reduce allocation contention in SQL Server tempdb database
— https://bit.ly/2GY1kOl

— TF 460 – Improvement: Optional replacement for “String or binary data would be truncated” message with extended information in SQL Server 2017
— https://bit.ly/2sboMli (added in SP2 CU6)

— TF 2371 – Lowers auto update statistics threshold for large tables (on tables with more than 25,000 rows)
— https://bit.ly/2HySkAg

— TF 3226 – Supresses logging of successful database backup messages to the SQL Server Error Log
— https://bit.ly/2p6MTjS

— TF 3449 – Enables use of dirty page manager (SQL Server 2014 SP1 CU7 and later)
— https://bit.ly/2uj0h5M

— TF 6533 – Spatial performance improvements in SQL Server 2012 and 2014
— https://bit.ly/2v7C7ze

— TF 6534 – Enables use of native code to improve performance with spatial data
— https://bit.ly/2HrQUpU

— TF 8079 – Enables automatic soft-NUMA on systems with eight or more physical cores per NUMA node (with SQL Server 2014 SP2)
— https://bit.ly/29B7oR8

— TF 7745 – Prevents Query Store data from being written to disk in case of a failover or shutdown command
— https://bit.ly/2GU69Km

— TF 7752 – Enables asynchronous load of Query Store
— This allows a database to become online and queries to be executed before the Query Store has been fully recovered

— TF 2453 — Enables actual rows for table variables
— TF 1222 — Log Deadlock information to SQL Server Error Log

— DBCC TRACEON – Trace Flags (Transact-SQL)
— https://bit.ly/2FuSvPg MSSQL SERVER ADMINISTRATION IN HINDI