Sql Server Documentation


select @@version
go

exec master..xp_msver
go

print ''
print '1.2  Miscelaneous'
print '---------------------------'
print ''

select convert(varchar(30),login_time,109) as 'Servidor inicializado em ' from master..sysprocesses where spid = 1

print 'Number of connections..: ' + convert(varchar(30),@@connections)       
print 'Language...............: ' + convert(varchar(30),@@language)         
print 'Language Id............: ' + convert(varchar(30),@@langid)           
print 'Lock Timeout...........: ' + convert(varchar(30),@@LOCK_TIMEOUT)     
print 'Maximum of connections.: ' + convert(varchar(30),@@MAX_CONNECTIONS)  
print 'Server Name............: ' + convert(varchar(30),@@SERVERNAME)       
print 'Instance...............: ' + convert(varchar(30),@@SERVICENAME)      
print ''
print 'CPU Busy...........: ' + convert(varchar(30),@@CPU_BUSY/1000)       
print 'CPU Idle...........: ' + convert(varchar(30),@@IDLE/1000)
print 'IO Busy............: ' + convert(varchar(30),@@IO_BUSY/1000)
print 'Packets received...: ' + convert(varchar(30),@@PACK_RECEIVED)
print 'Packets sent.......: ' + convert(varchar(30),@@PACK_SENT)
print 'Packets w errors...: ' + convert(varchar(30),@@PACKET_ERRORS)
print 'TimeTicks..........: ' + convert(varchar(30),@@TIMETICKS)
print 'IO Errors..........: ' + convert(varchar(30),@@TOTAL_ERRORS)
print 'Total Read.........: ' + convert(varchar(30),@@TOTAL_READ)
print 'Total Write.........: ' + convert(varchar(30),@@TOTAL_WRITE)
go

Ebook Download
View all
Learn
View all