We have a dedicated Server(16gb ram, 16-core) which host our Analysis servers(2008), Database engine is not installed in the server. We have 5 Analysis Services databases. Ranging from small to big. Small cubes have 30-50 million rows. Whereas, one
of the Big cube has 700 m rows.
I'm having performance issues only with the big one. Everything is in place to optimize the cube (aggregations, partitioned by month, attribute-relationships).
Every time I restart Analysis services, Most of the queries runs decently, but, after few days they start getting slower and worse.
I check perfmon, nothing is pegging, neither the cpu nor memory. Cleared - Cached on every database but nothing works until I restart the services. Can anyone tell me what I should doing instead of restarting the AS services?
View Complete Post