By Posted on Posted in Backup, Recovery No Comments Tagged with , ,

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 »

By Posted on Posted in Uncategorized No Comments

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 …

Tune in tomorrow for our live stream Read more »

By Posted on Posted in Performance No Comments

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 …

June Blog Post Wrap-up Read more »

By Posted on Posted in Performance No Comments

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 …

Database Health: Monitoring Disk I/O Read more »

By Posted on Posted in Performance No Comments

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 …

SQL Server DBCC Commands: DBCC CHECKTABLE Read more »

By Posted on Posted in Performance No Comments

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 »

By Posted on Posted in Performance No Comments

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 »

By Posted on Posted in SQL Server No Comments Tagged with ,

Tomorrow June 20th at 1pm PST we launch our very first Live Stream Discussion! Submit a question for our discussion >> Link to our Live Stream << We can’t wait to connect with you in real-time and bring you valuable content, entertainment, and more through these sessions. Stay tuned for updates on our upcoming broadcasts and get ready to join …

Tune in Tomorrow! Read more »

By Posted on Posted in Database Health No Comments

Today I have release the June 2023 update of Database Health Monitor version 1018. The big focus on this update was the wait time involved in reconnecting to SQL Servers when there are many connections open. This has been a big improvement. There were also some licensing updates with additional options for licensing, and more details for those who in …

Database Health Monitor – June 2023 update Read more »

By Posted on Posted in Performance No Comments

Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes, symptoms, and potential solutions for such corruption is essential for any database administrator looking to maintain the integrity and reliability of their SQL Server environment.. It is impossible to completely prevent corruption from happening. There …

SQL Server Corruption: Can I Prevent Corruption Read more »