July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this month as Database Health Monitor Month! This is our annual opportunity to appreciate the often-unseen guardians of our valuable data, …
Early release – July is Database Health Monitor Month Thu, 29 Jun 2023 This month marks the anniversary of Database Health Monitor, that I started building in 2011. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor. As many of you know, maintaining health Read more… Protecting Your SQL Server: The …
This month marks the anniversary of Database Health Monitor, that I started building in 2011. To celebrate I am offering 25% off the licensing fee for the annual subscription for Database Health Monitor. As many of you know, maintaining healthy and high-performing databases is critical for any organization that relies on data to drive business decisions. And that’s precisely what …
Early release – July is Database Health Monitor Month Read more »
As a business owner or IT professional, you know that your SQL Server is critical to the success of your organization. Whether you’re storing customer information, financial records, or other critical data, your SQL Server is the backbone of your operations. That’s why protecting that data is essential, and one of the most important steps you can take to do …
Protecting Your SQL Server: The Importance of Running Regular SQL Backups Read more »
Join us Tuesday June 27th, at 1pm Pacific time (4pm Eastern) for our highly anticipated second live stream discussion! This is your chance to dive into the world of SQL Server, Stedman Solutions, and Database Health Monitor like never before. Prepare your questions, as we are excited to tackle them head-on and provide you with the best possible answers. Get …
Database Health: Monitoring Disk I/O Sun, 25 Jun 2023 Monitoring disk I/O is an essential part of database performance monitoring, as disk I/O can significantly impact query performance and slow down database response times. The Database Health Monitor for SQL Server provides insights into disk I/O, enabling you t Read more… SQL Server DBCC Commands: DBCC CHECKTABLE Sat, 24 Jun …
Monitoring disk I/O is an essential part of database performance monitoring, as disk I/O can significantly impact query performance and slow down database response times. The Database Health Monitor for SQL Server provides insights into disk I/O, enabling you to identify potential issues and optimize database performance. Disk I/O refers to the input and output operations performed on your server’s …
DBCC CHECKTABLE is a database console command (DBCC) in Microsoft SQL Server that can be used to check the physical and logical integrity of a table in a database. Checking the integrity of a table can be useful for detecting corruption in the table or for troubleshooting issues with the table. To use DBCC CHECKTABLE, you must specify the name …
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. CXCONSUMER CXPACKET OLEDB LCK_M_SCH_M XE_LIVE_TARGET_TVF LCK_M_SCH_S LCK_M_S PREEMPTIVE_OS_PIPEOPS ASYNC_NETWORK_IO LCK_M_IX Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month 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_OS_ENCRYPTMESSAGE Read more »