Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jim
Hi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products/...ter/index.html
John
"Jims" wrote:
> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that requires
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardware
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>
|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...[vbcol=seagreen]
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products/...ter/index.html
> John
>
> "Jims" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment