SQL School Training Institute is an ISO Certified Organization and Microsoft Learning Partner offering real-time, practical trainings exclusively on SQL Server Technologies including SQL Server Development (SQL Dev), SQL Database Administration (SQL DBA), Microsoft Business Intelligence and Datawarehousing (MSBI / DWH) Training. Versions: SQL Server 2016, SQL Server 2014. Register Today for free demo
We offer Instructor-Led LIVE Online Training, Classroom Training and On-demand Video Training with COMPLETE REAL-TIME and INTERACTIVE Practical Sessions. All our training courses include Real-time Projects, Certifications, Weekly Mock Interviews, Placement Assistance and free 24x7 LIVE Online Lab.
Question: I’ve started looking at some sql memory pressure issues, and drilling down into the root cause. I can see that the query plan cache is busy , but I’d like to know how can I extract a detailed breakdown of the the cache types. Using this information – I can begin identifying activity which may be causing this pressure.
I’ve looked at the Find Table Scans in Query Plan Cache (SQL Server DBA) . Although this gives me some counts on query plans , it doesn’t give me a breakdown of the cache types
Answer: Having information about the cache types AND space taken up by these caches supplies some clues for the initial action you should take. If you drill in further it may lead you to code inefficiencies, that can easily be fixed.
This query by Kimberly Tripp – will identify the Cache Types . Importantly there are columns identifying where the usage of the query plan is used only once.
Please register free demo @ http://sqlschool.com/register.html
SQL School (SequelGate (I) Technologies Pvt. Ltd.)
OFFICE 1:
Sai Anu Avenue, Street Number 3, Patrika Nagar,
Patrika Nagar, HITEC City, Hyderabad - 81 (India). Map
Patrika Nagar, HITEC City, Hyderabad - 81 (India). Map
India: 0091 (0)9666440801 USA: 001 (510) 400-4845
No comments:
Post a Comment