Steve Stedman

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. LCK_M_IS CXPACKET CXCONSUMER LCK_M_S PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT OLEDB RESOURCE_SEMAPHORE LCK_M_IX Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

DBCC SHRINKDATABASE is a DBCC command in Microsoft SQL Server that can be used to reduce the size of a database by moving pages of data from the end of the file to the front, and then releasing the unused space at the end of the file. It can be useful for reclaiming space in a database that has grown …

SQL Server DBCC Commands: DBCC SHRINKDATABASE Read more »

Hello there! My name is Steve Stedman, and I want to tell you about my amazing product, the Database Health Monitor. As a professional database administrator, I understand how vital it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, …

Database Health Monitor Read more »

Monitoring CPU load is an essential part of database performance monitoring, as high CPU usage can cause performance issues and slow down query execution. The Database Health Monitor for SQL Server provides insights into CPU usage, enabling you to identify potential issues and optimize database performance. High CPU usage can occur for a variety of reasons, such as inefficient query …

Monitoring CPU Load with Database Health Monitor Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2008 None 2023-03-15 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU2 for 2022 (16.0.4015.1 – March 2023)   SQL Server 2019 RTM Download links: …

New SQL Update from Microsoft Read more »

DBCC CHECKALLOC is a database console command (DBCC) in Microsoft SQL Server that can be used to check the allocation and structural integrity of the data and index pages in a database. Checking the allocation and structural integrity of the pages can be useful for identifying and correcting issues with the database that could cause errors or performance issues. To …

SQL Server DBCC Commands: DBCC CHECKALLOC Read more »

Monitoring long-running queries is an essential part of database performance monitoring, as it can help identify queries that are causing performance issues and take corrective action to optimize them. The Database Health Monitor for SQL Server provides insights into long-running queries, enabling you to identify performance bottlenecks and optimize query execution. One way the Database Health Monitor tracks long-running queries …

Monitoring Long-running Queries Read more »

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: PREEMPTIVE_XE_SESSIONCOMMIT Read more »