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
Coming up before you know it is our March training webinar! Improve you knowledge and skill set with this FREE Database Health Monitor training and… Read More »Database Health Monitor Monthly Training + Q&A for March
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
Blocking in SQL Server can occur when….. one query is holding a lock on a particular resource, such as a table or row, and another… Read More »Blocking in SQL Server 101
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the… Read More »Daily Server Monitoring – SQL Versions for March
Have you seen our SQL short course on the TSQL Output Clause? The SQL Server output clause is a great way to get data back… Read More »TSQL Output Clause Course
Will a corrupt SQL Server database ever just get better? No, a corrupt SQL Server database will not just “get better.” Once a database is… Read More »SQL Server Corruption: Will It Get Better
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: HADR_AR_CRITICAL_SECTION_ENTRY
Save the stress for another day, we have come up with a solution! With our SQL Blocking Query email notification script, you are notified about… Read More »Don’t Get Caught in Blocked Query Chaos!