Get-AxParameterSniffingSetting

NAME Get-AxParameterSniffingSetting



SYNOPSIS

Get the parameter sniffing configuration





SYNTAX

Get-AxParameterSniffingSetting [[-DatabaseServer] <String>] [[-DatabaseName] <String>] [[-SqlUser] <String>]

[[-SqlPwd] <String>] [<CommonParameters>]





DESCRIPTION

Get the parameter sniffing value from the database that has been released by Microsoft for AX 2012





PARAMETERS

-DatabaseServer <String>

Server name of the database server



Default value is: "localhost"



Required? false

Position? 2

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? 3

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? 4

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? 5

Default value

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



NOTES





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



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



PS C:\\>Get-AxParameterSniffingSetting



This will query the database for the parameter sniffing settings.

The result will be displayed along with a ShouldBe value to easily tell you if something is off.











RELATED LINKS