BestGFX

Where do you start looking when trying to diagnose a performance problem with SQL Server? The answer is to use wait statistics! This course will introduce you to the powerful 'waits and queues' performance tuning methodology. You'll learn how SQL Server's thread scheduling system works, what wait statistics are and how to use them, what more advanced synchronization mechanisms like latches and spinlocks are, and a wealth of detail about common performance issues and how to diagnose and solve them. The course is perfect for developers and DBAs who have been struggling to figure out how to start troubleshooting performance problems with SQL Server. The information in the course applies to all versions from SQL Server 2005 onwards.

The Page Speed API will be introduced with special focus on mobile web optimization. Page Speed is a performance optimization tool. We'll describe how to build automated monitoring of web pages with the API and make performance part of your development regression suite and to learn of new optimization best practices as they relate to your site serving for desktop and mobile. We will then walk you through how to install and configure mod_pagespeed on an Apache server, and the effects it has on a web site on the site, its HTML, images, CSS, and javascript.

Want to learn the secrets the Pros use for making huge scale Drupal and perform with grace high traffic situations? In Drupal Performance & Scalability, Matt Westgate and James Sansbury teach you all you need to know to Get out of peak Performance Drupal on the LAMP stack.