July 29, 2009 at 2:40 pm
I have a Windows 2003 Standard x64 server hosting several x64 2005 Standard SQL and AS servers.
When the users are processing cubes on more than one instance, each instance of AS is attempting to lock the msmdredir.ini file several times per minute. This is creating performance issues for the users.
I have found through research that this is a known issue with SQL 2005 SP2 and Microsoft even has a hotfix (http://support.microsoft.com/kb/940377/) posted on their website, however, I am currently at SP3 (9.00.4035.00).
I tried to email support, but they wanted to extract $99 from me for an email. I figured I'd ask around before I resorted to that.
Has anyone else seen this type of behavior and know of a fix if it happens still on SP3? I can find no mention of it being fixed or not being fixed.
Any help would be much appreciated.
December 12, 2011 at 6:34 am
We are seeing this on a virtualized Windows Server 2008 R2 (SP2) box running SQL Server 2005 sitting at SP4 (development environment).
The box has four named SQL Server instances on it. Once we disabled SQL Server Analysis Services for each instance, the locking on the msmdredir.ini file immediately disappeared.
After watching the issue for a bit, it appears the msmdredir.ini file was being modified about every 15 seconds. I'm guessing the contention comes from the multiple named instances not playing nice and all trying to schedule access to the file at the same time?
We don't have to have SSAS running for this environment, so that solved our issue for the time-being, but I have not found a fundamental fix yet.
------------------------
David Caughill
Production DBA
Grad Student
Coffee Enthusiast
December 12, 2011 at 6:43 am
As it turns out, the performance issue was not happening because of this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply