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
