Tag Archives: SQL Server Performance

What is Page Life Expectancy (PLE) in SQL Server

Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a … Continue reading

Share
Posted in Query Tidbits, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Tagged , | 9 Comments