DBCC OPENTRAN is a DBCC command in Microsoft SQL Server that can be used to display information about the oldest active transaction in the database. This can be useful for troubleshooting issues with long-running transactions, as it can help identify the cause of the problem and allow you to take appropriate action to resolve it. To use DBCC OPENTRAN, you …
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 LCK_M_X LCK_M_U CXCONSUMER CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP OLEDB ASYNC_NETWORK_IO XE_LIVE_TARGET_TVF LCK_M_SCH_S Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
The CHECK_EXPIRATION option is a security feature of SQL Server that allows you to enforce password expiration for SQL Server logins. When this option is set to ON for a login, it requires the login to change its password after a certain period of time has passed. Setting the CHECK_EXPIRATION option to ON for all SQL authenticated logins within the …
Securing SQL Server: CHECK_Expiration for SQL Server logins 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 …
At Stedman Solutions we’re on your side. We give that extra 10% and take the extra time for you, our customers. Here are some statements from clients who have undergone our SQL Assessment service: Learn about our 10% SQL Assessment sale going on through May. “Unlike a Typical Consultant” We are moving our SaaS offering from one cloud provider to …
In addition to its customizable dashboard, intelligent alerting system, and powerful reporting capabilities, the Database Health Monitor also provides valuable insights into wait statistics and blocking queries. Wait statistics are a crucial component of database performance monitoring, as they provide information about the amount of time that queries spend waiting for various resources, such as locks, I/O operations, or CPU …
Database Health: Wait Statistics and Blocking Queries Read more »
DBCC DROPCLEANBUFFERS is a DBCC command in Microsoft SQL Server that can be used to remove clean buffers from the buffer pool, which is a region of memory used by the database engine to store data pages read from disk. Removing clean buffers from the buffer pool can be useful for testing the performance of a query or for simulating …
DBCC FREESYSTEMCACHE is a database console command (DBCC) in Microsoft SQL Server that can be used to clear the system cache, which is a region of memory used by the database engine to store data pages read from disk and other objects such as stored procedures and triggers. Clearing the system cache can be useful for troubleshooting performance issues or …
DBCC DLLNAME is a database console command (DBCC) in Microsoft SQL Server that can be used to display the name of the dynamic-link library (DLL) file associated with a specific database console command (DBCC). Displaying the DLL file name can be useful for troubleshooting issues or for verifying the version of a specific DBCC command. To use DBCC DLLNAME, you …
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU4 for 2022 (16.0.4035.4 – May 2023) 2023-05-11 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: NoneCU4 for 2022 (16.0.4035.4 – May 2023) …