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… Read More »Database Health Monitor

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… Read More »Monitoring CPU Load with Database Health Monitor

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.… Read More »New SQL Update from Microsoft

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… Read More »SQL Server DBCC Commands: DBCC CHECKALLOC

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… Read More »Monitoring Long-running Queries

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.… Read More »SQL Server Wait Type: PREEMPTIVE_XE_SESSIONCOMMIT

In SQL Server, you can create logins using Windows local groups as a way to manage access to the database server. This means that you… Read More »Securing SQL Server: Windows Local Groups as SQL Logins