SQL Server Performance Tuning

Light Weight Monitoring using Extended Events

Introduction SQL Server 2008 introduces Extended Events for performance monitoring. SQL Server Extended Events is a general event-handling system for server systems. So  why another event handling system? We already have activity monitor, Perfmon, SQL Profiler, DMVs,. However, Extended Events have several major advantages: 1. Light Weight. This is the primary advantage of  Extended Events. […]

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

When searching the Web for solutions to use SQL Server 2005’s Integration Services to convert and load EBCDIC (IBM Mainframe) data, many will hit a massive roadblock. Through exhaustive searches you may be able to return a minimal amount of information, none of which will likely pertain to performance tuning once a conversion solution is […]

Procedures to Performance Tune SQL Server

A SQL Server database administrator (DBA) will be aware of server enhancement techniques to ensure the smooth running of the servers. Being aware of enhancement options available enables to DBA to provide the best server performance to users and clients without interruptions or outages. The ability to identify the faulty component in a SQL Server […]

SQL Server Performance Tuning Basics

There are several factors that affect the performance of an application. This includes SQL Server (the program itself), the SQL Server configuration settings, the application’s Transact-SQL Code, the operating system (server and client), the hardware (server and client), the network hardware and bandwidth (LAN and WAN), the number of clients, client usage patterns, type and […]

Advantages And Disadvantages of Clustering SQL Server

Just think, you have experienced a motherboard failure on a critical SQL Server and you do not know how long it will take to fix it. This of course will affect your business due to the interruption in the abilty to process sales as well as the productivity of your business. Moreover, this situation will leave you totally stressed in […]

Identify Missing Indexes Using SQL Server DMVs

Performance tuning is one of the major that database administrators need to perform when supporting very large databases. Analysis of present index usage is an initial stage of performance tuning. In the previous article titled Are Your Indexes Being Used Effectively?, how to check whether all the indexes on a table are used effectively or […]

Obtaining Index Usage Information

When building an application there are a number of things that are important.  The first is having a good database design; a database structure that is easy to use and query.  Performance is another, a measure of performance it is how quickly your applications are able to retrieve and update required data.  A key component […]

Max Degree of Parallelism

When SQL Server runs on a computer with more than one microprocessor/CPU or on SMP (a computer-architecture where two or more identical processors can connect to a single shared main memory and I/O and can perform the same functions. In case of multi-core processors, the SMP architecture applies to the cores, treating them as separate […]

How to Create a Comma Separated Delimited Text File Using SQL Server 2008

Database Administrators and SSIS Developers have always come across scenarios where you need to create a comma separated delimited text file for very large tables in SQL Server 2008. Once the delimited text file is generated the files can be compressed and they can be easily FTP to client locations. This is one among the […]

Creating Your Own Custom Data Collections

In my last couple of articles (http://sql-server-performance.com/articles/per/Management_Data_Warehouse_p1.aspx and http://www.sql-server-performance.com/articles/per/System_Data_Collection_Reports_p1.aspx) I discussed the Management Data Warehouse (MDW) a new feature that collects and manages statistics that came out with SQL Server 2008.  In those articles I described how to install the components that make up the MDW, the system data collections, and the history reports that […]