Microsoft

SQL Server Health and History Tool (SQLH2)

Share
Language:
English
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used.
  • Details

    Note: There are multiple files available for this download. Once you click on the “Download” button, you will be prompted to select the files you need.
    Version:
    Date Published:

    2.027

    11/1/2005

    File name:
    File size:

    H2Setup.msi

    992 KB

    Additional_doc.cab

    1.0 MB

    FAQ.cab

    179 KB

    SQLH2update.cab

    71 KB

      This version of SQLH2 supports SQL Server 2005 RTM collection.

      SQLH2 collects four main types of information:
      1. Feature Usage – What services/features are installed, running and level of workload on the service.
      2. Configuration Settings – Machine, OS and SQL configuration settings, SQL instance and database metadata.
      3. Uptime of the SQL Server service
      4. Performance Counters (optional) – Used to determine performance trends
  • System Requirements

    Supported Operating System

    Windows Server 2003

      Windows 2000, Windows 2000 Service Pack 2, Windows 2000 Service Pack 3, Windows 2000 Service Pack 4, Windows NT, Windows Server 2003, Windows XP
  • Install Instructions

      Click the file you want to download from the list below.
      Do one of the following:
      To start the installation immediately, click Open or Run this program from its current location.
      To copy the download to your computer for installation at a later time, click Save or Save this program to disk.
  • Additional Information

      There are four downloads located here:
      1. H2Setup.msi - Contains all files needed to set up the SQLH2 Collector. You do not need to install SQLH2Update fixes with this version. Includes "SQLH2 V2 Deployment Guide.doc", a document describing SQLH2 installation and usage.
      2. SQLH2Update.cab - Contains the updated SQLH2.exe file and instructions on how to apply this to existing SQLH2 installations. Fixes several bugs that were reported by customers in the Version 2.0 release.
      3. FAQ.cab - Frequently asked questions about SQLH2.
      4. Additional_doc.cab - Additional documentation including a comprehensive installation guide and SQLH2 schema.

      Note that SQLH2 requires you to create a SQL Server repository database. You should also download the SQLH2 reports to view the data SQLH2 collects. If you are interested in performance data, download and install the SQLH2 Performance Collector at the link provided on this page.

      If you have questions or comments on the tool, email sqlh2@microsoft.com
  • Related Resources

Popular downloads

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers
Run Microsoft Update
close
moreinfo