Results 1 to 4 of 4

Thread: Sql 2005 - SSAS

  1. Jul 29th, 2008, 06:02 AM #1
    pvbangera
    pvbangera is offline

    Thread Starter
    Fanatic Member pvbangera's Avatar
    Join Date
    Sep 2001
    Location
    Mumbai, India
    Posts
    961

    Arrow Sql 2005 - SSAS

    msmdsrv.exe is consuming almost 99% of my cpu and ram. i have a data cube in ssas with more than 40 partitions (monthwise). All the partitions for history data are set as MOLAP and the current one as ROLAP.

    When I test the performance with sql profiler, the cubes are being processed even if the application is not started!!

    Pls guide how to fix this up to free some cpu for other processes.
    Microsoft Techie
    Reply With Quote Reply With Quote
  2. Jul 31st, 2008, 12:45 AM #2
    pvbangera
    pvbangera is offline

    Thread Starter
    Fanatic Member pvbangera's Avatar
    Join Date
    Sep 2001
    Location
    Mumbai, India
    Posts
    961

    Re: Sql 2005 - SSAS

    nobody??!!
    Microsoft Techie
    Reply With Quote Reply With Quote
  3. Jul 31st, 2008, 11:59 AM #3
    Clanguage
    Clanguage is offline
    Fanatic Member Clanguage's Avatar
    Join Date
    Jan 2008
    Location
    North Carolina
    Posts
    659

    Re: Sql 2005 - SSAS

    This might help.
    http://msdn.microsoft.com/en-us/libr...ys_performance
    CLanguage;
    IF Post = HelpFull Then
    RateMe
    Else
    Say("Shut UP")
    End If
    DotNet rocks
    VB 6, VB.Net 2003, 2005, 2008, 2010, SQL 2005, WM 5.0,ahem ?OpenRoad?
    Reply With Quote Reply With Quote
  4. Aug 1st, 2008, 12:51 AM #4
    pvbangera
    pvbangera is offline

    Thread Starter
    Fanatic Member pvbangera's Avatar
    Join Date
    Sep 2001
    Location
    Mumbai, India
    Posts
    961

    Re: Sql 2005 - SSAS

    Disappointment continues...

    What I observed in SQL Server Mgmt Studio is that the no. of logins for NT AUTHORITY keeps on increasing. I checked this in Activity Monitor as well as with sp_who stored procedure. This login is basically used by all the windows services...in this case it is Analysis Service.

    What I fail to understand is why are the cubes being processed even though there's no updation on the database!!!????
    Microsoft Techie
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width