Month: May 2013

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