SQL Server Performance Tuning

How to Identify Non-Active SQL Server Indexes

As a DBA, it is our regular task to review our databases and see if there is any way we can boost their performance. While adding new or better indexes to a database is one of the primary ways we can boost performance, an often forgotten way to help boost database performance is to remove […]

Eliminación de Índices no Usados

En la tarea habitual de aumentar la performance de una base de datos, creamos índices de acuerdo a las necesidades. La creación de índices se realiza tanto analizando los planes de ejecución o utilizando el ITW (Asistente para la Optimizacion de Indices). Una vez que la base de datos se encuentra estabilizada en su performance, […]

Transferencia de las Estadísticas de SQL Server de una Base de Datos a otra

Nota del traductor: Algunas palabras se han mantenido en inglés por no disponer en castellano de una traducción apropiada, en el lenguaje computacional. Esas palabras son las siguientes con su traducción literal en algunas de ellas y con un pseudo castellano en otras. Constraints: Restricciones, limitaciones, Obligaciones Default: Por defecto, a falta de… Setting: Ajustes, […]

MANTENIMIENTO: Reorganización de Índices – Actualización de Estadísticas

Dentro de las tareas habituales de Mantenimiento de las Bases de Datos se encuentran aquellas destinadas al control y respaldo de las mismas como ser: Control de Integridad, Chequeo de Consistencia, Copias de Seguridad o Compactación de las bases. Pero también es necesario ejecutar trabajos de mantenimiento cuyos objetivos sean el de mantener la performance […]

Large Data Operations in SQL Server

The articles in the Quantitative Performance Analysis series examined the internal cost formulas used by the SQL Server query optimizer in determining the execution plan and the actual query costs for in-memory configurations. The previous articles restricted the actual query cost analysis to in-memory cases where all necessary data fit in memory so that performance […]

Transferring SQL Server Statistics From One Database to Another

Many production databases today are in the tens or hundreds of gigabytes in size. That size is not a problem for production hardware. However, developers generally like to work on their personal computers, including notebooks with limited disk capacity, so a 10-100GB database size is an issue. Furthermore, it can be impractical to transfer such […]

SQL Server Parallel Execution Plans

Microsoft SQL Server introduced parallel query processing capability in version 7.0. The purpose of parallel query execution is to complete a query involving a large amount of data more quickly than possible with a single thread on computers with more than one processor. Books Online and various Microsoft documents describe the principles of parallel execution […]

Processor Performance, Update 2004

This article is a follow on to the original processor performance article I wrote, with analysis of processor performance results released in the last year. The original article explains many of details discussed here. Of the new material presented here: First, the range of results published for the TPC-C benchmark now allows meaningful analysis. Second, […]

A First Look at Execution Plan Costs in Yukon Beta 1

Many of us are interested in the features and changes in Yukon. A quick look shows some changes in the execution plan cost formulas for Yukon Beta 1. It is quite likely that more changes will be made between beta 1 and the final release. Most of the cost formulas appear not to have changed. […]

Advanced SQL Server Locking

I thought I knew SQL Server pretty well. I’ve been using the product for more than 6 years now, and I like to know my tools from the inside out. While teaching a SQL Server programming course, I noticed that the Microsoft material presented a lock compatibility table. The same table is presented at MSDN. […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |