SQL Server Internals

This category contains 4 posts

The Best SQL Server Performance Monitor Counters to Analyze

Here is a basic list of essential performance counters to look at when evaluating  baseline SQL Server performance These are listed OBJECT first, then COUNTER Memory – Available MBytes Paging File – % Usage Physical Disk – Avg. Disk sec/Read Physical Disk – Avg. Disk sec/Write Physical Disk – Disk Reads/sec Physical Disk – Disk … Continue reading

SQL Profiler Event Class Translation Tables

SQL Profiler is an essential tool for performance tuning. As such I used it all the time, sometimes just to track a particular query real time and other times to perform a detailed performance analysis. Sometimes saving it in a trace table for analysis and playback, other times saving it to a sql table so … Continue reading

Tempdb Part 1: WHAT IS tempdb

This is part 1 of a several part post on tempdb of which we will explore many aspects of tempdb usage and tunning. For many tempdb is an enigma and can also be the root cause for some very poor performance of your database environmant.  Any discussion of tempdb should begin with an explanation of … Continue reading

SQL SERVER – Page Life Expectancy (PLE)

What is Page Life Expectancy (PLE) On of the key performance measures for SQL Server that you will hear constantly is Page Life Expectancy or PLE for short. So What is PLE you ask? Hopefully this short post will shed some light on that for you.  If you are really inquisitive you can get the … Continue reading