Posts Tagged ‘Performance’
SQL Server Memory-Optimized Tables
Leveraging In-Memory Technology for Improved Performance Introduction SQL Server’s memory-optimized tables, introduced in SQL Server 2014, are designed to significantly improve performance by leveraging in-memory technology. These tables store data directly in memory, enabling faster access and reducing the need for disk-based storage. In this article, we will explore memory-optimized tables, their benefits, and how…
Read MoreSQL Server Indexing – Fill Factor
Setting Appropriate Fill Factors for Optimal Performance Introduction Indexing is an essential component of database performance tuning in SQL Server. It enables the efficient retrieval of data by creating a data structure that maps the values in a specific column or set of columns to their corresponding rows in the table. One critical aspect of…
Read MoreSQL Server Lock Escalation
Introduction SQL Server is a powerful and flexible relational database management system (RDBMS) designed to manage and store data efficiently. One of its key features is the ability to manage concurrent access to data through its locking mechanism. When multiple users or applications access data simultaneously, SQL Server must ensure data integrity and maintain the…
Read MoreSQL Server Deadlocks
Understanding and Avoiding Them Deadlocks are a common problem in all relational database systems that can lead to poor performance and even data loss (in some special cases). A deadlock occurs when two or more transactions are waiting for each other to release a resource, such as a database row or page, that they both…
Read MoreSQL Server Data Compression
A Deep Dive into Page and Row Compression Introduction As businesses continue to amass large quantities of data, efficient data management becomes increasingly important. One critical aspect of data management is data compression, which can help reduce storage costs, improve query performance, and optimize resource usage. Microsoft SQL Server, an industry-leading relational database management system…
Read MoreQuickly find long running queries and determine what’s taking so long
Today’s question is: How can I quickly find the longest running query and determine why it’s taking so long? In this video we’ll discover one of the ways we can use the Vroom Performance Suite to quickly locate a long running query, then drill in to see where its spending its time.
Read More