-
March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services
This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL Server start process. 1) List out various services which are important for SQL Server and its components functionality? SQL Server Service SQL Server Agent service…
-
Database Engine Instances (SQL Server): A Quick Refresher
SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each running SQL Server instance you must see one sqlservr.exe in task manager. Like in screenshot. An instance can manage six system databases. An instance can manage one or more…