Consultants - FREE Zero Impact Sql & Service Level Monitor
Not a technical problem thread but a vendor advertisement (SQL Power Tools' "Zero Impact" SQL/service-level monitor) and the newsgroup's reaction. Posters attacked the "zero impact" and anti-competitor claims; Neil Pike and Jonathan Leffler explained the tool is a passive network packet sniffer on a separate box, so it costs money and setup (SPAN port/promiscuous NIC) but adds no load to the database server. Others noted limits: it can't see shared-memory or loopback connections, encrypted traffic (CSS/CSM, Oracle ANO) defeats it, and promiscuous mode raises security concerns. No problem/fix as such.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Consultants - FREE Zero Impact Sql & Service Level Monitor ========================================================== The database and service level monitor with ZERO impact wins! Consultants build your SQL performance, tuning and service level consulting practices with the Zero Impact Sql and Service Level Monitoring products. Sql Power Tools, Inc. is a product based company and rarely if ever provides consulting services. Consultants are under NO obligation to recommend the product line to your customer base. Sql Power Tools will give Consultants a free copy of the industry breakthrough Zero Impact Sql Monitor and Zero Impact Service Level Monitor products! Excellent for monitoring with ZERO impact - database servers having 50 to 10,000+ users and processing 50 to 10,000+ SQL transactions per second. Zero Impact Sql Monitor and Zero Impact Service Level Monitor products are available for DB2, Informix, Microsoft, Oracle and Sybase. You may install the products on a laptop (takes a few minutes) and build your SQL performance, tuning and service level consulting practices. Once installed on a laptop, simply plug the laptop into a client's network and you will be IMMEDIATELY capturing and monitoring: 1. All or any subset of the SQL statements (with their performance) sent to the database server 24x7 with the Zero Impact Sql Monitor. Plus filter or reconstruct the SQL statements from any prior time period. Real-time alerts pinpoint poor performing production SQL. Reconstructs all Transact-SQL batches involved in a deadlock or blocked process for a transaction. 2. Average end user response time, average database server response time, average network send and receive time plus other important Service Level metrics by monitoring interval with the Zero Impact Service Level Monitor. Product allows detection of trending poor database performance prior to end-users contacting the Help Desk, DBAs or Administrators. Real-time alerts pinpoint monitoring intervals with poor database server or end user performance. Refer to the following section 'IV. What can you do with the product line?'. I. Product overview: =================== The products scale to thousands of users and 1000+ transactions per second with no impact upon the database server, network or end users. Perfect for production, OLTP, WWW, eCommerce, 3-Tier, DSS, test, and SQL development database monitoring. Product line requires no connection to the database server, nor are agents installed on the server or client workstations. No software is installed upon the customer's server, network or client workstations. Requires no installation of performance impacting database monitors, probes, traces or database audits. Requires no intrusive middleware, gateways or proxy servers that impact the performance of end user SQL transactions. Product installation on a laptop is a three step process that takes a few minutes. Product GUI is intuitive and a snap to learn (no customer has required a class on product usage todate!) We will give you complete product support at no charge. II. How the product works: ========================= The product line non-intrusively analyzes the SQL network packet flow to the database server for end-user SQL and service level performance monitoring. In the SQL network packets are the SQL statements, results, error messages, show plans, I/O statistics and more. SQL statement performance is obtained from real-time network packet time stamps provided by the network adapter. Install the product on your laptop (takes a few minutes), then plug the laptop into a client's network (client does NOT need to assign you an IP address) and you will be IMMEDIATELY capturing and monitoring database server performance. The laptop needs to be connected to the network on the same subnet or switch as the database server. Then our product can non-intrusively view and analyze the SQL packet flow to the database server. Product is available for 95, 98, NT, AIX, HP-UX and Solaris laptops. From any laptop a database server on any other platform type can be monitored (e.g. Linux, SCO Unix, Sequent, DEC, etc.). III. Competitive monitoring approaches: ====================================== Other industry database monitoring approaches are less than satisfactory due to the following issues: 1. They do NOT capture or monitor 24x7 what causes 80% of all database server production performance problems (end-user SQL transactions). They monitor high level resources, the cause of about 20% of all database performance problems. 2. They do NOT monitor end-user or database server response time (service levels) at the SQL statement level for predictive identification of pending performance problems. (e.g. poor database performance caused by disk space fragmentation, skewed distribution statistics, outdated distribution statistics, increased transaction loads, poor performing SQL statements, blocked SQL transactions as well as other performance issues) 3. They are intrusive, difficult/expensive to install and setup, have a high cost of operation and are usually quite expensive. 4. They are so intrusive they may not be used 24x7 in production environments. i.e. they may only be used in development and test environments, not in production where SQL performance plus end user service level measurement is critical to success. 5. Other database monitors may not scale well when additional users are added or transaction processing requirements increase. 6. Other database monitors that do not measure Service Levels such as end-user response time, database server response time, network time and other metrics which allows DBAs, Administrators and Help Desks to proactively detect and resolve database performance issues prior to end user complaints. 7. Rejected database server login attempts are not monitored. Important for E-Commerce, WWW and web based end-user database access. The real business payoff with database monitoring products is obtained when monitoring occurs at the end-user SQL transaction level, not when monitoring high level system resources (NT and UNIX allow availability, cpu utilization, I/O, memory, etc. to be easily monitored). Then the cause of production database server performance problems can be immediately pinpointed to specific SQL transactions. Plus service level monitoring proactively alerts DBAs, Administrators and Help Desks trending performance issues. IV. What can you do with the product line? ========================================= Build your SQL performance, tuning and database service level consulting practices. Assist your clients in pinpointing and resolving problematic SQL performance in production environments (a great service to your client and generates significant consulting revenues). Assist your clients is setting up 24x7 service level management programs for DBAs, Administrators and Help Desks. You may save your client an expensive hardware upgrade! From your laptop use the Zero Impact Sql Monitor and Zero Im
Does your product work with Sybase IQ 12.4 (our Data Warehouse database server)? We are in the process of evaluating product like your product. At the moment only Teleran (iSight, iGuard) seams to work with IQ. Thanks a lot. Gino Santerre Entrep't de donn'es - Qu'becTel http://www.quebectel.qc.ca In article <8gcd21$r81$1@slb0.atl.mindspring.net>, "Mary Owens" <mowens@sqlpower.com> wrote: > Consultants - FREE Zero Impact Sql & Service Level Monitor > ========================================================== > > The database and service level monitor with ZERO impact wins! > > Consultants build your SQL performance, tuning and service level consulting > practices with the Zero Impact Sql and Service Level Monitoring products. > Sql Power Tools, Inc. is a product based company and rarely if ever > provides consulting services. Consultants are under NO obligation to > recommend the product line to your customer base. > > Sql Power Tools will give Consultants a free copy of the industry > breakthrough > Zero Impact Sql Monitor and Zero Impact Service Level Monitor products! > Excellent for monitoring with ZERO impact - database servers having 50 to > 10,000+ > users and processing 50 to 10,000+ SQL transactions per second. > > Zero Impact Sql Monitor and Zero Impact Service Level Monitor products are > available for DB2, Informix, Microsoft, Oracle and Sybase. > > You may install the products on a laptop (takes a few minutes) and build > your SQL performance, tuning and service level consulting practices. Once > installed on a laptop, simply plug the laptop into a client's network and > you will be IMMEDIATELY capturing and monitoring: > > 1. All or any subset of the SQL statements (with their performance) sent > to the database server 24x7 with the Zero Impact Sql Monitor. Plus > filter or reconstruct the SQL statements from any prior time period. > > Real-time alerts pinpoint poor performing production SQL. > > Reconstructs all Transact-SQL batches involved in a deadlock or blocked > process for a transaction. > > 2. Average end user response time, average database server response > time, average network send and receive time plus other important > Service Level metrics by monitoring interval with the > Zero Impact Service Level Monitor. Product allows detection of > trending poor database performance prior to end-users contacting > the Help Desk, DBAs or Administrators. Real-time alerts pinpoint > monitoring intervals with poor database server or end user performance. > > Refer to the following section 'IV. What can you do with the product line?'. > > I. Product overview: > =================== > > The products scale to thousands of users and 1000+ transactions per > second with no impact upon the database server, network or end users. > Perfect for production, OLTP, WWW, eCommerce, 3-Tier, DSS, test, and > SQL development database monitoring. > > Product line requires no connection to the database server, nor are > agents installed on the server or client workstations. No software is > installed upon the customer's server, network or client workstations. > Requires no installation of performance impacting database monitors, > probes, traces or database audits. Requires no intrusive middleware, > gateways or proxy servers that impact the performance of end user > SQL transactions. > > Product installation on a laptop is a three step process that takes > a few minutes. Product GUI is intuitive and a snap to learn (no > customer has required a class on product usage todate!) We will > give you complete product support at no charge. > > II. How the product works: > ========================= > > The product line non-intrusively analyzes the SQL network packet > flow to the database server for end-user SQL and service level > performance monitoring. In the SQL network packets are the SQL > statements, results, error messages, show plans, I/O statistics > and more. SQL statement performance is obtained from real-time > network packet time stamps provided by the network adapter. > > Install the product on your laptop (takes a few minutes), then > plug the laptop into a client's network (client does NOT need to > assign you an IP address) and you will be IMMEDIATELY capturing > and monitoring database server performance. The laptop needs > to be connected to the network on the same subnet or switch > as the database server. Then our product can non-intrusively > view and analyze the SQL packet flow to the database server. > > Product is available for 95, 98, NT, AIX, HP-UX and Solaris > laptops. From any laptop a database server on any other > platform type can be monitored (e.g. Linux, SCO Unix, Sequent, > DEC, etc.). > > III. Competitive monitoring approaches: > ====================================== > > Other industry database monitoring approaches are less than > satisfactory due to the following issues: > > 1. They do NOT capture or monitor 24x7 what causes 80% of all database > server production performance problems (end-user SQL transactions). > They monitor high level resources, the cause of about > 20% of all database performance problems. > > 2. They do NOT monitor end-user or database server response time > (service levels) at the SQL statement level for predictive > identification of pending performance problems. > > (e.g. poor database performance caused by disk space fragmentation, > skewed distribution statistics, outdated distribution statistics, > increased transaction loads, poor performing SQL statements, > blocked SQL transactions as well as other performance issues) > > 3. They are intrusive, difficult/expensive to install and setup, > have a high cost of operation and are usually quite expensive. > > 4. They are so intrusive they may not be used 24x7 in production > environments. i.e. they may only be used in development and > test environments, not in production where SQL performance > plus end user service level measurement is critical to success. > > 5. Other database monitors may not scale well when additional users > are added or transaction processing requirements increase. > > 6. Other database monitors that do not measure Service Levels such > as end-user response time, database server response time, network > time and other metrics which allows DBAs, Administrators and Help > Desks to proactively detect and resolve database performance issues > prior to end user complaints. > > 7. Rejected database server login attempts are not monitored. Important > for E-Commerce, WWW and web based end-user database access. > > The real business payoff with database monitoring products is > obtained when monitoring occurs at the end-user SQL transaction > level, not when monitoring high level system resources (NT and UNIX > allow availability, cpu utilization, I/O, memory, etc. to be easily > monitored). Then the cause of production database server performance > problems can be immediately pinpointed to specific SQL transactions.@@NL
GSANTE1@quebectel.qc.ca wrote: > > Does your product work with Sybase IQ 12.4 (our Data Warehouse > database server)? We are in the process of evaluating product like your > product. At the moment only Teleran (iSight, iGuard) seams to work with > IQ. > Oh God don't encourage them!!!!!!!!!! -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #
!!!!!!! You must be kidding or simply you are liars !!!!!!! ZERO-IMPACT - does anyone really believe in this absolute lie. Just look at the section III (Competitive monitoring approaches:) ====================================== Other industry database monitoring approaches are less than satisfactory due to the following issues: 1. They do NOT capture or monitor 24x7 what causes 80% of all database server production performance problems (end-user SQL transactions). They monitor high level resources, the cause of about 20% of all database performance problems. !!!!!!!!!! This is absolute lie. Most commercial monitors do that !!!!!!!!!!! 2. They do NOT monitor end-user or database server response time (service levels) at the SQL statement level for predictive identification of pending performance problems. (e.g. poor database performance caused by disk space fragmentation, skewed distribution statistics, outdated distribution statistics, increased transaction loads, poor performing SQL statements, blocked SQL transactions as well as other performance issues) !!!!!!!!!! This is absolute lie. Most commercial monitors do that !!!!!!!!!!! 3. They are intrusive, difficult/expensive to install and setup, have a high cost of operation and are usually quite expensive. !!!!!!!!!! Simply not true. Most good tools can be installed in minutes by anyone !!!!!!!!!!! 4. They are so intrusive they may not be used 24x7 in production environments. i.e. they may only be used in development and test environments, not in production where SQL performance plus end user service level measurement is critical to success. !!!!!!!!!! This is not true again. Only poorly designed tools perform in such manner !!!!!!!!!!! 5. Other database monitors may not scale well when additional users are added or transaction processing requirements increase. !!!!!!!!!! This is absolute lie. !!!!!!!!!!!!!!!! 6. Other database monitors that do not measure Service Levels such as end-user response time, database server response time, network time and other metrics which allows DBAs, Administrators and Help Desks to proactively detect and resolve database performance issues prior to end user complaints. !!!!!!!!!! This is absolute lie. Looks like "SQL Power Tools" guys don't know Oracle well !!!!!!!!!!!! 7. Rejected database server login attempts are not monitored. Important for E-Commerce, WWW and web based end-user database access. !!!!!!!!!! Can be easily done in Oracle. Looks like "SQL Power Tools" guys don't know Oracle well !!!!!!!!!!!! Sent via Deja.com http://www.deja.com/ Before you buy.
whoever, > !!!!!!! 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. The product works by analysing the network packets to/from the client or server. It does this on a separate box - the network must be configured such that it can see all the packets (i.e. via a SPAN port in a switched environment). It is zero impact and requires no changes to client or server. Your repudiation of their points is just as OTT as their points themselves. 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
"It does this on a separate box - the network must be configured such that it can see all the packets" Neil, don't you contradict yourself? Everything has some cost. Nothing comes for nothing. In article <8gcd21$r81$1@slb0.atl.mindspring.net>, "Mary Owens" <mowens@sqlpower.com> wrote: > Consultants - FREE Zero Impact Sql & Service Level Monitor > ========================================================== > > The database and service level monitor with ZERO impact wins! > > Consultants build your SQL performance, tuning and service level consulting > practices with the Zero Impact Sql and Service Level Monitoring products. > Sql Power Tools, Inc. is a product based company and rarely if ever > provides consulting services. Consultants are under NO obligation to > recommend the product line to your customer base. > > Sql Power Tools will give Consultants a free copy of the industry > breakthrough > Zero Impact Sql Monitor and Zero Impact Service Level Monitor products! > Excellent for monitoring with ZERO impact - database servers having 50 to > 10,000+ > users and processing 50 to 10,000+ SQL transactions per second. > > Zero Impact Sql Monitor and Zero Impact Service Level Monitor products are > available for DB2, Informix, Microsoft, Oracle and Sybase. > > You may install the products on a laptop (takes a few minutes) and build > your SQL performance, tuning and service level consulting practices. Once > installed on a laptop, simply plug the laptop into a client's network and > you will be IMMEDIATELY capturing and monitoring: > > 1. All or any subset of the SQL statements (with their performance) sent > to the database server 24x7 with the Zero Impact Sql Monitor. Plus > filter or reconstruct the SQL statements from any prior time period. > > Real-time alerts pinpoint poor performing production SQL. > > Reconstructs all Transact-SQL batches involved in a deadlock or blocked > process for a transaction. > > 2. Average end user response time, average database server response > time, average network send and receive time plus other important > Service Level metrics by monitoring interval with the > Zero Impact Service Level Monitor. Product allows detection of > trending poor database performance prior to end-users contacting > the Help Desk, DBAs or Administrators. Real-time alerts pinpoint > monitoring intervals with poor database server or end user performance. > > Refer to the following section 'IV. What can you do with the product line?'. > > I. Product overview: > =================== > > The products scale to thousands of users and 1000+ transactions per > second with no impact upon the database server, network or end users. > Perfect for production, OLTP, WWW, eCommerce, 3-Tier, DSS, test, and > SQL development database monitoring. > > Product line requires no connection to the database server, nor are > agents installed on the server or client workstations. No software is > installed upon the customer's server, network or client workstations. > Requires no installation of performance impacting database monitors, > probes, traces or database audits. Requires no intrusive middleware, > gateways or proxy servers that impact the performance of end user > SQL transactions. > > Product installation on a laptop is a three step process that takes > a few minutes. Product GUI is intuitive and a snap to learn (no > customer has required a class on product usage todate!) We will > give you complete product support at no charge. > > II. How the product works: > ========================= > > The product line non-intrusively analyzes the SQL network packet > flow to the database server for end-user SQL and service level > performance monitoring. In the SQL network packets are the SQL > statements, results, error messages, show plans, I/O statistics > and more. SQL statement performance is obtained from real-time > network packet time stamps provided by the network adapter. > > Install the product on your laptop (takes a few minutes), then > plug the laptop into a client's network (client does NOT need to > assign you an IP address) and you will be IMMEDIATELY capturing > and monitoring database server performance. The laptop needs > to be connected to the network on the same subnet or switch > as the database server. Then our product can non-intrusively > view and analyze the SQL packet flow to the database server. > > Product is available for 95, 98, NT, AIX, HP-UX and Solaris > laptops. From any laptop a database server on any other > platform type can be monitored (e.g. Linux, SCO Unix, Sequent, > DEC, etc.). > > III. Competitive monitoring approaches: > ====================================== > > Other industry database monitoring approaches are less than > satisfactory due to the following issues: > > 1. They do NOT capture or monitor 24x7 what causes 80% of all database > server production performance problems (end-user SQL transactions). > They monitor high level resources, the cause of about > 20% of all database performance problems. > > 2. They do NOT monitor end-user or database server response time > (service levels) at the SQL statement level for predictive > identification of pending performance problems. > > (e.g. poor database performance caused by disk space fragmentation, > skewed distribution statistics, outdated distribution statistics, > increased transaction loads, poor performing SQL statements, > blocked SQL transactions as well as other performance issues) > > 3. They are intrusive, difficult/expensive to install and setup, > have a high cost of operation and are usually quite expensive. > > 4. They are so intrusive they may not be used 24x7 in production > environments. i.e. they may only be used in development and > test environments, not in production where SQL performance > plus end user service level measurement is critical to success. > > 5. Other database monitors may not scale well when additional users > are added or transaction processing requirements increase. > > 6. Other database monitors that do not measure Service Levels such > as end-user response time, database server response time, network > time and other metrics which allows DBAs, Administrators and Help > Desks to proactively detect and resolve database performance issues > prior to end user complaints. > > 7. Rejected database server login attempts are not monitored. Important > for E-Commerce, WWW and web based end-user database access. > > The real business payoff with database monitoring products is > obtained when monitoring occurs at the end-user SQL transaction > level, not when monitoring high level system resources (NT and UNIX > allow availability, cpu utilization, I/O, memory, etc. to be easily > monitored). Then the cause of production database server performance > problems can be immediately pinpointed to specific SQL transactions. > Plus service level monitoring proactively alerts DBAs, Administrators > and Help Desks trending performance issues.@
Neil Pike wrote: > > whoever, > > > !!!!!!! 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 :-) -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #
devdev@my-deja.com wrote: > "It does this on a separate box - the network must be configured such > that it can see all the packets" > > Neil, don't you contradict yourself? Everything has some cost. Nothing > comes for nothing. > > In article <8gcd21$r81$1@slb0.atl.mindspring.net>, > "Mary Owens" <mowens@sqlpower.com> wrote: > > Consultants - FREE Zero Impact Sql & Service Level Monitor > > ========================================================== > > > > The database and service level monitor with ZERO impact wins! The claim is zero impact -- not zero cost. Since the ethernet is a CDMA (collision detect, multiple access) system, every computer on a network segment gets to hear every packet sent over the network. There is no impact on the computers being monitored if a third CPU also records the message -- that's what packet sniffers do. So there is no impact on the monitored systems. There is a cost; you have to set up the third computer with the correct software and settings. It is probably a trifle difficult to monitor loopback connections and definitely more than a trifle difficult to monitor shared memory or olipcstr connections -- they don't touch the network. But if the info goes over the network, it can be snooped by a suitable computer. Unless, of course, you're using the CSS/CSM module to encrypt your messages... -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>
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
Yes but as radar has an energy level this energy is impinged on the car, some is absorbed and some is reflected, therefore it does have an affect on the car. Ignoring the pure energy type approach, if the radar, ie radio waves, had no effect on the car then why do manufacturers spend millions testing their cars for the effection for EMC 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 -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #
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
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
> "It does this on a separate box - the network must be configured such > that it can see all the packets" > > Neil, don't you contradict yourself? Everything has some cost. Nothing > comes for nothing. It is zero impact on SQL Server and any other device on the network. There is a monetary cost in having a box to run it on, and potential monetary cost in reconfiguring your network, but that's it. 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
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
Ok then - think of it like someone timing a runner with a stop-watch. Does that affect the runner! :-) > Yes but as radar has an energy level this energy is impinged on the > car, some is absorbed and some is reflected, therefore it does have an > affect on the car. Ignoring the pure energy type approach, if the radar, > ie radio waves, had no effect on the car then why do manufacturers spend > millions testing their cars for the effection for EMC 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
well in that case he may run faster knowing that he is being time !!!!! Neil Pike wrote: > Ok then - think of it like someone timing a runner with a stop-watch. Does that affect the runner! :-) > > > Yes but as radar has an energy level this energy is impinged on the > > car, some is absorbed and some is reflected, therefore it does have an > > affect on the car. Ignoring the pure energy type approach, if the radar, > > ie radio waves, had no effect on the car then why do manufacturers spend > > millions testing their cars for the effection for EMC > > 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
OK you win - the greatest physics minds the world has ever produced who agree that the Heisenberg principle is correct are all wrong :-)) That's why I like newsgroup you learn something new everyday!!! :-)) Neil Pike wrote: > > Ok then - think of it like someone timing a runner with a stop-watch. Does that affect the runner! :-) > > > Yes but as radar has an energy level this energy is impinged on the > > car, some is absorbed and some is reflected, therefore it does have an > > affect on the car. Ignoring the pure energy type approach, if the radar, > > ie radio waves, had no effect on the car then why do manufacturers spend > > millions testing their cars for the effection for EMC > > 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 -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #
The Heisenberg Uncertainty Principle applies to quantum level objects and to some extent to other larger subatomic particles. It does not apply to database servers or track stars. Art S. Kagel Paul Watson wrote: > > OK you win - the greatest physics minds the world has ever produced who > agree that the Heisenberg principle is correct are all wrong :-)) > > That's why I like newsgroup you learn something new everyday!!! :-)) > > Neil Pike wrote: > > > > Ok then - think of it like someone timing a runner with a stop-watch. Does that affect the runner! :-) > > > > > Yes but as radar has an energy level this energy is impinged on the > > > car, some is absorbed and some is reflected, therefore it does have an > > > affect on the car. Ignoring the pure energy type approach, if the radar, > > > ie radio waves, had no effect on the car then why do manufacturers spend > > > millions testing their cars for the effection for EMC > > > > 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 > > -- > Paul Watson # > WF Software Ltd # You are only young once > Tel: +44 1436 674729 # but you can be immature > Fax: +44 1436 678693 # for ever > www.wfsoftware.com #
The Zero Impact Sql Monitor product line is being used by several of the most security conscious firms in the world (eCommerce, Wall Street, banks, manufacturing, telecommunications, utilities, etc. firms) as well as in US Defense agencies. It has had to obtain at these organizations the approval of management, system administrators and auditors. Conclusion. The product line presents no security problems or issues. DNP <High.Flight@btinternet.com> wrote in message news:392BD6AE.2473@btinternet.com... > 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
unless the stopwatch is made of a weightless material it will slow down the runner if he is carrying it :o) of course if he is being timed by someone else and they haven't told him...... -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf . Neil Pike <100577.553@compuserve.com> wrote in message ... > Ok then - think of it like someone timing a runner with a stop-watch. Does that affect the runner! :-) > > > Yes but as radar has an energy level this energy is impinged on the >> car, some is absorbed and some is reflected, therefore it does have an >> affect on the car. Ignoring the pure energy type approach, if the radar, >> ie radio waves, had no effect on the car then why do manufacturers spend >> millions testing their cars for the effection for EMC > > 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 > >
I'm uncertain. -- Niall Litchfield Oracle DBA Audit Commission UK "Paul Watson" <paulw@wfsoftware.com> wrote in message news:392AD404.DEC62BCF@wfsoftware.com... > Ever heard of the Heisenberg principle :-)
This is really good. Other people are using it, and they worry about security therefore the product has "no security problems or issues". BS. I'm sure they use Windows NT. Does that have security issues? Let's not forget advertising on a support newsgroup. Must be a great company. On Wed, 24 May 2000 16:08:40 -0400, "Randy Reiter" <rreiter@sqlpower.com> wrote: >The Zero Impact Sql Monitor product line is being used by several of the >most security conscious firms in the world (eCommerce, Wall Street, banks, >manufacturing, telecommunications, utilities, etc. firms) as well as in US >Defense agencies. It has had to obtain at these organizations the approval >of management, system administrators and auditors. > >Conclusion. The product line presents no security problems or issues. _______________ Jay M. Scheiner Programmer/Analyst Wolpoff & Abramson, LLP remove _nospm_ from email address Opinions are my own only!