Windows Server Uptime and Net Statistics Server

17 June,2011 by Jack Vamvas

How can I find the Windows Server uptime and the last time a Windows Server restarted?

Windows Server Uptime and the last time a Windows Server restarted , on a database server is useful information. As well as SQL Server   I do also manage some DB2 Server on Windows  - which has different information available for server level information.  Net Statistics Server  displays the details.

Normally, I’m only interested in the database server service restart. But if the database server has been down – and the server restarted – it assists in troubleshooting.

 Yesterday I saw the backups failed – which I thought was caused by the TSM backup server.But on closer examination I saw this message in the Event Viewer.

 The previous system shutdown at 22:21:27 on 15/06/2011 was unexpected.

I did some investigation – looking for a cause. It was an unusual error – as it was not accompanied by any other error messages. Speaking to the Server Administrator , he discovered that one of the processors failed.

This caused the server to shutdown and restart with one less processor.

 Net Statistics Server displays the last boot time on the second line below:

 Statistics since dd/mm/yyyy hh:mm

Net statistics server 
Windows Server Uptime and the last time a Windows Server restarted  can also be displayed by net stats srv, which gives you the same information as net statistics server

Read More

Uptime of DB2 LUW

DB2 event monitor and snapshot monitor - DBA DB2

Storage Monitoring : a quick guide - DBA DB2



 
Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Windows Server Uptime and Net Statistics Server

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright