SQL Server Performance

SQL Server Performance Counter Fetch

Discussion in 'Performance Tuning for Hardware Configurations' started by chandan1803, Sep 23, 2005.

  1. chandan1803 New Member

    In our Organization Oracle DBA Team, fetch the schedule report from Database which consists of :<br />1) Buffer Cache Hit Ratio <br />2) Database Growth in Last 10 Days<br />3) Invalid Objects<br />4) Chained Rows analysis<br />5) Top 10 SQL by Buffer Gets<br />6) Top 10 SQL by Physical Reads<br />7) Top 10 SQL by Executions<br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> Free Space in Tablespace<br />9) Check For Max Extents Indexes<br />10) Check For Max Extents Tables<br />11) Check For Max Extents Temporary<br />12) Check For Sessions<br />13) Check For Process<br />14) Check For Locks<br />15) SGA Cache Statistics<br />16) Init parameter Statistics<br />17) Fragmentation in Tablespace<br /><br />Can you please help me to map these report with SQL Server Database?<br />How can I fetch the same kind of report from SQL Server?<br /><br />I will be grateful if you please help me.<br /><br />
  2. bertcord New Member

    you really expect us to do all of your work for you? If you ask specifc well thought out questions you are more likley to get a response.

    Bert
  3. dineshasanka Moderator

  4. chandan1803 New Member

    Ok Fine ............
    Can you give me solution of how to get the below 3 counters from SQL Server Database
    1) Top 10 SQL by Buffer Gets
    2) Top 10 SQL by Physical Reads
    3) Top 10 SQL by Executions

    This is a discussion forum everybody get the knowledge not only me.
    And the above mentioned counter will help every SQL DBA not only me.
  5. bertcord New Member

    http://www.veritas.com/Products/www?c=product&refId=317
  6. derrickleggett New Member

    You "could" use Profiler for Physical Reads and Executions. You might want to look at Quest Foglight. There isn't a counter for "Top 10" of anything that I'm aware of.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.

Share This Page