A number of SQL Server settings may need to be checked or changed after installing Dynamics GP and creating companies. These include SQL Server settings and the individual database settings for the Dynamics GP databases.
There are a few settings to verify or change for the entire SQL Server instance that Dynamics GP will be using. These include the maximum memory, cursor threshold, and processor settings. All of these settings are found on the Server Properties window for your SQL Server. To open this window, right-click on the SQL Server instance name in SQL Server Management Studio and choose Properties.
Most documentation recommends letting SQL Server manage memory on its own. This is generally fine, however a good practice is to set a limit on the maximum amount of memory SQL Server will use and leave at least 512 MB RAM free for the operating system and any other services running on the server. This will...