performance Archives - {coding}Sight https://codingsight.com/tag/performance/ Blog for SQL Server DBAs and Developers Wed, 11 Oct 2023 06:22:57 +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 Archives - {coding}Sight https://codingsight.com/tag/performance/ 32 32 dbForge Edge: Your Best Universal Tool for Multidatabase Challenges https://codingsight.com/introducing-dbforge-edge/ Tue, 06 Jun 2023 11:34:26 +0000 https://codingsight.com/?p=24719 Handling several database management systems simultaneously is inevitable in working on multiple projects. At the same time, each system requires a proper set of relevant tools to perform database tasks. These tools should be powerful and flexible enough to adapt to the project’s evolving needs. One moment, your goal is to design a new database …

The post dbForge Edge: Your Best Universal Tool for Multidatabase Challenges 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 Top 3 Tips You Need to Know to Write Faster SQL Views https://codingsight.com/top-3-tips-you-need-to-know-to-write-faster-sql-views/ Thu, 03 Dec 2020 11:37:37 +0000 https://codingsight.com/?p=11061 Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year using SQL Server. They said it was bad because it was slow. But how about today? Are you on the same boat as I was many years ago? Then, join me on this journey to …

The post Top 3 Tips You Need to Know to Write Faster SQL Views 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.

]]> Workplace Encounters: Reclaiming Space from an Oversized Database https://codingsight.com/workplace-encounters-reclaiming-space-from-an-oversized-database/ Fri, 21 Aug 2020 11:02:25 +0000 https://codingsight.com/?p=9760 INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23rd April 2015. The details are specific to an application, but the principles may be useful to others in need of doing similar operations in production. BACKGROUND The database had grown to over 1.44TB …

The post Workplace Encounters: Reclaiming Space from an Oversized Database appeared first on {coding}Sight.

]]> SQL Server Lock Escalation https://codingsight.com/sql-server-lock-escalation/ Mon, 17 Aug 2020 07:50:52 +0000 https://codingsight.com/?p=9757 Introduction Relational databases follow the ACID properties in how they implement transactions – Atomicity, Consistency, Isolation, and Durability. Isolation is necessary to ensure that multiple transactions can’t cause changes to data and leave the eventual results inconsistent. To guarantee that the operations remain isolated, SQL Server applies Locking mechanisms. Lock Modes and Hierarchy SQL Server’s …

The post SQL Server Lock Escalation appeared first on {coding}Sight.

]]> Update SQL Server statistics using a database maintenance plan https://codingsight.com/update-sql-server-statistics-using-a-database-maintenance-plan/ Mon, 08 Jul 2019 00:00:41 +0000 https://codingsight.com/?p=7295 Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a DBA to manage the database backup and make sure the integrity of the backups. So if something goes wrong with a production database, it can be recovered with minimum downtime. The database integrity checks …

The post Update SQL Server statistics using a database maintenance plan appeared first on {coding}Sight.

]]> Overview of Data Compression in SQL Server https://codingsight.com/overview-of-data-compression-in-sql-server/ Thu, 06 Dec 2018 10:00:55 +0000 https://codingsight.com/?p=5760 The database is a critical and vital part of any business or organization.  The growing trends predict that 82% of enterprises expect the number of databases to increase over the next 12 months. A major challenge of every DBA is to discover how to tackle massive data growth, and this is going to be a …

The post Overview of Data Compression in SQL Server appeared first on {coding}Sight.

]]>