SQL Server Performance

SLQ Tools

Discussion in 'Third Party Tools' started by alpha_cen, Dec 21, 2005.

  1. alpha_cen New Member

    Hello,

    since I haven't found any good references on the web I thought I just might ask you all experts what tools do you [suggest]/use with number of MS SQL Server 2000 & 2005. I need to assemble toolbox which would cover:
    - backup
    - transaction log browse/recovery
    - audit
    - configuration change/compare management (ie deploying changes to other servers, compare schema and config)
    - performance
    I know it's a big field and I might have quite a budget for this, but I would still like to hear what is really good and useful (as in high-end and in midle price range).

    Thanks

  2. Luis Martin Moderator

    Backup: Red Gate - Quest

    Rescue : Red Gate

    Audit :http://www.sql-server-performance.com/krell_omniaudit.asp
    http://www.sql-server-performance.com/da_dbaudit_spotlight.asp

    Configuration ...: Red Gate

    Performance : Diagnostic Manager (Idera), Spotlight (Quest), SQL Tools.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


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



  3. dineshasanka Moderator

  4. Madhivanan Moderator

    http://vyaskn.tripod.com/thirdparty.htm

    Madhivanan

    Failing to plan is Planning to fail
  5. SQLGeek New Member

    Performance and Capacity Planning: The one thrid party tool that our company uses is called DBPerform from Ashgrove Software (ashgrovesoftware.com). This tool is much more than a stress testing tool which it gets compared to and is how we found it. It allows us to model a client's workload by defining the transactions which make up the clinet's workload in what it calls a Workload Library. Then in the Execution Package tab you select specific items from the Workload Library to makeup the scenario you wish to test at that particular time. You can control all aspects of the execution environment, log the results to text or XML logs, concurrent connections/threads, interval release, interractively TPM during execution, and so on.

    It is part of our "tool kit" that each of us carries on client gigs. It very inexpensive compared to other full workload simulation and benchmarking products.
  6. Neo New Member

    quote:Originally posted by dineshasanka

    There are many spotlight are availvble inhttp://www.sql-server-performance.com/spotlights.asp

    Recsue - Log P.I.


    But most of them have not released for SQL Server 2005.



    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka


    Dineshasnka,

    You mentioned Log P.I. I checked them out from Google search and found them now part of a company called Goldengate. They did not have much info. I am curious to know what became of the old product and if anyone knows about how the technology will be used.

    Thomas

    "Okey dokey... free my mind. Right, no problem, free my mind, free my mind, no problem, right... "
  7. satya Moderator

  8. Neo New Member

    Thanks Satya. Very helpful links.

    "Okey dokey... free my mind. Right, no problem, free my mind, free my mind, no problem, right... "
  9. Neo New Member

    quote:Originally posted by alpha_cen

    Hello,

    since I haven't found any good references on the web I thought I just might ask you all experts what tools do you [suggest]/use with number of MS SQL Server 2000 & 2005. I need to assemble toolbox which would cover:
    - backup
    - transaction log browse/recovery
    - audit

    - configuration change/compare management (ie deploying changes to other servers, compare schema and config)
    - performance
    I know it's a big field and I might have quite a budget for this, but I would still like to hear what is really good and useful (as in high-end and in midle price range).

    Thanks



    You mentioned a high budget and that would be where you would find Lumigent but they have not released a new Log Explorer in ages. No news in sight either. I am curious if anyone is using Log Explorer and what the word on the street is for a new release? I don't believe they are a sponsor here but they are (or at least were) a player in this space.

    Thomas

    "Okey dokey... free my mind. Right, no problem, free my mind, free my mind, no problem, right... "

Share This Page