| Author |
Looking for SQL perf analyzing tool
|
|
|
| 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
| |
| John Bell 2006-03-05, 8:24 pm |
| 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...nter/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@hotma
il.com> wrote in message
news:56EEB7AC-2036-4534-9D16- 5E6191EA4729@microso
ft.com...[color=darkred]
> 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...nter/index.html
>
> John
>
>
> "Jims" wrote:
>
|
|
|
|