Statistic Gathering.

  • audiew

    SSC Enthusiast

    Points: 172

    I need to be able to gather generic information regarding I/O. I want to know the number of reads & writes by database/table that occur on the SQL Server.

    When I need to trouble-shoot the system, I can then in turn compare the I/O table read/writes with information from Perfmon to figure out which tables are the hot spots of the application.

    This information could be used to create different drive arrays, and place tables into new filegroups pointing to these arrays.

    Another benefit would trend analyses by database/table for historical gathering.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715344

    Try

    set statistics io on

    You will have to somehow capture and parse this information as it is a print output. In QA , check the Messages tab.

    Steve Jones

    steve@dkranch.net

  • ckempste

    SSCoach

    Points: 17983

    Give the product SQL*Probe a go. Not too bad and may give what you want at a high level. Ive been onto them and have asked for more detailed information and read/write stats at a file-group and then object level. The company is subquery innovations.

    Cheers

    Chris


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply