SQL Server Performance

Looking for Scripts for SQL Ping

Discussion in 'Third Party Tools' started by xiebo2010cx, Oct 18, 2006.

  1. xiebo2010cx Member

    Folks, I knew that third-part tool SQLRecon written with VB can perform this.

    But I really want to have my own scripts suitable for my environment.


    The Situation is:
    ----------------------------------------
    There exist thousands of the windows hosts on the domain, We have a list of the IP address for these windows servers. We only know some of them host SQL instance.

    The purpose of the script should be

    1. For the known windows hosts with SQL instance, need to know whether the sql services is up?

    2. For other unknow windows hosts, need to check whether they host sql server instances, if host, what is the status of the sql instance?

    ------------------------------------------

    Appreciate you input.



    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  2. ghemant Moderator

  3. xiebo2010cx Member

    Thanks, ghemant.
    SQLPing, SQLPing2, SQLRecon all can do this work.

    I want to get some ideas to develop own sql script for my environment



    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  4. satya Moderator

    YOu can find such programs or scripts (open source) to perform the tasks you're looking, and as far as third party tools are concerned it is better to contact Vendor.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. xiebo2010cx Member

    Satya, can you please recommend me several good open source SQL Server script sites? appreciate it

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  6. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] I wish I could... but Google is your best friend in this case.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  7. xiebo2010cx Member

    Since when I google it, lots of junk information will pop up. I need to filter them to find the best one. The same thing, it takes me some time to find here and finally get used to.

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------

Share This Page