Servers

    SQL Server Health and History Tool (SQLH2)

    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.
    • 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:

      2.027

      File Name:

      H2Setup.msi

      Additional_doc.cab

      FAQ.cab

      SQLH2update.cab

      Date Published:

      11/1/2005

      File Size:

      992 KB

      1.0 MB

      179 KB

      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
    • 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.
      • 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

    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 04

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 05

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial