In the digital era, a robust disaster recovery plan focusing on data backup and restore is more crucial than ever. A simple error, hardware failure, or a crippling cyber-attack could spell disaster for your invaluable SQL Server data. Businesses that …
Mastering Disaster Recovery with Our SQL Server Backup and Restore Course Read more »
Hello! Steve Stedman here. Today, I’d like to emphasize the critical importance of maintaining the health of your SQL Server database through an unshakeable backup and recovery plan. Why? Because in our data-driven world, the absence of a comprehensive backup …
Welcome to July – a month that signifies a shift in focus to the unseen heroes of our digital infrastructure – our databases. As the founder of Database Health and Stedman Solutions, it is with great pleasure that I announce …
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 …
Sneak preview – July is Database Health Monitor Month Read more »
Listed are our current and previous live training webinars. You will also find full recordings of each training as they become available. March 29th 2023 Recording will be available soon…… February 9th 2023 During this month’s training we cover Database …
SQL Server uses a wait type called RESOURCE_SEMAPHORE_QUERY_COMPILE to track the amount of time that a query spends waiting to acquire a semaphore in order to compile a query plan. A semaphore is a synchronization object that controls access to …
Establishing a performance baseline is important with SQL Server. Think of it this way if you car normally runs well on the highway, but suddenly you can’t get it up to highway speeds you know that something is wrong. You …
PREEMPTIVE_OLEDBOPS Wait Type This is related to the OLE DB Provider, which can apply to linked server connections. Added in SQL Server 2008. Linked servers can be extremely inefficient on some joins. One option to help this is to change …
Understanding the PREEMPTIVE_XE_DISPATCHER Wait Type in SQL Server When diving into SQL Server performance tuning, one area that often draws attention is wait statistics. These provide insights into what your SQL Server is waiting on, helping to pinpoint performance bottlenecks. …
Breaking down the name of QDS_ASYNC_QUEUE. The QDS part of the name refers to Query Store. ASYNC meaning it is an asynchronous process. Queue being the act of moving something in our out of the queue. From the Microsoft website: …