"There’s nothing wrong with the SAN!"

Author: David Williams (Microsoft) Contributor & Technical Reviewer: Matthew Robertshaw (Microsoft) How many times have you heard the above from the Storage team, having looked at SQL’s wait types and seen PAGEIOLATCH_*? You know there’s something gone wrong with your disks, because SQL’s telling you so. But the guy/gal in the disk team isn’t having…

0

SQL Server Page Life Expectancy

Author: David Williams (Microsoft) Contributor & Reviewer: Matthew Robertshaw (Microsoft) Ever wondered how volatile your Buffer Pool is? Keeping you awake at night? Page Life Expectancy (PLE) is the best indication of how volatile your Buffer Pool is (BP). It’s a PerfMon counter, found in the SQL Server:Buffer Manager PerfMon object.  Monitor it every 3-5…

0

Using PowerShell to deploy Windows Azure Virtual Machines and Windows Azure SQL Databases

Author: Benjamin Wright-Jones (Microsoft) Contributors: Karthika Raman (Microsoft) Technical Reviewers: Guy Bowerman (Microsoft), Sanjay Nagamangalam (Microsoft) I have recently been exploring the use IaaS (Infrastructure as a Service) to provide cloud-based virtual machines (VM’s) as opposed to laptop-based VM’s and also PaaS (Platform as a Service) for SQL databases.  I like the idea of carrying…

0