Performance and InventDim and InventSum

The standard ‘out-of-the-box’ system will perform reasonably for many companies. There is always a need to test the performance and tune the system to your requirements.

If your implementation uses inventory, and if you are using batch and or serial numbers, then you might find your inventory performance to be sluggish. You might want to look at your indexes on the tables InventDim and InventSum. These tables are used in almost every query when involved with inventory.

Continue reading

Analyse Query with Database Engine Advisor – Failed to connect to an IPC Port

Using the Database Engine Advisor to analyse a SQL query can give you an insight into where to look for problems with performance. Recently I have a problem opening the advisor from a query window recieving an error: “Failed to connect to an IPC Port: The system cannot find the file specified”.

The problem was caused by a previous use of the system that had not been shutdown cleanly. The simplest way to resolve this problem is to open the windows task manager and end the process for DTAShell.exe.

ODBC errors

Using ODBC to connect to another database can be an important requirement, whether the connection is part of the initial data import or an ongoing integration.

There are a couple of error messages that you might experience when using the ODBC connection within DAX, with the main two, often cryptic messages being returned being:

error 1: Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english

error 2: [Microsoft][SQL Server Native Client 10.0]Invalid Descriptor Index

Continue reading

DAX Instance Structure and Code Release

The DAX instance structure and code release methodology is more important that ever with the introduction of DAX 2012. More important it is the key, as it has been in reality in older version, if you want a stable environment.

With the introduction of DAX 2012 the need to enforce the process has become critical to ensure you have a stable production environment and a reliable code release process, and the ability to move your production data to other environments for testing and evaluation.

Continue reading