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 21 to 40 of 452    Older >>
 

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.  Read more...
By Sarvesh Singh 2013/04/26 (first published: 2010/10/21) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,287 reads

SQLServerCentral Runs sp_Blitz - Performance Part 2

The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.  Read more...
By Steve Jones 2013/03/21 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 6,281 reads

An Orders of Magnitude Problem (T-SQL Tuning)

When a query suddenly starts taking much longer, what do you do? This story from Jerry   Read more...
By Jerry_Manioci 2013/03/13 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,769 reads

SQL Server Performance Tuning – Index Tuning

In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning  Read more...
By Additional Articles 2013/01/30 | Source: SQL Server Performance | Category: indexing
Rating:  Rate this |   Briefcase | 4,712 reads

SQLServerCentral Runs sp_Blitz - Performance Part 1

The third article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,046 reads

SQL Server T-SQL Tuning – NOT IN and NOT Exists

Following on from the previous TSQL performance tuning article in this series, we now focus on the important topic of T-SQL “Not IN” And “Not Exists “  Read more...
By Additional Articles 2013/01/16 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 6,727 reads

SQL Server T-SQL Tuning -TVF and Scalar Functions

A UDF is very convenient for centralising business logic as we can specify a set of business logic in one UDF which references multiple stored procedures and ad-hoc queries. However, they can lead to significant performance degradation due to their demands on the CPU  Read more...
By Additional Articles 2013/01/10 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 3,678 reads

How Come the Hourglass? Why Database Applications Slow Down

It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It could be, but there are other suspects that should be considered. Feodor Georgiev describes where, in the long route, to and fro', that a data request makes before returning, that things can get snarled up.  Read more...
By Additional Articles 2013/01/07 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 4,459 reads

SQLServerCentral Best Practices Clinic: Part 1

We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.  Read more...
By Brad McGehee 2012/12/25 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 22,615 reads

Performance Tuning Re-indexing and Update Statistics – A Case Study

Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.  Read more...
Rating:  Rate this |   Briefcase | 5,350 reads

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.  Read more...
By Additional Articles 2012/11/12 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,592 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,170 reads

Find out which SQL Server instance is consuming most of the CPU

We have a number of SQL Server hosts with multiple SQL Server instances. From time to time we have CPU issues, but we are not sure which instance is causing the issue. How do you find which SQL Server instance is causing CPU pressure on machine with multiple SQL Server instances? Check out this tip for ideas on how to find the correct SQL Server instance which is causing CPU pressure.  Read more...
By Additional Articles 2012/09/26 | Source: MSSQLTips.com
Rating:  Rate this |   Briefcase | 2,433 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,638 reads

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.  Read more...
By Ian Stirk 2012/08/03 (first published: 2009/09/17) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 41,999 reads

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 | 346 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,217 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,513 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 | 6,938 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,702 reads
<< Newer    Items 21 to 40 of 452    Older >>