Start> Administrative Tools> Microsoft Dynamics AX Server Configuration Utility

Use the Microsoft Dynamics AX Server Configuration Utility to set startup conditions for an Application Object Server (AOS) instance, change database connection settings, tune how Microsoft Dynamics AX interacts with a database, and trace Microsoft Dynamics AX performance.

This utility runs outside Microsoft Dynamics AX - although you can make changes while an AOS instance is running, they are not applied until you stop and restart the instance.

Note Note

Only members of the power users or administrators groups on the local computer can change configurations.


Tasks that use this form

Navigating the form

The following tables provide descriptions for the controls in this form.

Configuration context settings

Field

Description

Application Object Server instance

Specify the AOS instance to configure. If only one instance is available, defaults to that instance.

Configuration

Specify the name of the current group of settings for this AOS instance.

Manage

Open a menu with the following options:

  • Open configuration file- Open a file containing configuration settings.

    Note Note

    Although you can use the Opencommand to view a saved configuration, Dynamics does not store the settings from the opened file to the registry. To save settings from a configuration file to the registry, you must use the Importcommand.


  • Close configuration file- Close the open configuration file.

  • Save configuration as file- Save the current configuration to a file. Use this command to store an offline copy of the settings you have been using.

  • Import configuration- Import a configuration to the registry that has been stored to a file. You can save imported configurations to the registry.

  • Export configuration to a file- Export a configuration to a file when you want to copy it to an AOS instance on another computer.

  • Export all configurations to a file- Export all configurations to a file when you want to copy all the configurations from one AOS instance to another computer.

  • Create configuration- Create a new configuration using the Create configuration (form) (Server)dialog box. You can create a new configuration based on the currently-selected configuration, or the default configuration that shipped with Microsoft Dynamics AX.

  • Delete configuration- Delete the current configuration.

  • Rename configuration- Rename the current configuration.

Tabs

Tab

Description

Application Object Server

Specify startup options for an AOS instance.

Database connection

Specify which database an AOS instance should connect to.

Database tuning

Modify database settings to improve performance.

Tracing

Specify traces to run that help to monitor and tune Microsoft Dynamics AX performance.

Buttons

Button

Description

Start trace

Start tracing immediately if the AOS instance is running, or when the AOS instance next starts.

Stop trace

Stop tracing immediately if the AOS instance is running, or when the AOS instance next starts.

Fields

Field

Description

Application file location

Specify the location of the application files for the AOS instance to connect and write to.

Alternate bin directory

Specify the location of a directory containing an alternate kernel text data file (one of the Microsoft Dynamics AX label files).

Application instance

Specify the instance of an application that the AOS instance connects to.

Configuration command to run at kernel startup

Enter configuration commands to execute when this AOS instance starts. Use configuration commands with caution because they are not evaluated before being passed to the AOS.

TCP/IP port

Specify the TCP/IP port that this AOS instance uses to connect to clients. The default value is 2712. Change this if you have a conflict in ports or must use a specific port.

Allow clients to connect to printers on this server

Allow clients to connect to printers that are connected to the AOS computer.

Enable breakpoints to debug X++ code running on this server

Enable clients to trace their interactions with this AOS instance.

For all AOS instances on this computer, automatically send reports about fatal errors to Microsoft

Set all AOS instances to send information about any fatal error in an AOS instance to Microsoft. If you enable error reporting, information is sent over a secure (https) connection to Microsoft, where it is stored with limited access. Microsoft uses the reports only to improve Microsoft Dynamics AX, and treats all information as confidential.

Note Note

This setting applies to all AOS instances, and starts after each instance has been restarted.


Compress packets

Compress data sent between the AOS and its clients to speed client-server communications. Use in low-bandwidth or high-latency network environments.

Minimum packet size to compress (in KB)

Specify the smallest useful packet size to compress. The larger the packet size chosen, the smaller the gains in speed.

Select the type of database server to connect to

Specify whether to connect to a Microsoft SQL Server database or an Oracle database. To connect to a database, the database management system must be installed.

Microsoft SQL Server

Connect to a SQL Server database.

Server name

Specify the computer running an instance of SQL Server. Specify a connection in the format Servername\instancename.

Database name

Specify the name of the database to connect to.

Oracle

Connect to an instance of Oracle database server.

Use a defined Oracle service to connect

Connect to a predefined Oracle service.

Service name

Specify the name of Oracle service to connect to.

Use custom options to connect

Specify an Oracle database without a predefined Oracle service to connect to.

Host name

Specify the computer running an instance of Oracle database server.

Database name

Specify the name of the database to connect to.

TCP/IP port

Specify the TCP/IP port that the database is running on.

Schema (user) name

Specify the schema the database tables are stored under. The default value is DBO.

Maximum open cursors

Specify the maximum number of database cursors to keep open for reuse in a connection. Starts as your local computer setting, which defaults to 90.

Maximum buffer size

Specify the maximum size of the data retrieval buffer. The larger the buffer, the greater the number of records transferred at the same time. Starts as your local default computer setting of 24.

Transaction retry interval (in seconds)

Specify the delay before re-executing a transaction after a deadlock.

Array fetch ahead

Specify the maximum number of records that the system fetches at the same time. Starts as your local default computer setting of 100.

Local ODBC log file location

Specify the location of the ODBC log file.

Allow INDEX hints in queries

Enable any query written with an INDEXhint to override the index selected by the database management system. Test this flag thoroughly in a development or test environment before using it in an Microsoft Dynamics AX production environment.

Number of connection retries

Specify the number of times to try connecting to the database before failing.

Connection retry interval (in seconds)

Specify the interval between attempts to connect to the database.

Leave the connection running when idle

Retain a connection to database when no transactions are running.

Maximum idle time before closing (in seconds)

Specify the amount of time to leave a database connection idle before closing it.

Use literals in join queries from forms and reports

Specify that Microsoft Dynamics AX use literals rather than parameters in long-running queries to optimize performance.

Use literals in complex joins from X++

Specify that Microsoft Dynamics AX use literals rather than parameters for complex joins to optimize performance.

Generate ORDER BY clauses from WHERE clauses

Override the ordering specified by the index on the data source, using the order of the columns as specified in the WHEREclause. This can improve query performance.

Include LTRIM in all SELECT statements to remove leading space from right-aligned columns

Add LTRIMto all queries generated by Microsoft Dynamics AX. Using LTRIMforces the database to perform a table scan, which can slow query results.

RPC round trips to server

Trace all remote procedure call (RPC) round trips from any client to the server.

X++ method calls

Trace all X++ methods that are invoked on the server.

Number of nested calls:

Limit tracing to the specified number of nested method calls.

Function calls

Trace all function calls that are invoked on the server.

SQL statements

Trace all SQL Server statements that are invoked on the server.

Bind variables

Trace all columns that are used as input bind variables.

Row fetch

Trace all rows that are fetched using SQL Server.

Row fetch summary (count and time)

Count all rows that are fetched, and record the time spent fetching.

Connect and disconnect

Trace each time the AOS connects and disconnects from the database.

Transactions: TTSBegin, TTSCommit, TTSAbort

Trace all transactions that use the TTSBegin, TTSCommit, and TTSAbortstatements.

See Also



!