Hi,

What would be the best practice?

Is to have factdatabase and SSAS services running on same server or different servers?

It is taking huge time to process the cube and i am seeing Async_Network_IO on DB engine.

I think it's spurious to say best practice is one or the other. It depends.

Unless you have a good reason to have them on separate servers to begin with, my suggestion would be to consider using one server for both services and to keep the option of moving one service at a later date. The main reason for this is simplicity, but also efficient use of resources as you may have SSAS busy at different times to SQLS and SSIS.

A couple of reasons for putting them on separate servers are

• Greater scalability (assuming that you have a fixed maximum server size)
• When SQLS is busy it won't impact the performance of SSAS and vice versa.

Hope that