Performance Tuning Archives

Oct 12

Using Extended Events to Find Statement Causing a Job to Run Long or Hang

By Lori Brown | Extended Events , Helpful Scripts , Jobs , Performance Tuning , SQL Administration , SQL Server

On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete. I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang. Since the issue only occurred intermittently, […]

Aug 15

Adding a Missing Index Killed Performance

By Jeffry Schwartz | Indexes , Missing Indexes , Performance Tuning , Query Tuning , SQL Server

SQL Server 2017 suggested an index to improve performance, so we added it in a development environment. The “improvement” made the query run almost 50 TIMES longer than the original! See how we fixed this issue.

Mar 07

Should I Replace My FOR XML PATH String Merges with String_agg?

By Jeffry Schwartz | Function , Performance Tuning , Query Tuning , SQL Development , SQL Server

If you are looking for major performance gains, the answer is no. However, if you are using SQL Server 2017 and developing new code, you should consider using the new String_agg function that is available on SQL Server 2017 because code that uses this function is so much more readable and easier to write and […]

Feb 14

Are All Delimited-String Parsers Created Equal?

By Jeffry Schwartz | Function , SQL 2016 , SQL Development , SQL Server

Overview In short, no. However, for many years there was no alternative to the T-SQL option, and even when there were other viable options, it was unclear whether it was worth changing existing code to take advantage of the new technologies. With the addition of the string_split function in SQL Server 2016, it is worth […]

Jan 17

Troubleshoot SLEEP_TASK Wait Type

By Ginger Daniel | Miscellaneous , Performance Tuning , Query Tuning , SQL Development , SQL Server

Jobs on a SQL server can take milliseconds or minutes to complete depending on the size and complexity of your query and also the SQL environment on which it’s executing. It’s important to have a baseline or at least be familiar with the normal amount of time your SQL jobs take to execute. For a […]

Jul 26

How to Break an Existing Single Database File Into Multiple Files

By Lori Brown | Performance Tuning , SQL Administration , SQL Server

I occasionally come across some pretty good sized databases that are set up with a single data file. We recently have been working with a client to break up their single data file into multiple data files so that we can spread them over several different LUNs and so that they can take advantage of […]

Jul 13

AlwaysOn 2016 – Encrypted Databases and Performance

By Ginger Daniel | Encryption , SQL Administration , SQL Server

It is common knowledge that encrypting a database causes degraded performance in a SQL server. In an AlwaysOn environment performance can be even more sluggish because there is the extra element of data replication latency. How much difference does it really make? Of course the answer is “it depends” on your environment and your workload. […]

Sep 08

Deadlock Info From system_health Information

By Lori Brown | Beginner , Helpful Scripts , SQL Administration , SQL Server

— by Lori Brown @SQLSupahStah Periodically, all DBA’s are going to run into code that fails due to a deadlock. Deadlocks happen when two or more SPIDs\sessions try to access a resource that is locked by each other. In short, something has to give so one is usually chosen by SQL to be the victim […]

Apr 28

How SQLRX Can Help You When Tools Do Not

By SQLRx Admin | Advice , Miscellaneous , Offer , SQL Server , SQLRX

For those of you who visit our humble blog from time to time and have never actually checked out our website (www.sqlrx.com) to get acquainted with what we do, please allow me to check that box for you. SQLRX is part of a Dallas, Texas based consulting company called Integrated Services Inc (ISI). The SQLRX […]

1 2 Next »

Tag Archives for " Performance Tuning "