[Script Of Oct. 29] How to check if TF834 and CSI are used concurrently in SQL Server

  • Article

image

Oct.

29

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-check-if-TF834-and-f61ab782.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This PowerShell script will demo how to check if trace flag 834 and column store indexes are used concurrently in SQL Server.

If trace flag 834 and column store indexes are used concurrently, you may encounter performance issues with applications. If this kind of problems exist, this script will warn you.

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