[Script of Mar. 6] How to detect trace flag 834 and column store indexes in SQL Server (T-SQL)

  • Article

Script Download: CheckTF834CSI.zip
https://gallery.technet.microsoft.com/How-to-detect-trace-flag-1ce1152a

This T-SQL script will demo how to detect if trace flag 834 is enable and column store indexes are used in SQL Server.

If trace flag 834 is enabled and column store indexes are used, you may encounter performance issues with applications. This script will demo how to detect this problem. If it exists, the script will warn you.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery