PROC Cache crash

Last Post 24 Jul 2009 07:16 AM by timcronin. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
timcronin
New Member
New Member

--
23 Jul 2009 12:08 PM
On Saturday of last week, got a call sql server 2005 with 48 gig box running very slow, only a few users on the weekend were there. Looked at it, only about 15% cpu could not see anything glaring. Come Monday box with 50 users at a slow crawl. OLTP buried, CPU at about 18%, Buffer Cache at 99% like usual. Looked at proc cache and it had sunk to 40%. No blocking, lock issues, restarted SQL Server problem went away. Looked at my IDERA Dm and noticed on Friday that procedure cache size had gone from 400 MB to 0, and procedure cache was dropped from 90 to 40%. Now I need to play detective with the DMV's Anyone seen this before (this also happened about 45 days ago), or any idea where to look to see what killed my procedure cache?
Thanks
timcronin
New Member
New Member

--
24 Jul 2009 07:16 AM
on SP2


Acceptable Use Policy
---