This procedure, when executed, will return all SQL statements for the given date range along with key statistics like executions, disk reads, logical reads and others ordered by the metric of choice. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database.
IF (SELECT COUNT(*) FROM SYS.OBJECTS WHERE NAME LIKE 'QueryStatsbyDay') = 1
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.