dkumeri
asked on
sql server 2008
In our SSAS server, the Analysis services stops by itself (but it shows that service is still started). I always restart service and it works then. it happens once in 1 or 2 months. But as its a prod server,its not acceptable. Any idea why its happening. nothing in window logs
Did you checked SQL Logs on that box? And SSAS logs? SQL logs are available in SSMS under "Management" section and also directly on the box in a local folder.
ASKER
no error there as well
nothing in the msmdsrv.log file? should be under C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\ OLAP\Log
ASKER
where I can get msmdsrv.log file? Also " C:\Program Files\Microsoft SQL Server\ " ,I get different option after this path i.e 80, 90, 100 folder
if you are using SQL 2008 it must be under your .\MSAS10...... path.
That's where it is installed by default and other than that you could open SSMS on that box, connect to Analysys Services, right click server name, select Properties, and check "Show Advanced (All) Properties" on the general tab then locate the path to your log file
That's where it is installed by default and other than that you could open SSMS on that box, connect to Analysys Services, right click server name, select Properties, and check "Show Advanced (All) Properties" on the general tab then locate the path to your log file
ASKER
attached is the msmdsrv.log file but there in nothing informative
msmdsrv.log
msmdsrv.log
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks