Pittsburgh SQL Server Users Group

EventDisplay

Next Meeting: Tue, Oct 28 2014

October User Group meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://Oct2014PSSUG.eventbrite.com

When

iCal
UTC : Tue, Oct 28 2014 21:00 - 23:00
Event Time : Tue, Oct 28 2014 17:00 - 19:00 Eastern Daylight Time
Your Local Time: Tue, Oct 28 2014 21:00 - 23:00

Where

2000 Technology Dr
Pittsburgh, Pennsylvania

Direction: None

Featured Presentation

Fixing Page Life Expectancy

Speaker: Steve Hood

Summary: Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. It is just a counter and doesn’t specifically point to an issue with it being normal for many OLAP systems to have a low value. We’ll get into looking at other counters to measure the impact of PLE, queries to determine what is using your memory, and hot spots to look at to start raising this counter. The goal is to raise it the right way, be able to measure the results in query and disk performance, and improve the overall health of your servers. This is based on my blog post: http://simplesqlserver.com/2013/08/19/fixing-page-life-expectancy-ple/

About Steve: None

Attachments

            

Thank you to our Sponsors!

PASSChapterLogo100.jpg

sql_micro_sm.gif

 

   

   

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids