TM1 Forum

We have 2 TM1 serveres as follows:

Server 1: Windows 2008 R2, 16 Gb Ram, TM1 10.2.1.3, Progress OpenEdge 11.3 (ODBC 64 bits), 2 Intel Xeon CPU at 2.60 Ghz.

Server 2: Windows 2012 DataCenter R2, 16 Gb Ram, TM1 10.2.1.4, Progress OpenEdge 11.3 (ODBC 64 bits), 2 Intel Xeon CPU at 2.00 Ghz.

In both TM1 servers, the tm1s.cfg file has the same configuration, (exactly the same)

In both servers we have the following turbointegrator process wich reads from a Progress DataBase Table as follows:

SELECT
"Id_cc",
cast("anio" as char (10)) as Anio,
Cast(Mes as char(10)) as Mes,
"Fecha",
"week",
"Id_articulo",
"Id_promocion",
"Id_linea",
"Tipo_mov",
"Id_forma",
"Cantidad",
"Precio_uni",
"Unit_cogs",
"Total_cogs",
"Gross_sale",
"Discount",
"Net_sale"
FROM "PUB"."Ventas"

This Query takes 5 minutes to finish on Server 1, but 1 hour in server 2.

- Does anybody has an idea why the query took 5 minutes in server 1 and more than an hour in the second tm1 server?
- Does any one knows some tunning can be done to optimize the time process on server 2?

Regards firends!!!

There are a lot of possible causes; I would hazard a strong guess that it has nothing to do with TM1 though.
Starting point - what are the respective proximities of each tm1 server to the database server?
Second point to look at before delving into specifics - are the DSN setups identical (particular attention to whether one has "Log ODBC driver stats..." ticked)?