SQL Server Performance Tuning

SQL Server Index Fragmentation and Its Resolution

While there is no doubt of the benefits of adding indexes to your tables, and for the most part you have to do little work to keep the indexes maintained, some maintenance is required as indexes can become fragmented during data modifications. This fragmentation can become a source of performance issues with your queries. So […]

An Introduction to SQL Server Query Tuning

During a recent interview to find a new job before my contract ran out, I was asked a question that took me by surprise. The interviewer simply asked me what steps I took to decide which stored procedures needed optimizing and what steps I used to optimize those queries. What took me by surprise was […]

SQL Server Application and Transact-SQL Performance Checklist

Return to Previous Article in the Series Performance Audit Checklist Transact-SQL Checklist Your Response Does the Transact-SQL code return more data than needed? Are cursors being used when they don’t need to be? Are UNION and UNION SELECT properly used? Is SELECT DISTINCT being used properly? Is the WHERE clause sargable? Are temp tables being […]

Strategies to Reduce SQL Server Blocking

No reasonable strategy for the resolution of SQL Server blocking problems can be found until one has determined the precise nature of the block. The most obvious criterion for distinguishing between different blocking issues is their average duration. The following categories emerge as a result of this division: Short-time Blocking: Average duration less than three […]

How Using the Windows 2000 Encrypted File System to Secure SQL Server Databases and Backups Affects SQL Server’s Performance

Chris is the author of the book, SQL Server for the Oracle DBA Those running Windows 2000 can take advantage of the EFS (encrypted file system) for encrypting SQL Server database and/or backup files. In some organizations, encrypting data is mandatory, and as you might expect, it can exact a performance penalty. In this article, […]

SQL Server Hardware Resource Planning

There is a growing demand for high performing, fast response applications in today’s industry. In many organizations, a SQL Server 2000 server may be dedicated for the use of one particular application. From the ground up, analyzing and determining hardware requirements best suited for individual specific applications may help these application provide the timely response […]

How to Select Indexes for Your SQL Server Tables

Indexing is one of the most crucial elements in increasing the performance of SQL Server. A well-written query will not show its effectiveness unless powered by an appropriate index or indexes on the table(s) used in a query, especially if the tables are large. Indexes exist to make data selection faster, so the focus of […]

An Interview with the Authors of SQL Performance Tuning

Peter Gulutzan and Trudy Pelzer are the co-authors of SQL Performance Tuning, a new book on how to performance tune SQL code. In this interview, the authors tell us a little about their book and offer some advice for DBAs and SQL developers. Please tell us about yourselves. PETER GULUTZAN: I worked for a few […]

SQL Server Quantitative Performance Analysis

NOTE: See bottom of page to access all of the available articles. Abstract Quantitative models for the SQL Server internal query cost formulas and the true measured query costs for basic SQL operations are presented. The internal cost formulas are used by SQL Server’s Query Optimizer to determine the execution plan based on existing indexes […]

Processor Performance, 2002

Processor performance is a complex subject and cannot be characterized in a meaningful manner with a single number or benchmark score. Some insight into the factors that influence performance can be gained by examining performance across a range of processor characteristics, including frequency, cache size, bus bandwidth, and processor architecture. The best known database benchmarks […]
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 |