Memory management architecture Diagnosing latch contention Diagnosing spinlock contention Database connection network trace Installation Migrate & load data Manage, monitor, & tune Query data Reporting & Analyt
SQL Server I/O fundamentals Security cache Thread & task architecture Transaction log architecture & management guide Transaction locking & row versioning guide Optimized locking Deadlocks guide Memory management architecture Diagnosing latch contention Diagnosing spinlock contention Database connection network tra...
What is SQL Server? Connect to the Database Engine What's new? Editions and features Release notes Business continuity Database design Development Internals & architecture Overview Ghost record cleanup process Index architecture & design Pages & extents a...
Memory management architecture Diagnosing latch contention Diagnosing spinlock contention Database connection network trace Installation Migrate & load data Manage, monitor, & tune Query data Reporting & Analytics Security Tools Tutorials SQL Server on Linux SQL on Azure Azure Arc Resources Reference Download...
SQL Server 2016 Editions and features Release notes Business continuity Database design Development Internals & Architecture Installation Migrate & load data Manage, monitor, & tune Query data Reporting & Analytics Security Tools Tutorials SQL Server on Linux ...
Applies to: SQL Server, Azure SQL Database, and Azure SQL Managed Instance.Hash index architectureA hash index consists of an array of pointers, and each element of the array is called a hash bucket.Each bucket is 8 bytes, which are used to store the memory address of a link list of ...
Because SQL Server Browser receives unauthenticated UDP requests, it isn't always turned on during setup. For a description of the service and an explanation of when it turns on, see SQL Server Browser Service (Database Engine and SSAS). To use the SQL Server Browser, you must follow the ...
SQL Server memory architecture SQL Server dynamically acquires and frees memory as required. Typically, an administrator doesn't have to specify how much memory should be allocated to SQL Server, although the option still exists and is required in some environmen...
What is SQL Server? Connect to the Database Engine What's new? Editions and features Release notes Business continuity Database design Development Internals & architecture Installation Migrate & load data Manage, monitor, & tune Manage Monitor ...
you can replay previously captured traces. This tool helps identify transactions that may be deteriorating the performance of an application. This can be very useful when migrating an application from a file-based architecture to a client/server architecture, because the last step involves optimizing ...