SQL Server Performance

Performance issues with MSMDSRV.EXE limited to 25%

Discussion in 'SQL Server 2005 Analysis Services' started by mickjf, May 7, 2007.

  1. mickjf New Member

    Hi all,

    Newbie question here. We have a SQL2005 install running Analysis Services, and during some performance testing, we have found that some tasks in AS (sorry I don't have much more detail at the moment) are taking a lot longer (3 minutes vs 20 seconds) in SQL2005 than they did in SQL2000 with lower spec'd machines.

    Task Manager reveals that the MSMDSRV.EXE process is limited to 25% CPU utilisation on the SQL 2005 box = although Task Manager appears to show this activity occuring on the 2nd and 4th processor - not just a single processor. The server is a 2.6GHz Quad Processor with 4GB RAM. The server properties within SQL 2005 has, by default, selected all four processors to use.

    Could anyone provide me with any ideas on why the MSMDRSV.EXE process would be limiting itself like that? A search for MSMDSRV.EXE seems to only reveal issues where the processes is using 100% CPU...

    Many thanks in advance...
  2. satya Moderator

    Few counters for you:
    http://sqlserver-qa.net/blogs/bi/ar...onitor-the-analysis-services-performance.aspx
    http://sqlserver-qa.net/blogs/bi/archive/2007/05/04/monitor-analysis-services-performance.aspx
    http://sqlserver-qa.net/blogs/bi/ar...nce-issues-in-sql-2005-analysis-services.aspx

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. mickjf New Member

    Thanks Satya,

    They are helpful, but do not appear to answer my question of why the MSMDRSV.EXE would be limited to 25%CPU on a quad processor box. Running the same test on a SQL2000 machine shows the MSMDRSV.EXE using as much CPU as it needs (ranging from 1% to 40%) where as SQL2005 seems to sit consistantly on 25% - indicating that it is being limited somewhere... or am I barking up the wrong tree...?

    Thanks in advance,
    Mick
  4. satya Moderator

    Are you able to monitor the CPU usage with PERFMON in addition to Task Manager periodically?

    KBAhttp://support.microsoft.com/kb/922852 fyi and not sure your case fits in here.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. mickjf New Member

    Thanks Satya, however, this is not the issue. We appear to be limited to 25% CPU and would like more CPU to increase the time taken to process.

    If I am in the wrong area can you advise where I should post this? I thought that MSMDRSV.EXE was part of AS2005?

    Thanks in advance,
    Mick
  6. satya Moderator

    MSMDRSV is a part of analysis services and don't worry I will move the post to relevant forum section.

    Until now it appears you are following Task Manager, can you collate the CPU resource usage using SYSMOn in thsi case as I don't trust TM always.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page