SQL Server Performance

What is the process of restarting the SQL Server 2000?

Discussion in 'SQL Server 2005 General DBA Questions' started by LucasDa, Nov 17, 2008.

  1. LucasDa New Member

    Hi!!.
    I have some problem with the SQL Server 2000 and Sessions.
    For this, I need to know " What is the process of restarting the SQL server? ".
    I need to know the step by step that execut SQL when the Server is restart.
    There is an article with this information?
    Thank
    Bye!!!.
  2. Luis Martin Moderator

    You can check SQL Server Log.
    This is one example of restarting SQL Server 2000.
    2008-10-31 13:30:40.84 server Microsoft SQL Server 2000 - 8.00.2273 (Intel X86)
    Mar 7 2008 22:19:58
    Copyright (c) 1988-2003 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
    2008-10-31 13:30:40.84 server Copyright (C) 1988-2002 Microsoft Corporation.
    2008-10-31 13:30:40.84 server All rights reserved.
    2008-10-31 13:30:40.84 server Server Process ID is 1484.
    2008-10-31 13:30:40.84 server Logging SQL Server messages in file 'c:mssql2kMSSQLlogERRORLOG'.
    2008-10-31 13:30:40.85 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
    2008-10-31 13:30:40.95 server SQL Server configured for thread mode processing.
    2008-10-31 13:30:40.95 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
    2008-10-31 13:30:41.01 server Attempting to initialize Distributed Transaction Coordinator.
    2008-10-31 13:30:44.09 spid4 Starting up database 'master'.
    2008-10-31 13:30:44.24 server Using 'SSNETLIB.DLL' version '8.0.2039'.
    2008-10-31 13:30:44.24 spid5 Starting up database 'model'.
    2008-10-31 13:30:44.26 spid4 Server name is 'SERVER3'.
    2008-10-31 13:30:44.26 spid8 Starting up database 'msdb'.
    2008-10-31 13:30:44.26 spid9 Starting up database 'Frio'.
    2008-10-31 13:30:44.26 spid10 Starting up database 'Dbl1'.
    2008-10-31 13:30:44.26 server SQL server listening on 192.168.0.160: 1433.
    2008-10-31 13:30:44.26 server SQL server listening on 127.0.0.1: 1433.
    2008-10-31 13:30:44.26 server SQL server listening on TCP, Shared Memory, Named Pipes.
    2008-10-31 13:30:44.26 server SQL Server is ready for client connections
    2008-10-31 13:30:44.39 spid5 Clearing tempdb database.
    2008-10-31 13:30:44.45 spid5 Starting up database 'tempdb'.
    2008-10-31 13:30:44.48 spid5 Analysis of database 'tempdb' (2) is 100% complete (approximately 0 more seconds)
    2008-10-31 13:30:45.73 spid9 Recovery is checkpointing database 'Frio' (5)
    2008-10-31 13:30:45.89 spid10 Recovery is checkpointing database 'Dbl1' (6)
    2008-10-31 13:30:45.92 spid4 Recovery complete.
    2008-10-31 13:30:45.92 spid4 SQL global counter collection task is created.
    2008-10-31 13:30:46.43 spid51 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

Share This Page