Francisco Tapia
fhtapia at gmail.com
Mon Apr 19 15:14:25 CDT 2010
I am currently using RedGate's Sql Response it's inexpensive and provides me with the health monitoring tools I need. I used to use Idera's Sql Diagnostic Manager, but it's big slow and costs waaaay too much $$ I've liked sql response as you can configure it to also trace servers that are problematic and you can trace down to problem areas. I recently tried out Ignite's performance intelligence, it's very price, but come in handy if you have a server that is behaving really slow and you haven't been able to determine what the problem was using just a trace (it's nothing special, but it clearly navigates you to problem hardware or software issues) ie, in my situation I had one server that appears to have a low load and I thought I could just add another database, but after using ignite i found that the problem was with my subsystem i/o. Since the server was out of warranty our helpdesk ordered up a new server with many more spindles and of course more ram and cpu and now I house many more databases on this system. so it was kinda cool that I found the information by drilling down. but the reason we haven't bought it is because its very very pricey just like idera where they want over $2k per instance... -Francisco http://sqlthis.blogspot.com | Tsql and More... On Mon, Apr 19, 2010 at 12:12 PM, <Elizabeth.J.Doering at wellsfargo.com>wrote: > Does anyone have any great suggestions for favorite performance monitoring > tools? Do you roll your own or is there something off the shelf you like? > > > > Thanks, > > Liz > > This message may contain confidential and/or privileged information. If you > are not the addressee or authorized to receive this for the addressee, you > must not use, copy, disclose, or take any action based on this message or > any information herein. If you have received this message in error, please > advise the sender immediately by reply e-mail and delete this message. Thank > you for your cooperation. > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >