We have one windows server enterprise server ( 64 bit ) and 32 GB of ram..This server runs all four services, i.e. Database, Analysis , reporting and Integration..
Its been few days we are facing a new challenge on our server, where the Analysis services does not respond properly. It stops and restarts, some time it does even restart..Also, we can see that even if there are no activities \process running on analysis
services, it just squeezes all memory.and thats when we face this sort of issues.The only option we could think of is to do a server reboot
Now the second challenge is , even after a server reboot, analysis services takes long time to reposnd to any incoming connection request. I know server reboot is not the long term solution to these kind of problems .
My knolwedge to Server administration is limited .Please help me in this.
View Complete Post