Performance Tuning Archives - {coding}Sight https://codingsight.com/category/database-administration/performance-tuning/ Blog for SQL Server DBAs and Developers Sat, 12 Aug 2023 07:13:17 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Performance Tuning Archives - {coding}Sight https://codingsight.com/category/database-administration/performance-tuning/ 32 32 How to Use AI for SQL Tuning for a Real Automated Process https://codingsight.com/how-to-use-ai-for-sql-tuning-for-a-real-automated-process/ Thu, 26 Aug 2021 07:19:40 +0000 http://codingsight.com/?p=16381 The rapid evolution in development from rigidly structured data to responsive, flexible databases allows database administrators (DBAs) to work closely with developers. DBAs are often tasked with finding ways to make applications run faster and more efficiently. Utilizing artificial intelligence (AI) for SQL tuning helps DBAs create a truly automated process that significantly streamlines their …

The post How to Use AI for SQL Tuning for a Real Automated Process appeared first on {coding}Sight.

]]> SQL Server Transactional Replication Issues https://codingsight.com/sql-server-transactional-replication-issues/ Fri, 16 Jul 2021 08:15:38 +0000 http://codingsight.com/?p=15434 We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos to understand frequently faced Replication performance issues and how to troubleshoot them correctly. We have already discussed such problems as Configuration issues, Permission issues, Connectivity issues, and Data Integrity issues along with troubleshooting …

The post SQL Server Transactional Replication Issues appeared first on {coding}Sight.

]]> A Simple Use Case for Indexes on Primary Keys https://codingsight.com/primary-and-foreign-keys-for-sql-derver-performance-tuning/ https://codingsight.com/primary-and-foreign-keys-for-sql-derver-performance-tuning/#comments Mon, 14 Jun 2021 15:13:58 +0000 http://codingsight.com/?p=14676 Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a serious rate. The transaction table used to capture these transactions became a hot table. As a result, the problem showed up in the application layer. It was an intermittent timeout of the session seeking to …

The post A Simple Use Case for Indexes on Primary Keys appeared first on {coding}Sight.

]]> https://codingsight.com/primary-and-foreign-keys-for-sql-derver-performance-tuning/feed/ 3 MS SQL Server on Linux vs Windows Performance Test to Spot the Difference https://codingsight.com/sql-server-2019-windows-vs-linux-and-simple-test-scenario-to-spot-difference/ Fri, 30 Apr 2021 09:11:19 +0000 http://codingsight.com/?p=13434 Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game. It enabled a whole new world of possibilities for their famous relational database, offering what was only available in the Windows space until then. I know that a purist DBA would tell me right away that the out …

The post MS SQL Server on Linux vs Windows Performance Test to Spot the Difference appeared first on {coding}Sight.

]]> Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance https://codingsight.com/sql-query-optimization-5-core-facts-to-boost-queries/ Wed, 31 Mar 2021 16:48:05 +0000 http://codingsight.com/?p=12665 What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases. But when you’re just starting to level up your game with queries, you need something simpler to rely on. This is the goal of this article. You might say your queries are …

The post Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance appeared first on {coding}Sight.

]]> 9 Best Practices for Writing SQL Queries https://codingsight.com/sql-query-optimization-tips/ Mon, 29 Mar 2021 12:31:11 +0000 http://codingsight.com/?p=12647 If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many ways to execute a SQL query to get desired results on your database. However, not all SQL queries are created equal. Most can be optimized to follow the SQL query …

The post 9 Best Practices for Writing SQL Queries appeared first on {coding}Sight.

]]> 22 Different T-SQL Indexes Examples to Warp Speed Your Queries https://codingsight.com/22-nifty-sql-index-examples-to-warp-speed-your-queries/ Tue, 09 Mar 2021 11:30:31 +0000 http://codingsight.com/?p=12234 Indexing the database tables is one of the ways to up your game in tuning queries. How do you do it? Today’s post will give you 22 SQL index examples of SQL query optimization to run your queries in a flash. You can add an index using CREATE TABLE along a column, or in the …

The post 22 Different T-SQL Indexes Examples to Warp Speed Your Queries appeared first on {coding}Sight.

]]> How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective https://codingsight.com/how-cte-can-aid-in-writing-complex-powerful-queries-performance-perspective/ Fri, 20 Nov 2020 12:49:37 +0000 https://codingsight.com/?p=10672 We often see poorly written complex SQL queries running against a table or tables in databases. Those queries make the time of execution very long and cause consuming huge CPU and other resources. Still, complex queries provide valuable information to the application/person running them in many cases. Therefore, they are useful assets in all varieties …

The post How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective appeared first on {coding}Sight.

]]> How To Create SQL Trace To Capture SQL Server Events https://codingsight.com/how-to-create-a-sql-trace-to-capture-sql-server-events/ Wed, 21 Oct 2020 15:43:35 +0000 https://codingsight.com/?p=10353 Facing an SQL Server performance issue, you need to identify the source of that performance problem fast. Therefore, a tool for tracking the current workload and detecting the bottleneck issues without causing extra load is necessary. SQL Server provides various tools to collect the SQL Server events. For instance: The SQL Trace tool, introduced in …

The post How To Create SQL Trace To Capture SQL Server Events appeared first on {coding}Sight.

]]> 3 Nasty I/O Statistics That Lag SQL Query Performance https://codingsight.com/3-nasty-i-o-statistics-that-lag-sql-query-performance/ https://codingsight.com/3-nasty-i-o-statistics-that-lag-sql-query-performance/#comments Thu, 24 Sep 2020 08:35:31 +0000 https://codingsight.com/?p=10000 “But it ran fine on our development server!” How many times did I hear it when SQL query performance issues occurred here and there? I said it myself back in the day. I presumed that a query running in less than a second would run fine in production servers. But I was wrong. Can you …

The post 3 Nasty I/O Statistics That Lag SQL Query Performance appeared first on {coding}Sight.

]]> https://codingsight.com/3-nasty-i-o-statistics-that-lag-sql-query-performance/feed/ 1