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

Articles with tag Performance Tuning Rss

Search for any content tagged performance tuning

<< Newer    Items 41 to 60 of 457    Older >>
 

Performance Data

Great DBAs collect all kinds of metrics on their instances and let them manage themselves. However many administrators need help monitoring and interpreting the data. Today Steve Jones asks if you think this data needs extra security or is it less of an issue than other PII data.  Read more...
By Steve Jones 2012/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 351 reads

Single User Performance of SQLite v. SQL Server

A look at the performance of SQL Server compared to SQLite for single user applications.  Read more...
By Timothy A Wiseman 2012/07/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,236 reads

Get Performance Tips Directly From SQL Server

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,624 reads

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/14 (first published: 2012/06/19) | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 7,337 reads

SQL Server Prefetch and Query Performance

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning.   Read more...
By Additional Articles 2012/06/14 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 3,748 reads

ETL Performance Auditing - Part 2: Auditing Data Staging Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/07 (first published: 2012/06/12) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,207 reads

Re-compilation and Its effects on Performance

How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?   Read more...
By at yazdani 2012/06/07 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,102 reads

The Real World: Implementing AWE

Describes the gains experienced in my environment by impleenting AWE.  Read more...
Rating: |  Discuss |   Briefcase | 7,950 reads

Performance Test of New Date Manipulation Functions (SQL Spackle)

Performance test of new SQL 2012 functions DateTimeFromParts and Format  Read more...
By Wayne Sheffield 2012/05/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,920 reads

The Clonesome Database

You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....  Read more...
By Phil Factor 2012/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 199 reads

What's the Point of Using VARCHAR(n) Anymore?

The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.  Read more...
By Additional Articles 2012/02/15 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,753 reads

Tips to Optimize Your SQL Statements - Part 1

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.  Read more...
By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 44,469 reads

Database Performance Transparency

Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.  Read more...
By Ron Johnson 2012/02/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,802 reads

A Computed Column Defined with a User-Defined Function Might Impact Query Performance

A benefit of using computed columns is that they can save developers from having to write calculation logic at the application layer; at the table level, the application can simply reference the computed column. In addition, performance can be improved by persisting a computed column and building an index on it.  Read more...
By Additional Articles 2012/02/03 | Source: SQLCAT | Category: computed columns
Rating:  Rate this |   Briefcase | 2,362 reads

Window Functions in SQL Server: Part 3: Questions of Performance

A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.  Read more...
By Additional Articles 2012/01/17 | Source: SimpleTalk | Category: window functions
Rating:  Rate this |   Briefcase | 3,475 reads

Changes to SQL Server 2012 Execution Plans

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.  Read more...
By Grant Fritchey 2011/12/14 | Source: SQLServerCentral.com | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 6,130 reads

Finding the Source of Your SQL Server Database I/O

There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.  Read more...
By Additional Articles 2011/11/22 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 3,449 reads

Performance Monitoring with Dynamic Management Views

In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.  Read more...
By Ron Johnson 2011/11/17 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,998 reads

Maximizing SQL Server Throughput with RSS Tuning

Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. This post helps you get the most out of the feature.  Read more...
By Additional Articles 2011/10/18 | Source: SQLCAT | Category: rss
Rating:  Rate this |   Briefcase | 2,273 reads

A Performance Troubleshooting Methodology for SQL Server

When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between symptom and disease: The art of troubleshooting is much more the art of discovering, and assembling, the various pieces of the puzzle so that you have a complete understanding of what is going on inside of a server.  Read more...
By Additional Articles 2011/10/10 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 5,451 reads
<< Newer    Items 41 to 60 of 457    Older >>