Click the link above to download scripts from the webcast.
Want to see the video? Check it out at: http://brentozar.com/go/memorymyths
Scripts from the “SQL Server Max Memory Myths” Webcast
by Jes Schultz Borland June 5, 2012
11 comments
11 comments
Leave a comment
Karl June 6, 2012 | 9:44 am
Please send me the sql scripts during sql-server-max-memory-myths webcastt.
Thanks
Jes Schultz Borland June 6, 2012 | 10:30 am
Karl, the link to the scripts is right under the video! It’s a .zip file you can download.
Jesse Schleicher June 6, 2012 | 2:25 pm
Hi Jes! Thanks for the webcast — you guys at Brent Ozar PLF really do inspire me to learn as much as I can about SQL. The info about SQL 2012 was particularly useful for me. Looking forward to seeing more from you in the future.
Jesse
jewe June 6, 2012 | 2:43 pm
Hi jes, the link to the scripts above. I can’t find it. Can you send me the link.
Thanks for the points you mentioned.
Jes Schultz Borland June 6, 2012 | 3:17 pm
The link to the script is immediately under the video. Thanks for your interest!
Chintak June 7, 2012 | 9:10 am
Thanks for this nice webcast.
I have once question form the script. The script which was using sys.dm_os_memory_cache_entries, uses the count(pages_allocated_count) for finding out the memory utilization for that type. If you look into the DMV there are entries with have more than once pages and for many enteries this value is zero so even if we change this to SUM, it might not be a proper value. This is a INT field and so can’t take fractional value. Actully this leads to different outupt form this query for object and ad-hoc plan cache size comared to output from DBCC MEMORYSTATUS. Are you getting the same difference I am getting, or I am looking into some worng filds?
Brenda June 7, 2012 | 1:03 pm
Jes,
I really enjoy the information, but now, here is my next question. It’s cool we now have all this information and now know how to retrieve it, but what is it that we are looking for to determine if problems truly exist.
Jes Schultz Borland June 8, 2012 | 1:59 pm
A great resource to learn about what issues to look for, and how to troubleshoot them, is the book “Troubleshooting SQL Server: A Guide for the Accidental DBA“.
Luis June 7, 2012 | 5:11 pm
Hi
The download link to the zip code bring us to this page.
Kendra Little June 7, 2012 | 5:36 pm
Hi Luis!
Yes, you are in the right spot!
There’s a link on this page where you download the .zip file.
I think the link is a bit hard to see based on your comment and one other. I just added a description to the file to help make the link easier to see on the page. Hope that helps.
Luis June 7, 2012 | 5:48 pm
Hi
Thanks
For adding the description to the link.