SQL database engine service startup failure: Troubleshooting Checklist

Hi all, In this article, we are covering the common scenarios of SQL Service startup failures and troubleshooting approach to resolve these issues:   1.  For standalone instance of SQL, always use SQL Server configuration manager to start the SQL database Engine service. For Clustered instance of SQL, always use Fail over Cluster manager tool…

0

Operating System Best Practice Configurations for SQL Server

Hi all, In this article, we are covering few important Operating System (Windows) best practice configurations for SQL Server. SQL Server is an user mode application runs on Windows Operating system and hence these configuration settings are important for SQL Server performance.   1. Partition the Disk volumes hosting SQL databases (Data and log) with…

2