SQL Server Performance

DBA tool for SQL Server 2K5

Discussion in 'Third Party Tools' started by CanadaDBA, Jan 25, 2007.

  1. CanadaDBA New Member

    I have an environment of SQL Server 2K5 and 2000 servers. The environment is mostly data warehouse than transactional. There are some applications working continiously to provid reports. The servers must be up and running.

    I have to provide high availability, monitor performance, and minimize down time. Is there any "really good" tool for a DBA for this environment? I would like to hear your experience with the tool you are using. Any practical suggestion is highly appreciated.

    Thanks,

    CanadaDBA
  2. Luis Martin Moderator

    SQL Diagnostic from Idera.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



  3. MohammedU New Member

  4. CanadaDBA New Member

    Actually, I have done a research on this topic but I am looking for results from those whom are using the tools.

    On my list, the two top ones are Quest and Idrea products.


    quote:Originally posted by MohammedU

    There are may in the market...
    Quest Central for SQL Server
    http://www.quest.com/sql_server/

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


    Mohammed U.

    CanadaDBA
  5. MohammedU New Member

    We purchase QUEST recently...


    Mohammed U.
  6. Luis Martin Moderator

    What I like from SQL Diagnostics is:
    1) Nothing is installed in server.
    2) Keep history up to 1 year.
    3) You can set to check server each minut or n seconds.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



  7. CanadaDBA New Member

    Thanks Luis! This is what I am looking for. A DBA's idea about the tool he/she is using.

    Anyone else? No idea out there?


    quote:Originally posted by LuisMartin

    What I like from SQL Diagnostics is:
    1) Nothing is installed in server.
    2) Keep history up to 1 year.
    3) You can set to check server each minut or n seconds.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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





    CanadaDBA
  8. joechang New Member

    i mentioned this in another post,
    but everyone that i have asked,
    specifically what helped from the third party tool they were using

    aside from obvious, cpu was high, response was slow,
    you could hand in a report that no one will really read,
    showing that you appear to be working,

    no one could provide a specific item
    so i would like to know as well
  9. CanadaDBA New Member

    Post your idea/experience please <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />CanadaDBA
  10. satya Moderator

    I have to provide high availability, monitor performance, and minimize down time. Is there any "really good" tool for a DBA for this environment? I would like to hear your experience with the tool you are using. Any practical suggestion is highly appreciated.

    What is your requirement?
    Is it to provide high-availability and monitor performance, then SSMS and other HA options such as Clustering & Database mirroring should get you what you want. But remember to test the available options regularly in order to ensure in any unforeseen circumstances you can take good action to reduce the downtime to minimum.

    I have never used any third party tool to monitor or manage SQL instances and always using pre-installed, available tools that comes with SQL installation. But I would also state that every requirement is different to each other and we never had such opportunity to deploy any third party tool to monitor the server, more or less we are able to manage over 500 SQL instances without any issues.

    As suggested you can test and try the evaluation editions of third party tools, also refer to the Software Spotlight section in this website where you will get complete in hand information about a product that can give you high-level & first-hand information. But do not forget to test the tool completely before deploying it on the production.

    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. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  11. cb New Member

    well said and canadadba you need to be clear about problem with current sql tools you have.
  12. CanadaDBA New Member

    Well, I am new in SQL 2K5 but from SQL2000 experience, I wish to have alerts and emails in case anything happened to my server in SQL or Windows level; i.e. CPU over usage, memory, and/or disk. I am not sure, maybe SQL 2K5 has enough new tools to provid these information.

    I have downloaded some tools from Idera. The SQL Diagnostic Manager looks fine but SQLsecure seems useless. I am still in testing stage and it's not fair to judge now.


    quote:Originally posted by cb

    well said and canadadba you need to be clear about problem with current sql tools you have.

    CanadaDBA
  13. satya Moderator

    Well, testing can only be a good thing for you at the moment to decide on the third party tools. Anyway have you looked into the SQL Server tools such as SSMS and others in thsi case.

    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. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  14. CanadaDBA New Member

    After almost three months, I back to this to complete my posts for people who may read this topic. I tested Quest's and Idera's tools. We almost bought Quest tools but it impacted our production and we had to return the products.
    I am now testing Embarcadero's tools. We have planned to purchase "DBArtisan" and "Performance Center". They seem to be good tools. You can download Trial products from http://www.embarcadero.com/.
    Cheers,
  15. satya Moderator

    I can say you are one of those posters who would like to give feedback and following their own thread, appreciate your patience in this regard. THis helps others too who are looking for similar suggestions.
  16. CanadaDBA New Member

    It's two years later..
    Although we have Embarcadero tools but our DBA team decided to purchase another tool called SQL Sentry. It's great tool. Very handy.
  17. satya Moderator

    Every tool has its own advantages & disadvantages, to be happy that if the requirement is met atleast 80%...
  18. paultim374 New Member

    Dear I wish to have alerts and emails in case anything happened to my server in SQL or Windows level; i.e. CPU over usage, memory, and/or disk. I am not sure, maybe SQL 2K5 has enough new tools to provid these information.
  19. Luis Martin Moderator

    Welcome to the forums!.
    Always try to start a new thread. This one is 3 years old.
    About your question:
    SQL Monitor from Red Gate.

Share This Page