Microsoft SQL Server stream handler
You can apply the Microsoft SQL Server stream handler to all of the Microsoft SQL Server version and Azure SQL Server. You can use the MS-SQL policy or the Standard policy to enable this feature.
You can enable and disable the Microsoft SQL Server stream handler per policy or all policies at once using the cacontrol command line utility.
The marker entry configuration file (marker.cfg) is used to override the default behavior by using thecacontrol command utility with the --sth flag at a client and or policy level only.
The marker.cfg file is stored at the following location:
/MDSP_SERVER/databases/spa/marker.cfg
Update the marker.cfg file by using the following cacontrol options:
You can create and or update the
marker.cfgfile.cacontrol --sth update <STHTYPE> <CLIENT> <POLICY> [SPAUSER] <enabled | disabled>You can query the setting for the stream handler per policy.
cacontrol --sth get <STHTYPE> <CLIENT> <POLICY> [SPAUSER]You can delete the settings to use the default behavior.
cacontrol --sth delete <STHTYPE> <CLIENT> <POLICY> [SPAUSER]
When you enable the Microsoft SQL Server stream handler, the Job Details tab in the Administration Console displays the following:
MS-SQL stream handler enabled