Hello there! My name is Steve Stedman, and I want to tell you about my amazing product, the Database Health Monitor. As a professional database administrator, I understand how vital it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, …
Navigating SQL Server Management: The Unmatched Value of Stedman Solutions’ Managed Services In the ever-evolving landscape of database management, businesses are continually seeking reliable, efficient, and cost-effective solutions to ensure their SQL Server environments are running at peak performance. As the owner of Stedman Solutions, LLC, I’ve seen the challenges and costs that organizations face when trying to manage and …
The Unmatched Value of Stedman Solutions Managed Services Read more »
This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Impact of SQL Server AutoClose Setting on Performance The SQL Server AutoClose database setting, when enabled, can significantly impact the performance of your database. Below are key reasons why: 1. Resource Overhead When the AutoClose setting is …
Microsoft SQL Server’s database corruption can lead to severe operational complications, making crucial data inaccessible and potentially jeopardizing business continuity. Comprehending this problem requires a firm grasp of corruption indicators, its root causes, and effective strategies for prevention and repair. Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Steve : Now, one of the things …
SQL Server Corruption: Corruption vs Drive Failure Read more »
The Power of Proactive Monitoring in a World of Constant Change As the world continually evolves, the need for robust and proactive solutions in the realm of IT managed services becomes ever more critical. In an environment where a single change can have cascading effects, businesses cannot afford to be reactive. This is where Stedman Solutions steps in with its …
Proactive Monitoring in a World of Constant Change Read more »
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 MEMORY_ALLOCATION_EXT CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP ASYNC_NETWORK_IO LCK_M_U LCK_M_SCH_S PREEMPTIVE_OS_GETPROCADDRESS XE_LIVE_TARGET_TVF PREEMPTIVE_OS_PIPEOPS Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
As an expert in SQL Server with extensive experience since 1990, I’ve witnessed the pivotal role that a deep understanding of joins plays in database performance and query efficiency. It’s my pleasure to introduce a specialized course focused exclusively on SQL Server Joins, now available through Stedman’s SQL School. Why Focus on Joins? Joins are crucial in SQL Server for …
SQL School: SQL Server Joins: A Comprehensive Course 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 …
CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR on SQL Server allows you to create stored procedures, triggers, and functions using languages such as C# and VB.NET. The “CLR strict security” option is an important security feature of CLR that allows you to …
DBCC INDEXDEFRAG is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL Server. DBCC INDEXDEFRAG is a database console command (DBCC) in Microsoft SQL Server that can be used to defragment the indexes of a database. Defragmenting the indexes can be useful for improving the performance of …