SQL Stuff

Problem:

I received a request from one of the developer saying that, the Staging DB was down yesterday evening, between 6:00 PM to 8:00 PM.

Due to this, he was not able to meet his deadline.

Solution:

Since it was staging server, we do not configure automate mail alert for service restart.

So, to answer such question, I have checked below things.

1. Last SQL Server instance restart.

2. Last DB server (windows services) restart.

HOW TO CHECK ?

SQL Server Restart:

We can check it easily and by the Easiest ways (SQL Query)

SELECT sqlserver_start_time FROM sys.dm_os_sys_info

SELECT 'Statistics since: ' + CAST(sqlserver_start_time AS VARCHAR) FROM sys.dm_os_sys_info

EXEC SP_HELPDB 'Tempdb'

Raghwendra mishra