SQL Server Performance Tuning

SQL Server High-Availability with Virtualisation

SQL Server associated applications and data are often mission-critical to the operation of a business. While protecting SQL Server and its databases is a top priority for IT departments, it’s often not enough. If the applications residing on SQL are not also protected, there is a risk that business operations will be disrupted. The complexity […]

Are Your Indexes Being Used Effectively?

In this fast moving world, data is the heart and soul of any enterprise. As the data is growing very rapidly day by day, the biggest challenge which enterprises face today is to store the data in such a way that it can be retrieved quickly whenever required. The most common thought which comes in […]

Speeding up the Performance of Table Counts in SQL Server 2005

Introduction When we want to get the row count of a table, we use the transact-SQL function count (*).  In the case of large table which may contain millions of rows, it can take a long time to return the row count of the whole table, and that leads to slow performance for the query. Count () function Every DBA know […]

Characterizing I/O Workload

In order to determine an application’s ideal storage system and disk quantity, it’s important to understand the type and volume of I/O the application will generate. This article will focus on the different types of I/O, the metrics used to classify workload, and methods used in measuring and estimating values for the I/O metrics. OLTP […]

Resource Governor in SQL Server 2008

SQL Server 2008 introduces a new feature called Resource Governor which enables Database Administrators to manage SQL Server workload and critical system resource consumption. Resource Governor enables DBA to specify limits on the amount of CPU and memory which the incoming sessions to the SQL Server can use. In a production environment DBA’s will come across scenarios […]

SQL Server Performance Coding Standards

1. Avoid using “*” in SELECT queries Always specify the required list of columns in the select list. This will ensure that only the columns required by the query are returned to avoid unnecessary I/O and processing.   2. Always use variables of the appropriate data type and size Use appropiate data types to avoid implicit data type conversion being perfromed […]

System Data Collection Reports

In my last article (http://sql-server-performance.com/articles/per/Management_Data_Warehouse_p1.aspx) I introduced one of the new SQL Server 2008 features known as the Management Data Warehouse (MDW).  In that article I described how to install the components that make up the MDW.  Now I’m going to expand on the subject and write about the rich reporting capabilities that Microsoft has […]

Breaking Down Complex Execution Plans

As a DBA, whether working as a full time employee of a company or as a consultant, you’re often handed stored procedures or queries long after they’ve been “finished.” These finished queries are frequently enormous, free-flowing affairs with between 50 and 500 statements joining up to 80 tables, views, derived tables and functions. Together they […]

How SQL Cluster Resource DLLs work with Cluster Components to Improve the Failover Process

The objective of this article is to explain the SQL Server clustering internal process.  This article will explain the functions used to interact with the cluster components. The article doesn’t really show how to cluster SQL Server. Most of this article talks about SQL Server 2000 but the same information applies to later versions of SQL […]

SQL Server 2008’s Management Data Warehouse

I’ve been on a performance kick lately.  I’ve been sharing with you how to use SQL Server 2005 DMVs and DMFs to identify the resource intensive queries for SQL Server 2005.  Well now I’m going to switch gears and look at SQL Server 2008 and discuss one of the new concepts known as Management Data […]
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 |