Category: Performance

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. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXSYNC_PORT CXPACKET LCK_M_SCH_S CXCONSUMER LCK_M_S RESOURCE_SEMAPHORE_QUERY_COMPILE LCK_M_IS 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: SOS_SYNC_TASK_ENQUEUE_EVENT Read more »

The Scan For Startup Procs feature in SQL Server allows you to specify a list of stored procedures that will be automatically executed whenever the database engine starts. This can be useful in certain scenarios, such as when you want to perform tasks such as restoring a database or performing maintenance tasks when the database engine starts. “Scan for startup …

Securing SQL Server: Scan for Startup Procs Read more »

Hey there, Steve Stedman here, and I couldn’t be more excited to share some insights on a service that has been making waves in the world of database management. Today, I want to shine a spotlight on Stedman Solutions’ exceptional SQL Performance Tuning service, which has helped countless businesses optimize their database performance and streamline operations. Watch Steve Stedman’s video …

Unlocking Database Performance: Unleash the Power with SQL Performance Tuning Read more »

SQL Servers DBCC commands are a set of T-SQL commands that are used for various maintenance and diagnostic tasks. Some of these commands are documented and can be accessed through the SQL Server documentation, while others are considered “undocumented” and are not officially supported by Microsoft. Undocumented DBCC commands are usually not documented in the official SQL Server documentation and …

SQL Server DBCC Commands: Overview of Undocumented Commands Read more »

What is the Difference Between Log Shipping and Replication in SQL Server? When it comes to SQL Server, ensuring data availability, Disaster Recovery, and data distribution are critical tasks for any database administrator. Two of the most commonly used features to achieve these goals are Log Shipping and Replication. Although they may seem similar at first glance, they serve different …

Difference Between Log Shipping and Replication in SQL Server? Read more »

The SQL Server Managed Services offered by Stedman Solutions, LLC is an alternative to hiring a full time DBA, or to help your existing DBA that may be overloaded. Watch this video by Steve Stedman to find out more. Find out more about our SQL Server Managed Services from Stedman Solutions. Schedule a time to discuss how Stedman Solutions can …

Managed Services: an alternative to hiring a DBA Read more »

Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server provides insights into backup status, enabling you to identify potential issues and take corrective action to ensure that your backups are running smoothly. The Database Health Monitor …

Database Health: Monitoring Backups with Database Health Monitor Read more »

Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by blog. Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Steve : Now, one of the things that when we talk about drive failures and that there is a big difference …

SQL Server Corruption: Corruption vs Drive Failure Read more »

In the dynamic world of databases, ensuring optimal performance and robustness is crucial. Yet, many businesses often sideline database assessments, unaware of the untapped potential they can unlock. At Stedman Solutions, we emphasize the importance of our SQL Server Health Assessment. Why? Because the overall health of your SQL Server can drastically impact your business operations, especially when it comes …

Why Every Business Needs Stedman Solutions’ SQL Server Health Assessment Read more »