Transaction Locking and Row Versioning Guide Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, …
Operating system task scheduling Threads are the smallest units of processing that can be executed by an operating system, and allow the application logic to be separated into several concurrent execution paths. Threads are useful when complex applications have many tasks that can be performed at the same time. When an operating system executes an …
SQL Server Index Architecture and Design Guide Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse Poorly designed indexes and a lack of indexes are primary sources of database application bottlenecks. Designing efficient indexes is paramount to achieving good database and application performance. This SQL Server index design guide …
Query Processing Architecture Guide Applies to: SQL Server (all supported versions) Azure SQL Database The SQL Server Database Engine processes queries on various data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following topics cover how SQL Server processes queries and optimizes query reuse through execution plan caching. Execution modes …
Post-migration Validation and Optimization Guide Applies to: SQL Server (all supported versions) SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload. Common Performance Scenarios Below are some of the common performance scenarios encountered after migrating to SQL Server Platform and how …
Post-migration Validation and Optimization Guide Read More »
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of eight physically contiguous pages. Extents help efficiently manage pages. This guide describes the data structures that are used to manage pages and extents in all versions of SQL Server. Understanding the architecture of pages and extents is …
This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads. As the number of CPU cores on servers continues to increase, the associated increase in concurrency can introduce contention points on data structures that must be accessed in a serial fashion …
Diagnose and resolve latch contention on SQL Server Read More »
Kellyn Gorman is an Azure Data Platform Architect for Microsoft with a long history in multi-platform technology. She spends a 60/40% split between Oracle on Azure and Analytics with her present team at Microsoft. A recent Idera ACE, a current friend of Redgate in the Microsoft community and an Oracle ACE Director alumnus, she has …
Microsoft SQL Server 2019 powers your organization by providing a data hub that you can use to access structured and unstructured data sources from across your entire data estate through a consistent interface. The relational database engine scales to petabytes of data, and enhancements to PolyBase allow you to process diverse big data and relational …
Windows Server and Microsoft SQL Server teams are collaborating closely to ensure that the combination of theseproducts is greater than the sum of their parts. IT decision makers can take advantage of a better enterprise dataplatform enabled by several key Windows Server 2016 features working in concert with SQL Server 2016 features.Both products offer best-in-class …
SQL Server 2016 and Windows Server 2016: Better Together Read More »
Copyright © 2002-2023 Srinivas Maddali, All rights reserved.