Solved

sql server 2008

Posted on 2011-02-15
8
229 Views
Last Modified: 2016-02-14
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
0
Comment
Question by:dkumeri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 34900358
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.
0
 

Author Comment

by:dkumeri
ID: 34900398
no error there as well
0
 
LVL 40

Expert Comment

by:lcohan
ID: 34900525
nothing in the msmdsrv.log file? should be under C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:dkumeri
ID: 34900736
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
0
 
LVL 40

Expert Comment

by:lcohan
ID: 34900874
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
0
 

Author Comment

by:dkumeri
ID: 34901059
attached is the msmdsrv.log file but there in nothing informative
msmdsrv.log
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 34901291
Please see article below with similar issues and maybe it helps you find the source as well:

http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/e425ef58-84b2-47f0-8575-51c985e302b6
0
 

Author Closing Comment

by:dkumeri
ID: 35200361
thanks
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question