Find the SQL Server Service Startup Time
Many times for collecting or analyzing performance counter from the different DMV we need to collect the data of many days, so at that it is necessary to find the SQL Server Service startup time. We can find it as below.
1) Every time when SQL Server restarts, It creates the “TempDB” so from the TempDB creation time you can find SQL Server startup time.
SELECT CREAT_DATE FROM SYS.DATABASES WHERE NAME = ‘TEMPDB’
2) If you error log is not flushed you can use the XP_ReadErrorlog and from there you can find the SQL Server startup time
3) We can also find it using sys.dm_exec_requests DMV for startup time
4) We can also find it from Master..SysProcesses system table by analyzing the login time for the System Processes (for i.e. LAZYWRITER)