This was always in my mind, what happened when we start or restart sql server services from os service panel. There are long list of activities process out to get connected with database. These are below :
1. Server process ID allocation and with Authentication mode.
2. Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Log\ERRORLOG'.
3. Registry startup parameters setting for master, error,log -d,-e, -l
4. SQL Server detected cpu and cores and allocating as per licenses and configuration .
5. SQL Server is starting at normal priority base (=7).
6. SQL Server Detecting RAM and allocating to server as per awe and configured.
7. SQL Server Detecting Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0 for NUMA configuration.
8. Starting up database 'master' and do transactions rolled forward in database 'master' (1:0).
9. SQL Server Audit is starting the audits.
10. SQL Trace ID 1 was started by login "sa".
11. A self-generated certificate was successfully loaded for encryption.
12 SQL Server detecting and starting network configuration port and propery, pipe, named pipe and Dedicated administrator connection.
13. Then SQL Server is now ready for client connections.
14. Starting up database 'msdb'.
15. Starting up database 'ReportServer$SQL2012'.
16. Starting up database 'model'.
17. Clearing tempdb database.
18. The Database Mirroring endpoint is in disabled or stopped state.
19. Service Broker manager has started.
20. Starting up user database, transactions rolled forward in database.
Now SQL Server is ready to use.
1. Server process ID allocation and with Authentication mode.
2. Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Log\ERRORLOG'.
3. Registry startup parameters setting for master, error,log -d,-e, -l
4. SQL Server detected cpu and cores and allocating as per licenses and configuration .
5. SQL Server is starting at normal priority base (=7).
6. SQL Server Detecting RAM and allocating to server as per awe and configured.
7. SQL Server Detecting Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0 for NUMA configuration.
8. Starting up database 'master' and do transactions rolled forward in database 'master' (1:0).
9. SQL Server Audit is starting the audits.
10. SQL Trace ID 1 was started by login "sa".
11. A self-generated certificate was successfully loaded for encryption.
12 SQL Server detecting and starting network configuration port and propery, pipe, named pipe and Dedicated administrator connection.
13. Then SQL Server is now ready for client connections.
14. Starting up database 'msdb'.
15. Starting up database 'ReportServer$SQL2012'.
16. Starting up database 'model'.
17. Clearing tempdb database.
18. The Database Mirroring endpoint is in disabled or stopped state.
19. Service Broker manager has started.
20. Starting up user database, transactions rolled forward in database.
Now SQL Server is ready to use.
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757