Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 2005, Performance Tuning Rss

<< Newer    Items 21 to 40 of 58    Older >>
 

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,486 reads

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,409 reads

The Ultimate Index Lister (Non-Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.  Read more...
By Jesse Roberge 2013/10/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,576 reads

The Ultimate Missing Index Finder

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.  Read more...
By Jesse Roberge 2013/01/07 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,648 reads

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 that became available shortly after the release of Service Pack 2 for SQL Server 2005.  Read more...
Rating:  Rate this |   Briefcase | 7,820 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,134 reads

Top Queries in SQL Server 2005

This article illustrates how to query dynamic management views to find the TOP queries based on average CPU and average I/O.  Read more...
By Additional Articles 2008/04/09 | Source: Database Journal | Category: sql server 2005
Rating:  Rate this |   Briefcase | 6,191 reads

Predeployment I/O Best Practices

The I/O system is important to the performance of SQL Server. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system, it is good practice to determine the capacity of the I/O subsystem prior to deploying SQL Server. This white paper discusses validating and determining the capacity of an I/O subsystem. A number of tools are available for performing this type of testing. This white paper focuses on the SQLIO.exe tool, but also compares all available tools. It also covers basic I/O configuration best practices for SQL Server 2005.  Read more...
By Additional Articles 2008/01/04 | Source: TechNet Blogs | Category: sql server 2005
Rating:  Rate this |   Briefcase | 2,678 reads

Indexing in SQL Server 2005

How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.   Read more...
By Aaron Ingold 2007/01/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,570 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,448 reads

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).  Read more...
By Additional Articles 2007/12/05 | Source: SQL Server Performance | Category: sql server 2005
Rating:  Rate this |   Briefcase | 2,393 reads

SQL Server Indexes: The Basics

Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch.  Read more...
By Additional Articles 2007/12/04 | Source: SQLTeam.com | Category: indexing
Rating:  Rate this |   Briefcase | 5,386 reads

Troubleshooting Performance Problems in SQL Server 2005

It is not uncommon to experience the occasional slow down of a SQL Server database. A poorly designed database or a system that is improperly configured for the workload are but several of many possible causes of this type of performance problem.  Read more...
By Additional Articles 2007/11/22 | Source: Microsoft MSDN | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 4,537 reads

SQL Server 2005 Database Options and Configuration Performance Audit Checklist

As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.  Read more...
By Additional Articles 2007/11/16 | Source: SQL Server Performance | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 3,936 reads

Introduction to Parameterization in SQL Server

In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL   Read more...
By Additional Articles 2007/08/14 | Source: SQLTeam.com | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,069 reads

What Query Plans are in SQL Server's Memory?

SQL Server memory is primarily used to store data (buffer) and query plans (procedure cache). In this article I'll show how much memory is allocated to the procedure cache (RAM). I'll explain how to determine what plans are in the cache and how often they're used.  Read more...
By Additional Articles 2007/08/10 | Source: SQLTeam.com | Category: performance tuning
Rating:  Rate this |   Briefcase | 3,168 reads

Custom reports in Management Studio, using the Performance Dashboard

If you are using SSMS and SQL Server 2005 SP2, You've probably tried out the database reports that are available in the Performance Dashboard, and decided how useful they are, but did you know that you can create your own dashboard reports?   Read more...
By Additional Articles 2007/08/07 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,267 reads

What Data is in SQL Server's Memory?

SQL Server memory is primarily used to store data (buffer) and query plans (cache). In this article I'll show how much memory is allocated to the data buffer (or RAM). I'll explain how to determine what tables and indexes are in the buffer memory of your server.  Read more...
By Additional Articles 2007/08/03 | Source: SQLTeam.com | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,236 reads

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 that became available shortly after the release of Service Pack 2 for SQL Server 2005.  Read more...
Rating:  Rate this |   Briefcase | 7,820 reads

Parallel Statistics Update

Full scan statistics update can be slow and expensive on a large system, and a single update statistics job for a whole database can easily exceed an overnight maintenance window. This article looks at jobs that could update statistics on the system in parallel.  Read more...
Rating:  Rate this |   Briefcase | 1,954 reads
<< Newer    Items 21 to 40 of 58    Older >>
 
Tags
administration (13)    
t-sql (13)    
utility (11)    
indexing (10)    
maintenance and management (10)    
maintenance (9)    
list indexes (5)    
pivot (5)    
sql server 7 (5)    
sys.dm_db_partition_stats (5)    
crosstab (4)    
for xml path (4)    
sql server 2008 (3)    
lock and connection management (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
troubleshooting (2)    
.net (1)    
advanced querying (1)    
auditing (1)    
backup / restore (1)    
blogs (1)    
compression (1)    
duplicate indexes (1)    
foreign keys (fk) (1)    
hardware (1)    
large data sets (1)    
missing indexes (1)    
profiler (1)    
programming (1)    
query performance (1)    
row_number() (1)    
search (1)    
selectivity (1)    
sql server (1)    
sql server agent (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_tran_session_transactions (1)    
tables (1)    
xml (1)