SQL Server Performance

SQL monitoring Tools

Discussion in 'Getting Started' started by mwarner67, May 24, 2007.

  1. mwarner67 New Member

    Does anyone have any recommendations for sql monitoring tools? (either free or purchase) we currently don't have an for our SQL 2K server and would like to get something that can alert us when a variety of things bottleneck, error out, whatever. also like to be able to look at the connections, speed flow of queries etc. anything that you've tried and liked would be appreciated.

    Mike L. Warner
  2. MohammedU New Member

    Check the tools from Quest , Idera, red-gate and sql sentry etc...
    Just google these comany names you will find log...but you need to buy them...

    and also check the following...
    SQL Server Software Spotlights
    http://www.sql-server-performance.com/spotlights.asp

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. dineshasanka Moderator

  4. satya Moderator

    I would like to know why you want to go towards third party tools, is there any specific need or report you need to produce. You can take help of PERFMON & traces to get such information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. tfakih New Member

    Could you please tell me how to use Performance Monitor & Trace to monitor performance problem issue of a production server.

    Thanks
  6. Akthar New Member

    or you can use profiler and Windows PerfMon

    AKTHAR
  7. Akthar New Member

    you need to:
    1 - Go to Adminitrative tools - in Performance Monitor - add necessary counters- e.g Memory - pages /sec commited bytes, available bytes to monitor memory performances
    Add processor counters
    Add SQL server locks and other required SQL Server counters
    2. In SQL Server profiler - choose events you want to log, like locks, transactions etc.

    http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp



    AKTHAR
  8. satya Moderator

    Refer to the homepage of this SSP site and go through the articles section where you will find complete details in this regard.
    http://www.sql-server-performance.com/sg_sql_server_performance_article.asp - a starter

    quote:Originally posted by tfakih

    Could you please tell me how to use Performance Monitor & Trace to monitor performance problem issue of a production server.

    Thanks

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page