Category: Technology

You may, at some point, want to set up a report that you have built dimension specifications in the row to have a tree that will also filter by those same dimensions to get, say, a line of business report – or only dimensions that are specified in a row…

By default, SQL Server’s max memory is 2147483647.  With this default setting, SQL Server will “commit” as much memory as possible until there’s none left for the operating system to run efficiently.

If the operating system has no memory available, it will start using the page file instead of RAM. Using the page file in place of memory will result in poor system performance.

Have you had issues when trying to run the migration wizard from FRx to Management Reporter? When opening your row formats to validate, did you notice that you didn’t have any accounts in the link to financial dimension column?  If this has happened to you, it is most likely due to the use of account sets in FRx.  If you’re in row formats in FRx, you are using account sets which do not migrate into Management Reporter.  If this happens, what are your options to fix your reports?

The recommended mileage on a typical car in America to get an oil change is every 3,000 miles.  So that means a lot things.  Good… clean oil is absolutely crucial so that engine parts continue to cycle properly.

Not to mention the other important parts and services like an air filter, gas treatments, cables, wires, and spark plugs that are part of the normal maintenance on the very machine on four wheels that YOU (Mr. and Mrs. IT folks) place your children in to get to point A and point B.

In Part 1 of this blog series, we outlined the importance of creating a good starting point for performance tuning on your SQL Server  by establishing a baseline for your server’s current performance.  

In Part 2, we covered how to enable Instant File Initialization and adding additional TempDB files to your TempDB database. 

As a conclusion to those articles, we will look at the effects of those changes by running a simple GP2010 Sales Order processing batch posting. To run the test, I create a virtual server with SQL 2012 using the default setting and GP2010 SP2. I made one change to the default to limit SQL server to only use a max of 12GB of RAM since I was running GP2010 and SQL on the same image.  Below are the specs of the server

Microsoft Dynamics GP is coming to Windows Azure in June; Microsoft confirmed this at this year’s Convergence event.  This new deployment option will offer what you would expect from an enterprise-grade cloud service –  stability, protection, security and the ability to scale and grow.  Microsoft has referred to the Azure service as being elastic and the fact that it can grow without adding servers will be great for partners.

By change some default SQL Server settings you can increase performance.  The first two changes will provide performance increases when restoring SQL backups and looking pages in memory.