Set-AxParameterSniffingSetting

NAME Set-AxParameterSniffingSetting



SYNOPSIS

Set the parameter sniffing configuration





SYNTAX

Set-AxParameterSniffingSetting [-DatabaseServer <String>] [-DatabaseName <String>] [-SqlUser <String>] [-SqlPwd

<String>] [-OutputCommandOnly] [<CommonParameters>]





DESCRIPTION

Set the parameter sniffing value in the database based on the released hotfix from Microsoft for AX 2012





PARAMETERS

-DatabaseServer <String>

Server name of the database server



Default value is: "localhost"



Required? false

Position? named

Default value $Script:ActiveAosDatabaseserver

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-DatabaseName <String>

Name of the database



Default value is: "MicrosoftDynamicsAx"



Required? false

Position? named

Default value $Script:ActiveAosDatabase

Accept pipeline input? true (ByPropertyName)

Accept wildcard characters? false



-SqlUser <String>

User name of the SQL Server credential that you want to use when working against the database



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-SqlPwd <String>

Password of the SQL Server credential that you want to use when working against the database



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-OutputCommandOnly [<SwitchParameter>]

When provided the SQL is returned and not executed



Note: This is useful for troubleshooting or providing the script to a DBA with access to the server



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS

System.String





NOTES





Author: M??????tz Jensen (@Splaxi)



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Set-AxParameterSniffingSetting



This will configure the correct parameter sniffing settings.











RELATED LINKS

https://community.dynamics.com/365/fina ... ter-sniffi

ng-step-by-step