Blocking in a SQL Server can have serious consequences if not addressed promptly. If left unchecked, blocking can cause a backlog of queries that can eventually lead to the server becoming unresponsive or even crashing. To avoid this, it’s important to monitor for blocking and take action as soon as it occurs. One way to do this is by setting …
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: …
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 …
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 …
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 »
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 Q&A. This training will be held every month on different days of the week and times so to fit a variety of schedules. Steve will demonstrate tips, tricks and features of this power house tool. …
Database Health Monitor Monthly Training + Q&A for March Read more »
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 can add users to a Windows local group and then create a SQL Server login using that group. The users who are members of the group will then be able to connect to the database …
Securing SQL Server: Windows Local Groups as SQL Logins Read more »
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 query is attempting to acquire a conflicting lock on the same resource. This can cause the second query to wait until the first query releases its lock, which can lead to performance issues and, in …
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 data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
Daily Server Monitoring – SQL Versions for March Read more »