I have run tracestatus on our production server and found that 5556 trace flag is on.
I have searched web and docs but could not find what is it. Does anyone knows what is it for?
Version : Microsoft SQL Server 2016 (SP1) with file stream ON.
Asked
Active
Viewed 140 times
0
-
This question isn't related to programming. I suggest you ask on https://dba.stackexchange.com/questions/tagged/sql-server. Note that some traceflags are entirely undocumented and may have been recommended by Microsoft support. – Dan Guzman Dec 16 '17 at 13:40
-
Trace Flag 5556 is used for FileStream.. see answer [here](https://stackoverflow.com/questions/2183029/physical-location-of-filestream-data) HTH – Dec 18 '17 at 05:39