|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > UPTIME or DOWNTIME
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
UPTIME or DOWNTIME
|
|
|
| Hi All,
Greetings...
How do I find the uptime of the SQL Server for the
specified time interval.
Cheers,
Sanka
| |
| Brian Moran 2002-11-26, 8:23 am |
| There isn't a specific function of command that does this, but...
select login_time from master..sysprocesses where spid = 1
will show the login time of a system process that logs in when the server
starts. So it's a reliable way to check...
--
Brian Moran
SQL Server MVP
SQL Server Magazine Columnist
"Sanka" <loonysan@mailcity.com> wrote in message
news:1757d01c29551$51580dd0$8d
f82ecf@TK2MSFTNGXA02...
> Hi All,
>
> Greetings...
>
> How do I find the uptime of the SQL Server for the
> specified time interval.
>
> Cheers,
> Sanka
>
| |
| linda deng[MS] 2002-11-28, 4:23 am |
| Hi Sanka,
In addition to Brian's suggestion, you can find when the SQL Server starts
in the SQL Server current error log file. There are two possible scenarios
to view the error log file.
1. View the current error log file in the Enterprise Manager.
2. View the current error log file directly under the C:\Program
Files\Microsoft SQL Server\MSSQL\LOG folder.
If you want to know when the SQL Server stops, please view the first
previous error log with the same steps.
Sincerely,
Linda Deng
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|