SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Performance Rss

Search for any content tagged performance

   Items 1 to 20 of 73    Older >>
 

Monitor Query Performance Using Query Store in SQL Server

The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.  Read more...
By Additional Articles 2018/04/12 | Source: Database Journal | Category: query performance
Rating:  Rate this |   Briefcase | 3,978 reads

Small Changes and Big Impacts

Using new features and changing code can cause problems in your environment. Always test to be sure that the impact is acceptable.  Read more...
By Steve Jones 2018/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count

Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use.  Read more...
By Additional Articles 2018/03/26 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 2,808 reads

Balancing Performance and Readability

Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.  Read more...
By Gary Pollock 2018/03/20 | Source: SQLServerCentral.com | Category: coding style
Rating: |  Discuss |   Briefcase | 761 reads

"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.  Read more...
By Additional Articles 2018/02/23 | Source: Brent Ozar Unlimited Blog | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 6,115 reads

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 839 reads

We Need DevOps for Performance

CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.  Read more...
By Steve Jones 2017/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.  Read more...
By Additional Articles 2017/11/02 | Source: SimpleTalk | Category: performance
Rating:  Rate this |   Briefcase | 6,405 reads

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...
By Paul Brewer 2017/10/19 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 805 reads

WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.  Read more...
By Kenneth Igiri 2017/10/10 | Source: SQLServerCentral.com | Category: wait events
Rating: |  Discuss |   Briefcase | 884 reads

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.  Read more...
By Additional Articles 2017/09/20 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,972 reads

Five Mistakes Performance Tuners Make

Erik Darling explains why your queries aren't scaling in production.  Read more...
By Additional Articles 2017/09/06 | Source: Brent Ozar Unlimited Blog | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,173 reads

Performance Myths : Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/08/02 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 7,816 reads

Performance Myths: Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/07/13 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 7,438 reads

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.  Read more...
By Additional Articles 2017/06/20 | Source: SQLPerformance.com | Category: trace flags
Rating: (not yet rated)  Rate this |   Briefcase | 4,625 reads

UNION ALL Optimization

Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.  Read more...
By Additional Articles 2017/06/13 | Source: SQLPerformance.com | Category: union all
Rating: (not yet rated)  Rate this |   Briefcase | 5,758 reads

Performance Myths : Truncate Can't Be Rolled Back

Derik Hammer sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.  Read more...
By Additional Articles 2017/06/01 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 4,508 reads

Combining R and SQL Server to diagnose performance bottlenecks

Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.  Read more...
By Nick Burns 2017/05/29 (first published: 2015/12/07) | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 9,137 reads

Performance Myths: Table variables are always in-memory

Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.  Read more...
By Additional Articles 2017/05/11 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,575 reads

Harmful, Pervasive SQL Server Performance Myths

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.  Read more...
By Additional Articles 2017/04/13 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,592 reads
   Items 1 to 20 of 73    Older >>