Author: stevestedman

Replication in SQL Server is a powerful feature that allows you to copy and distribute data and database objects from one database to another and keep them synchronized. This is especially useful for scenarios like load balancing, high availability, or geographically distributed databases. Understanding the types of Replication available in SQL Server is crucial for choosing the right method to fit your specific needs. In this post, we’ll explore the three primary types of replication in SQL Server: Snapshot Replication, …

What Are the 3 Types of Replication in SQL Server? Read more »

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. The Risks of Storing User Tables in MSDB: Insights from Database Health Monitor Managing SQL Server effectively requires following best practices and avoiding common pitfalls that can impact performance, security, and maintenance. One often-overlooked issue is the practice of storing user tables in the MSDB database. While it may seem convenient at first, this approach introduces multiple …

Risks of Storing User Tables in MSDB Read more »

Common Uses of TempDB in SQL Server TempDB is one of the most critical system databases in SQL Server. It serves as a globally available, temporary storage area used by the SQL Server Database Engine for various operations. Unlike other databases, TempDB is recreated each time SQL Server restarts, ensuring that no persistent data is stored. Due to its frequent and intensive use, TempDB performance is crucial to overall SQL Server Performance. Below are the most common uses of TempDB: …

Common Uses of TempDB? Read more »

Tidying Up Your SQL Server: Removing Leftover DTA Tables SQL Server administrators and developers often use the Microsoft Database Tuning Advisor (DTA) to analyze and enhance database performance. While DTA is an effective tool, it tends to leave behind monitoring tables in the msdb database after its use. Why Do These Tables Exist? When you run the Database Tuning Advisor, it creates temporary tables to store analysis data. If DTA doesn’t clean up properly due to an interrupted session or …

Leftover Databse Tuning Advisor Tables Read more »

Mastering SQL Server Performance: The Power of Cost Threshold for Parallelism In the intricate dance of SQL Server performance tuning, few settings wield as much influence as the Cost Threshold for Parallelism (CTFP). This unassuming configuration parameter is a linchpin in determining how SQL Server harnesses the power of parallel query execution—spreading workloads across multiple CPU cores to boost speed. But like any powerful tool, it’s a double-edged sword: wield it wisely, and you unlock blazing performance; misuse it, and …

SQL Server: Cost Threshold for Parallelism Read more »

Understanding the LOGMGR_RESERVE_APPEND Wait Type in SQL Server Need help with this wait type or others, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. Understanding the SQL Server LOGMGR_RESERVE_APPEND Wait Type In SQL Server, the LOGMGR_RESERVE_APPEND wait type occurs when a thread is waiting to reserve space in the transaction log before writing a new log record. Since the transaction log plays a crucial role in ensuring data durability, crash …

LOGMGR_RESERVE_APPEND Wait Type in SQL Server Read more »