November 18, 2011 at 2:26 am
Hi,
I was wondering what SQL-Server actually does during the server start. :blush:
Is there a list with all the steps that are performed?
Thanks in advance.
November 18, 2011 at 3:49 am
If you read through the error log, a lot of info is there. Otherwise there was an excellent description in the book "SQL Server 2005 Practical Troubleshooting"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 24, 2011 at 7:52 am
Thanks,
I will try to get the book.
Thank you very much.
December 1, 2011 at 4:01 am
THe below is the log looks like, what SQL will do when it starts
12/01/2011 16:23:27,Server,Unknown,Server is listening on [ 127.0.0.1 <ipv4> 1434].
12/01/2011 16:23:27,Server,Unknown,Server is listening on [ ::1 <ipv6> 1434].
12/01/2011 16:23:27,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
12/01/2011 16:23:27,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
12/01/2011 16:23:27,Server,Unknown,Server is listening on [ 'any' <ipv4> 1433].
12/01/2011 16:23:27,Server,Unknown,Server is listening on [ 'any' <ipv6> 1433].
12/01/2011 16:23:27,Server,Unknown,A self-generated certificate was successfully loaded for encryption.
12/01/2011 16:23:27,spid13s,Unknown,Service Broker manager has started.
12/01/2011 16:23:27,spid13s,Unknown,The Database Mirroring protocol transport is disabled or not configured.
12/01/2011 16:23:27,spid13s,Unknown,The Service Broker protocol transport is disabled or not configured.
12/01/2011 16:23:26,spid10s,Unknown,Starting up database 'tempdb'.
12/01/2011 16:23:25,spid10s,Unknown,Clearing tempdb database.
12/01/2011 16:23:24,spid7s,Unknown,Server name is 'ADITIDT466'. This is an informational message only. No user action is required.
12/01/2011 16:23:24,spid10s,Unknown,Starting up database 'model'.
12/01/2011 16:23:24,spid7s,Unknown,The resource database build version is 10.50.1617. This is an informational message only. No user action is required.
12/01/2011 16:23:24,spid7s,Unknown,Starting up database 'mssqlsystemresource'.
12/01/2011 16:23:24,spid7s,Unknown,SQL Trace ID 1 was started by login "sa".
12/01/2011 16:23:24,spid7s,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
12/01/2011 16:23:24,spid7s,Unknown,SQL Server Audit has started the audits. This is an informational message. No user action is required.
12/01/2011 16:23:24,spid7s,Unknown,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
12/01/2011 16:23:24,spid7s,Unknown,Resource governor reconfiguration succeeded.
12/01/2011 16:23:23,spid7s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
12/01/2011 16:23:23,spid7s,Unknown,Starting up database 'master'.
12/01/2011 16:23:23,Server,Unknown,Node configuration: node 0: CPU mask: 0x00000003:0 Active CPU mask: 0x00000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
12/01/2011 16:23:23,Server,Unknown,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
12/01/2011 16:23:22,Server,Unknown,Detected 2 CPUs. This is an informational message; no user action is required.
12/01/2011 16:23:22,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
12/01/2011 16:23:22,Server,Unknown,Registry startup parameters: <nl/> -d E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
12/01/2011 16:23:22,Server,Unknown,This instance of SQL Server last reported using a process ID of 2200 at 12/1/2011 4:23:14 PM (local) 12/1/2011 10:53:14 AM (UTC). This is an informational message only; no user action is required.
12/01/2011 16:23:22,Server,Unknown,Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
12/01/2011 16:23:22,Server,Unknown,Authentication mode is MIXED.
12/01/2011 16:23:22,Server,Unknown,System Manufacturer: 'Dell Inc.'<c/> System Model: 'OptiPlex GX620'.
12/01/2011 16:23:22,Server,Unknown,Server process ID is 5992.
12/01/2011 16:23:22,Server,Unknown,All rights reserved.
12/01/2011 16:23:22,Server,Unknown,(c) Microsoft Corporation.
December 1, 2011 at 8:44 am
Picked the important ones...
12/01/2011 16:23:27,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
12/01/2011 16:23:27,spid13s,Unknown,Service Broker manager has started.
12/01/2011 16:23:26,spid10s,Unknown,Starting up database 'tempdb'.
12/01/2011 16:23:24,spid10s,Unknown,Starting up database 'model'.
12/01/2011 16:23:24,spid7s,Unknown,Starting up database 'mssqlsystemresource'.
12/01/2011 16:23:24,spid7s,Unknown,SQL Trace ID 1 was started by login "sa".
12/01/2011 16:23:24,spid7s,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
12/01/2011 16:23:24,spid7s,Unknown,SQL Server Audit has started the audits. This is an informational 12/01/2011 16:23:24,spid7s,Unknown,Resource governor reconfiguration succeeded.
12/01/2011 16:23:23,spid7s,Unknown,Starting up database 'master'.
12/01/2011 16:23:23,Server,Unknown,Node configuration: node 0: CPU mask: 0x00000003:0 Active CPU mask: 0x00000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
12/01/2011 16:23:23,Server,Unknown,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
12/01/2011 16:23:22,Server,Unknown,Detected 2 CPUs. This is an informational message; no user action is required.
12/01/2011 16:23:22,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
12/01/2011 16:23:22,Server,Unknown,Registry startup parameters: <nl/> -d E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
12/01/2011 16:23:22,Server,Unknown,This instance of SQL Server last reported using a process ID of 2200 at 12/1/2011 4:23:14 PM (local) 12/1/2011 10:53:14 AM (UTC). This is an informational message only; no user action is required.
12/01/2011 16:23:22,Server,Unknown,Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
12/01/2011 16:23:22,Server,Unknown,Authentication mode is MIXED.
12/01/2011 16:23:22,Server,Unknown,System Manufacturer: 'Dell Inc.'<c/> System Model: 'OptiPlex GX620'.
12/01/2011 16:23:22,Server,Unknown,Server process ID is 5992.
December 6, 2011 at 8:36 am
Thank you very much... 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply