From: esquel@sommarskog.se   
      
   Bob Barrows (reb01501@NOyahoo.SPAMcom) writes:   
   >> So, does anyone know how to perform such a capturing? How do the three   
   >> products mentioned in the above citation do it?   
   >   
   > They use server-side traces - google and BOL will provide lots of   
   > information about creating and running server-side traces.   
      
   In case in one the products mention, I can add a testimony: I was   
   contacted by a person from that company, and he wanted to know how to   
   get access to the TDS specification. This was when the specification   
   still was under NDA. Whether they actually were able to get access to   
   the specification, or whether they opted to use server-side traces   
   I don't know.   
      
   > Re. Banana's suggestion to use SQL Profiler, he is correct that using   
   > Profiler like this will adversely affect performance. If you want to   
   > roll your own, use server-side traces instead - properly configured and   
   > filtered, they will likely have very little affect on performance.   
      
   That depends on what you trace. I know. I have caused performance issues   
   in production environments by running server-side traces. Filtering does   
   not always help. I inadvertently left a trace running which included the   
   Showplan event. The trace was filtered for a certain spid, but the entire   
   server was affected.   
      
   I don't think Showplan events are of interest in this case, but I still   
   wanted to add the caveat that you can cause damage with server-side   
   traces as well.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)