Which settings changed in sp_configure need a restart to take effect? You do not need to remember them, because a catalog view added in SQL Server 2008 tells you.
SQL Authority News – Free Performance Tuning Videos
People often ask me to teach my SQL Server performance tricks. Here are two of my free Performance Tuning Videos where I explain how to tune SQL Server.
How to Track Autogrowth of Any Database? – Interview Question of the Week #205
How do you track autogrowth of any database? Constant autogrowth was slowing a client’s busy e-commerce database, and here is how we found when and who caused it.
How to Start Database in a Single User Mode? – Interview Question of the Week #202
How do you start a database in a single user mode when there is corruption? Here are simple steps in SQL Server Configuration Manager, one by one.
SQL SERVER – Configuration Manager Error: The Server Threw an Exception [0x80010105]
SQL Server Configuration Manager failed with: the server threw an exception [0x80010105]. The usual KB did not apply to Windows Server 2008. Here is the fix.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
![SQL SERVER - Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]](https://blog.sqlauthority.com/wp-content/uploads/2018/10/sscm-err-02.jpg){kind=small}
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
SQL Server Configuration Manager would not open on my VM: Cannot connect to WMI provider [0x80070422]. I share what caused it and how I fixed it.