Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PWAIT_MD_RELATION_CACHE and MD_LAZYCACHE_RWLOCK wait types Expand / Collapse
Author
Message
Posted Monday, April 22, 2013 11:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:16 AM
Points: 15, Visits: 288
I'm hoping someone can give me some more information on either of these two wait types PWAIT_MD_RELATION_CACHE and MD_LAZYCACHE_RWLOCK. We started seeing these happen on queries that were accessing a table with 1,000 records, most of the waits were over a couple minutes. No blocking was occurring at the time, and other queries against the database were able to complete successfully.

From doing a bit of research I was able to find this description on MSDN for PWAIT_MD_RELATION_CACHE: "Occurs during internal synchronization in metadata on table or index." This made me believe the issues was revolving around a large insert, update or delete that was occurring during that time, or manipulation of an index on the table. No records had been inserted or updated in the last 3 days, the indices were last rebuild 2 days prior to the issue.

I've been unable to find anything in relation to MD_LAZYCACHE_RWLOCK.

We are currently running Microsoft SQL Server 11.0.2100.60.

Any help or ideas would be appreciated.
Post #1445078
Posted Tuesday, May 14, 2013 4:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:07 AM
Points: 2, Visits: 6
I had the same problem today.
The reason was probably, that the SQL-Server Process had taken all the available RAM. After limiting Maximum Server Memory and restart the problem was gone.
Hope it helps, Ralf Kuhlendahl
Post #1452486
Posted Monday, March 24, 2014 5:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 12:08 PM
Points: 2, Visits: 99
I have the same problem with our production servers since last year and raised them to microsoft already. I'm very positive that the next release of CU will solve the problem for SQL 2012.
Post #1553980
Posted Wednesday, March 26, 2014 8:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 12:08 PM
Points: 2, Visits: 99
CU9 has been released:

http://support.microsoft.com/kb/2926712
Post #1554975
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse