Return
-
Title
stored procedures ran by Spotlight -
Description
What stored procedures does Spoltight run , where are they ?
What is their overhead for the database ?
-
Resolution
The product uses one of the following 3 sets of stored procedures depending on version of monitored SQL Server:
<Quest Software>\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2000
<Quest Software>\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2005
<Quest Software>\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2008The Diagnostic Server runs them on regular basis with a rates specified separately for every schedule (Configure | Collection: Scheduling).
Most of scripts collect data from SQL Server by running select statements against system tables and dynamic views; they don’t change SQL Server or DB settings.
Normally SQL scripts Spotlight runs return small volumes of data (rather kilobytes than Mb or Gb).