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 »
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 …
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 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 …
Have you seen our Managed Services offering? Managed Services for SQL Servers has become one of the largest parts of our business, and we have even expanded the managed services team now to 4 people supporting clients SQL Servers. A short video where I describe the managed services offering that we have at Stedman Solutions to support SQL Servers. We …
Join Us for This Live Event – Tuesday 20th – 1pm pacific / 4pm eastern These engaging broadcasts will bring valuable content each week! This weekly event offers excellent opportunities to enhance your SQL skills and expand your knowledge in the field. Join us every Tuesday at 1pm PST as the Stedman Solutions Team will answer question submissions regarding your …
Live SQL Discussion with Stedman Solutions Kickoff Read more »
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU21 for 2019 (15.0.4316.3 – June 2023) CU18 + GDR (15.0.4280.7 – February 2023) 2023-06-15 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None SQL Server 2022 RTM Download links: NoneCU5 …
There are 2 perspectives here to the DBA on vacation, typically in an organization with only a single DBA so there is no cross coverage when someone goes on vacation. The view as the DBA: I have done everything that I can to prepare the systems for vacation, but still I end up getting called for some regular maintenance job …