Get ping result of multiple server into SQL table

Note:  Best viewed in Internet Explorer 6 and above

Implementation: How to get ping result of multiple servers into SQL table.

Scenario: Lets say you manage multiple DB servers solely and in your day to day monitoring activities list,you have to first check all server running status by pinging them.

So how will you achieve this??

will you ping all servers individually and manually or would you like to have the simple and sweet query that will done your work automatically  even from a single server.

So here I come with the query which will do this.

Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012.

Steps:

Mostly DBAs spend their tectonic times on doing pining the DB servers in daily monitoring activities.

As per the demand of some of my colleague,I have made a query which makes this task automate.

kindly go through the below link and download the scripts and test it in your own environment.

https://app.box.com/files/0/f/5025136893/1/f_40657465301

  • Output will be look like as the below screen shot.

PingResultIntoSQLTables

  • Enjoy..
  • This is how you can ping result of multiple server into SQL table.
  • Please do comments when you find this useful or any suggestion on the same will be highly accepted.

Get SQL Server Jobs detail history based on last run day and time

Note:  Best viewed in Internet Explorer 6 and above

Implementation: How to get SQL Server Jobs detail history based on last run day(no of days) and time(minutes)

Scenario: Lets find out SQL Server Jobs detail history based on last run day(no of days) and time(minutes)

Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012.

Steps:

Mostly you can find out the SQL server jobs history,detailing about run date time and duration but not about Finish end time of jobs.As per demand from one of my colleague’s client Mr.Rakesh Sharma,here is the scripts that fulfill it.

You can find the same on below link.

https://app.box.com/s/anzeyiqjzap5y2vvxvhtyq0qi5buqpo1

  • This is how you can get SQL Server Jobs detail history based on last run day and time.
  • Please do comments when you find this useful or any suggestion on the same will be highly accepted.