SQL Server Performance

A good tool for DBA

Discussion in 'Third Party Tools' started by CanadaDBA, Oct 4, 2005.

  1. CanadaDBA New Member

    There are lots of tools for SQL Server available in the market. What is a good one for a DBA to purchase? Why? Are you using it in your environment?

    CanadaDBA
  2. dineshasanka Moderator

  3. CanadaDBA New Member

  4. benwilson New Member

    I use the Redgate tools- SQL compare, SQL Data Compare, etc (www.regate.com i think).

    But like Dinesh said- check out the Software spotlights on this website- I have tried and do use other tools, but it's hard to recommend a tool when we don't know what you want to do with it!!

    Ben

    'I reject your reality and substitute my own' - Adam Savage
  5. CanadaDBA New Member

    I have four databases for four applications with at least 200 connection on my server. These are in use during business day hours. I want to find out where there is a problem or can be optimised and also how many other databases I can add to the server?


    quote:Originally posted by benwilson

    I use the Redgate tools- SQL compare, SQL Data Compare, etc (www.regate.com i think).

    But like Dinesh said- check out the Software spotlights on this website- I have tried and do use other tools, but it's hard to recommend a tool when we don't know what you want to do with it!!

    Ben

    'I reject your reality and substitute my own' - Adam Savage

    CanadaDBA
  6. Luis Martin Moderator

    To monitor I use spotlight from Quest.


    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


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



  7. satya Moderator

    There is no such tool in the market to say this is 100% perfect and works at all the times. You have to decide which will suit at best to your needs by referring to the Tools section under this website.

    quote:Originally posted by CanadaDBA

    There are lots of tools for SQL Server available in the market. What is a good one for a DBA to purchase? Why? Are you using it in your environment?

    CanadaDBA
  8. merrillaldrich New Member

    Hello, Canada -- we use Idera SQL Diagnostic Manager to keep tabs on 5 production servers. I've been very happy with it.
  9. thomas New Member

    enterprise Manager, Profiler, Performanc eMonitor, Query Analyzer. Why waste more money? You already have the tools you need. With a little imagination, work and ingenuity you can do all you need yourself.

    Tom Pullen
    DBA, Oxfam GB
  10. gkrishn New Member

    usually DBAs are lazy goin through each system/EM ,read error logs,check job status etc.. So i believe its always good to have a centralised machanism(Thirdparty tool/notification script) to monitor all SQL server boxes .
    -rajiv
  11. satya Moderator

    This is where the best practices comes up, it is always good to have such third party tool but it will not completely work for your situation. So in that case you must need to deploy the pre-supplied tools with WIndows & SQL Server, I agree with Tom.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  12. dasaluga New Member

    I also highly recommend SQL Diagnostics by Idera. I use it every day. Full of functionality.

    Don Saluga
  13. 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.
  14. Luis Martin Moderator

    Worderfull tool Crtl+C and Crtl+V[}<img src='/community/emoticons/emotion-1.gif' alt=':)' />]. <br /><br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12019>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12019</a><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />

Share This Page