Tuesday, February 17, 2009

How know when your ASE server was started??

# In ASE 12.5, the server boot time has been captured in loggedindatetime of sysprocesses for the internal system processes:


select min(loggedindatetime)
from master..sysprocesses where suid=0

# In ASE 12.5.0.1, it's even simpler:


select @@boottime


The static global variable @@boottime is undocumented, but happens to be identical to sysdatabases.crdate for tempdb.

# In ASE 12.5, the server boot time has been captured in loggedindatetime of sysprocesses for the internal system processes:


select min(loggedindatetime)
from master..sysprocesses where suid=0

# In ASE 12.5.0.1, it's even simpler:


select @@boottime


The static global variable @@boottime is undocumented, but happens to be identical to sysdatabases.crdate for tempdb.

0 comments:

Post a Comment