Performance tuning through memory and CPU

In this tip, learn how memory allocation and CPU processing impact SQL Server performance and get tips for tuning these areas.

How To Collect Performance Data With TYPEPERF.EXE

One of the things I typically need to do is to collect performance data on the server which includes CPU, memory and disk utilization as well as SQL Server-specific data. What command line tools are available to do this?

Tuning performance via disk arrays and disk

Tuning SQL Server performance means tuning hardware configurations and setup. Learn about configuring disk arrays and SQL disk partitioning alignment.

Simulating memory pressure

Identifying Queries Running Slower Than Normal

The attached article describes a utility that allows you to quickly identify which queries are running slower than expected. Note this article was updated to correct the formatting issues.

Updating through cursors

SQL Server memory configurations for procedure cache

SQL Server expert Denny Cherry explains how SQL Server determines how much memory is used for procedure and buffer cache and how you can allocate available memory.

Lengthy SQL Server Queries Will Consume Your CPU

The SQL (Structured Query Language) language is a declarative language that became the "Data Language" used for describing "what I need" and "where to fetch it from" in most organizations. OOP (Object Oriented Programming) languages became the most common practice among developers widely adopted by R&D organizations around the world. So how do we bridge the gap?

Execution Plan Basics

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.

Best Practices for Troubleshooting Slow Running Queries

In this article we will share some of the common reasons for slow-running queries and what your approach should be for identifying and fixing them.