3rd party sql server tools for admin

  • I need help. i have grown really tired of having to read my logs using enterprise manager, everytime, a job fails or when i need to know who deleted or added what to the databases in sqlserver. i need to have more control.

    be able to tell whats going on in my databases, check on system resources, monitor query performances, changes in databases, manage my backups etc (WITHOUT HAVING TO USE ENTERPROSE MANAGER--IT SUCKS) or and i have an audit coming up soon and would really like to pass this year? i have a sql failover cluster, one instance of sql (but this may change in the future) . can anyone recommend any tools?? i am currently looking at ideratools but i would like to have more to choose from, and any input from dbas who are actually using these tools will be appreciatedf

    [font="Comic Sans MS"][/font]It is what it is.

  • Lara, We have just finished piloting the Symantec/Veritas prodcut called I3. IT is not too expensive for jsut one server and does a great job for the things you are speaking of.

    It also has extensions to monitor your application servers and SAN if you are running those. I would stay away from embarcadero. In my opinion their tools are slow, and bulky.

    We have been impressed with I3 and being a developer myself I am not easy to impress. I hope this helps. - A

    Adam Jorgensen
    Principal Architect
    Top Gun Performance
    jorgensen.adam@gmail.com
    “Tuning Is Not Just For Guitars...”

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply