Here are two quick ways to check status of Instant File Initialization: read the error log, or query sys.dm_server_services on SQL Server 2016 and later.
SQL SERVER – How to Check If Instant File Initialization Enabled or Not?
Is Instant File Initialization enabled on your server? Before SQL Server 2016 there was no quick answer, but from 2016 onward you can check it in seconds.
SQL SERVER – How to Listen on Multiple TCP Ports in SQL Server?
Can SQL Server listen on multiple TCP Ports? Yes, and here are the Configuration Manager steps I shared when a senior DBA asked me during a Health Check.
SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable
A command-line SQL Server install failed: Validation for setting ‘AGTSVCACCOUNT’ failed, the RPC server is unavailable. I read the setup log and found the fix.
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect
SQL Server Analysis Services would not start: the filename, directory name, or volume label syntax is incorrect. Here is what the event log showed and the fix.
SQL SERVER – Event ID: 1135 – Cluster node ‘NodeName’ was Removed From the Active Failover Cluster Membership
Event ID 1135 says a cluster node was removed from the active failover cluster membership. Here is what a customer’s AlwaysOn setup taught me about it.
SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
None of the maintenance plans worked, though the jobs ran fine. The error was failed to acquire connection “Local server connection”. Here is why.