SQL Server Articles from sql-server-performance.comMeasure TSQL Statement Performance Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.
The “sys.dm_os_performance_counters” Dynamic Management View SQL Server performance can be tracked and monitored by using performance counters. For SQL Server 2005 performance counters can be displayed by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV).
Index related DMVs and DMFs - sys.dm_db_index_usage_stats Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats
Index related DMVs and DMFs This article deals with some important index-related output columns that are returned by the function, dm_db_index_physical_stats which returns information on the size and fragmentation of tables and indexes.
Reduce Aggravating Aggregation: Improve the Performance of History or Status Tables Optimize the performance of a database which includes history or status tables.
CLR Integration in SQL Server 2005 The integrated CLR allows SQL Server developers to write stored procedures and user defined data-types using a .NET language such as C# or VB
Working with XML Data in SQL Server 2005 SQL Server 2005 features vastly improved handling of XML data, this article explores the methods of handling and storing XML data in SQL Server 2005.
Database Mirroring in SQL Server 2005 Mirroring allows a user to create an exact copy of a database on a different server. This article outlines how to implement mirroring in SQL Server 2005.
Analysis Services in High Data Volume Business scenarios Benchmarking the performance improvements using parallel processing of OLAP cubes.
Online Indexing in SQL Server 2005 In SQL Server 2005, DBAs can create, rebuild, or drop indexes online. The index operations on the underlying table can be performed concurrently with update or query operations. This was not possible in previous versions of SQL Server.
Making the Most Out of the SQL Server 2005 Performance Dashboard The SQL Server 2005 Performance Dashboard is a new add-on to SQL Server 2005. It is a custom report (custom reports are a new feature of Service Pack 2) for Management Studio that gathers data from the many Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) available in SQL Server 2005. By Brad M. McGehee.
Benchmarking SQL Server 2005 Covering Indexes The focus of this article is to find out what will happen when running a query, without any indexes, with non-clustered indexes, and with covering indexes. By Dinesh Asanka.
Using Asynchronous Statistics Updating in SQL Server 2005 Most DBAs are familiar with the AUTO_UPDATE_STATISTICS database option. Under most conditions, this feature provides the Query Optimizer with up-to-date index and column statistics so that optimum query plans can be created to execute queries. But what many DBAs don't know is how this option affects the performance of queries. By Brad M. McGehee.
Forced Parameterization in SQL Server 2005 For applications that use mostly simple queries, the default simple parameterization of SQL Server 2005 may be more than adequate to meet your performance expectations. For applications that use mostly complex queries, however, there is a new feature in SQL Server 2005 called forced parameterization that can tell SQL Server to force the parameterization of virtually all SELECT, INSERT, UPDATE and DELETE statements. By Brad M. McGehee.
Encrypting Your Valuable Data With SQL Server 2005: Part 1 In SQL Server 2005, security has improved for authentication, authorization, and encryption. Encryption is so much improved that it is almost a new feature in SQL Server 2005.
Encrypting Your Valuable Data With SQL Server 2005: Part 2 After reading Part I in this series, you will have an architectural understanding of data encryption in SQL Server 2005. In this article, we will discuss the real implementation of it.
An Instance of SQL Server 2000 Performance Tuning This article is about altering a table and adding NOT NULL columns into it … I tried a new approach for this by which I created a new table using the SELECT INTO command and within this command included new columns as well by joining with the old table. This took less than 1/10th of the time compared to the standard approach. By Sunil Madan.
Handling Cursor-Friendly Problems in T-SQL: Running Totals Example A typical "cursor friendly" problem is one where the data set returned contains at least one column whose value depends on column values from one or more previous rows of the same row set. Even when a data set based solution exists, it is hard to build a query that is more efficient than a cursor based solution.
Scripts for Space Monitoring Report Scripts to complement the 'Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers' article.
Boost Performance and Reduce Code Use With SQL Server Aggregate Functions This article will acquaint you with aggregate functions such as MIN, MAX, COUNT, and AVG, which easily let you perform tasks that you may have thought needed extensive programming codes to accomplish.
Clustered Indexes in SQL Server: Things You Need to Know This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I'll also give you some tips on how to use them in a not so obvious context.
Using TRY/CATCH to Resolve a Deadlock in SQL Server 2005 The TRY/CATCH method is powerful enough to handle the exceptions encountered in your code irrespective of how deeply nested the application is in a stored procedure.
Finding Duplicate Indexes in Large SQL Server Databases Learn how to identify duplicate indexes in a database.
No comments:
Post a Comment