How does Periscope capture SQL information?
A. Periscope captures SQL statements by polling internal SQL Server tables. This is accomplished through-state-of-the art .NET SQL Data Reader calls and is extremely light weight. The captured data is then asynchronously written to a repository database which can be viewed through a variety of supplied reports. Q. How is Periscope for SQL Server installed? How many tiers are involved? A. No components are installed on the monitored SQL Server.
