How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/scripts/Performance/167047/Wed, 28 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/scripts/Performance/167047/JSON performance]]>http://www.sqlservercentral.com/questions/JSON/167414/Mon, 26 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/questions/JSON/167414/ "But It Worked in Development!" - 3 Hard SQL Server Performance ProblemsYou’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.]]>http://www.sqlservercentral.com/redirect/articles/168161/Fri, 23 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/168161/Index Fill Factor]]>http://www.sqlservercentral.com/questions/Indexing/166980/Tue, 06 Feb 2018 07:00:00 UThttp://www.sqlservercentral.com/questions/Indexing/166980/Disk Encryption and The Impact to DBAsAs 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.

How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.

]]>http://www.sqlservercentral.com/articles/Encryption/165936/Tue, 16 Jan 2018 07:00:00 UThttp://www.sqlservercentral.com/articles/Encryption/165936/Get Index Scan CountScript to get the index scan count and Average Fragmentation(since last restart)]]>http://www.sqlservercentral.com/scripts/Indices/166972/Wed, 10 Jan 2018 07:00:00 UThttp://www.sqlservercentral.com/scripts/Indices/166972/We Need DevOps for PerformanceCosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.]]>http://www.sqlservercentral.com/articles/Editorial/165066/Tue, 28 Nov 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Editorial/165066/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.]]>http://www.sqlservercentral.com/redirect/articles/163080/Thu, 02 Nov 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/163080/SQL Server Performance Benchmarking with PatternsA SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.]]>http://www.sqlservercentral.com/articles/Performance/163092/Thu, 19 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Performance/163092/WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO WaitsAn account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.]]>http://www.sqlservercentral.com/articles/wait+events/162875/Tue, 10 Oct 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/wait+events/162875/Investigating the Cause of SQL Server High CPU Load Conditions When They HappenAny 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.]]>http://www.sqlservercentral.com/redirect/articles/161554/Wed, 20 Sep 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/161554/Five Mistakes Performance Tuners MakeErik Darling explains why your queries aren't scaling in production.]]>http://www.sqlservercentral.com/redirect/articles/161568/Wed, 06 Sep 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/161568/Performance Myths : Oversizing string columnsAaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.]]>http://www.sqlservercentral.com/redirect/articles/159664/Wed, 02 Aug 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/159664/Performance Myths: Oversizing string columnsAaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.]]>http://www.sqlservercentral.com/redirect/articles/159054/Thu, 13 Jul 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/159054/Performance of OBJECT_NAME() & Co.]]>http://www.sqlservercentral.com/questions/Performance/158904/Mon, 10 Jul 2017 06:00:00 UThttp://www.sqlservercentral.com/questions/Performance/158904/Properly Persisted Computed ColumnsPaul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.]]>http://www.sqlservercentral.com/redirect/articles/158177/Tue, 20 Jun 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/158177/UNION ALL OptimizationPaul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.]]>http://www.sqlservercentral.com/redirect/articles/158176/Tue, 13 Jun 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/158176/Performance Myths : Truncate Can't Be Rolled BackDerik 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.]]>http://www.sqlservercentral.com/redirect/articles/156419/Thu, 01 Jun 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/156419/Combining R and SQL Server to diagnose performance bottlenecksUsing clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.]]>http://www.sqlservercentral.com/articles/Performance/119993/Mon, 29 May 2017 06:00:00 UThttp://www.sqlservercentral.com/articles/Performance/119993/Performance Myths: Table variables are always in-memoryGuest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.]]>http://www.sqlservercentral.com/redirect/articles/156414/Thu, 11 May 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/156414/Harmful, Pervasive SQL Server Performance MythsAaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.]]>http://www.sqlservercentral.com/redirect/articles/154485/Thu, 13 Apr 2017 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/154485/Understanding Graphical Execution Plans - Part 1: Explaining the PlanUnderstanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.]]>http://www.sqlservercentral.com/articles/Execution+Plans/105771/Fri, 10 Mar 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/Execution+Plans/105771/Finding the Worst Performing TSQL Statement Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.]]>http://www.sqlservercentral.com/redirect/articles/152951/Mon, 06 Mar 2017 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/152951/Performance Dashboard Error: Could not find stored procedure In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.]]>http://www.sqlservercentral.com/articles/SQLServer2008R2/152519/Mon, 27 Feb 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/SQLServer2008R2/152519/Performance Surprises and Assumptions : GROUP BY vs. DISTINCTAaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.]]>http://www.sqlservercentral.com/redirect/articles/152410/Thu, 23 Feb 2017 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/152410/SQL Server vs SQL Server v.NextAn introduction to the basics of current SQL Server vs v.Next Performance Testing.]]>http://www.sqlservercentral.com/articles/vnext/152671/Wed, 15 Feb 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/vnext/152671/Compression and its Effects on PerformanceErin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.]]>http://www.sqlservercentral.com/redirect/articles/152409/Wed, 15 Feb 2017 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/152409/How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query ExecutionBen Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.]]>http://www.sqlservercentral.com/redirect/articles/152418/Thu, 09 Feb 2017 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/152418/Performance of the SQL MERGE vs. INSERT/UPDATEThe SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?]]>http://www.sqlservercentral.com/articles/MERGE/103127/Fri, 03 Feb 2017 07:00:00 UThttp://www.sqlservercentral.com/articles/MERGE/103127/Disconnecting SQL Server connections after query executionOne way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS.]]>http://www.sqlservercentral.com/redirect/articles/149944/Wed, 21 Dec 2016 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/149944/