Performance issues with MSMDSRV.EXE limited to 25% | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Performance issues with MSMDSRV.EXE limited to 25%

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…
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.
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
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.
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
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.
]]>