SQL Server Performance Tuning

Comparcion Entre Index Tuning Wizard 2000 y Database Tuning Advisor 2005 Beta

Introducción A las tareas habituales de cualquier DBA, existe una que nos debe ocupar nuestro poco tiempo libre: Investigar. En mi caso, la investigación la concentro en nuevas herramientas que faciliten nuestro trabajo o, mejor aún, que los resultados obtenidos puedan ser aplicados con el objetivo de mejorar cualquiera de las actividades que involucran la […]

How to Best Implement a SQL Server Performance Audit

Return to Previous Article in the Series The Final Word on How to Perform a SQL Server Performance Audit If you have gotten this far, you have done a lot of reading. In this final article on how to perform a SQL Server Audit, we will take a look at some best practices about how […]

How SQL Server Determines an Execution Plan Using Available Indexes and Statistics

As a SQL Server DBA, one of my tasks is to monitor the performance of our databases. Our primary database holds the data of over 18 million people. A web-based application queries the database with a variety of search options. When examining the performance of these queries, most performed very well. But on the other […]

Automating Reindexing In SQL Server

In all OLTP environments, virtually all indexes will become fragmented over time. Nearly all UPDATE, INSERT or DELETE activity will cause your indexes to become less well organized than they were when they were first created. There will be more page splits, there will be a greater number of pages with less data on them, […]

Analyzing SQL Server 2000 Data Caching

One of SQL Server 2000’s main selling points is its ease-of-use and simplicity. You can install it out of the box and use it pretty much without making many configuration changes. In terms of the product’s use of memory, there are some settings you can change, for example, how much memory to use, whether to […]

Using Profiler to Identify Poorly Performing Queries

Return to Previous Article in the Series SQL Server Query Performance Audit Checklist SQL Server Job Checklist Your Response Have you identified all long running queries? Have you prioritized the queries? Have you reviewed the execution plans of the above prioritized queries? Enter your results in the table above. Identifying Long Running Queries is First […]

SQL Server Backup Performance with Imceda LiteSpeed

Introduction For the last several weeks, I have been working with Imceda (now Quest Software) on improving the performance of LiteSpeed for SQL Server, particularly for high–end storage systems. This report represents my assessment of LiteSpeed performance characteristics. I am an independent consultant, so this report does not represent the views or claims of Quest. […]

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, […]
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 |