Re: Consultants - FREE Zero Impact Sql & Service Level Monitor

[Quoted] There are some serious shortcomings of this product.

1. The security implications of having to / allowing a Network Interface to operate in promiscuous mode (to grab all packets, regardless of destination).
2. Possibly having to change your DataLink / Physical (OSI Model) network infrastructure, e.g. throw out your switch(s) and replace them with hubs just to get this poor-substitute-for a-real-DBA tool to work.
3. Advanced Networking Option would give this package a VERY hard time (i.e. it would stop it in its tracks) because packets are encrypted.

Last but not least; any monitoring package can extract performance data (either by measuring response times or by looking at all the dynamic performance views and so on. That's great. But that doesn't actually help you tune the server does it?. To do that takes never ending practice and book-studying.

David P. OCP (DBA) MCP (TCP/IP)

Glasgow, Scotland.

Neil Pike wrote:
>
> Paul,
>
> > > > !!!!!!! You must be kidding or simply you are liars !!!!!!!
> > > >
> > > > ZERO-IMPACT - does anyone really believe in this absolute lie.
> > >
> > > Yes, SQL Power tools claims of superiority over other tools are OTT and not all substantiated,
> > > but it IS true that they are zero impact.
> >
> > Ever heard of the Heisenberg principle :-)
>
> Yes, but if you read my explanation you would understand why this doesn't apply. Think of it like a radar gun used
> by police to monitor the speed of a car. The radar gun is a monitoring device, but it doesn't affect the speed of
> the car does it? Well, not until the driver notices the policeman anyway..... ;-)
>
> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please reply only to newsgroups)
> SQL FAQ (428 entries) see
> forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7 - SQL Public)
> or www.ntfaq.com/sql.html
> or www.sql-server.co.uk
> or www.mssqlserver.com/faq
  Received on Wed May 24 2000 - 00:00:00 CEST