Grid View or Table View for multiple text info fields | Archive

rob_risetto · 2016-02-27T01:05:52Z

Hi, I have a need to return from my SQL Servers some text based information that I want to display in a table or grid view. Its not counter/statistic/event alert based but the information may include counter/statistic information in addition to a number of text information fields. Perhaps the table/grid view and associated data source can be limited to 10 to 20 records, and provide a refresh internal options of 1 hour, 1 day or 1 week. The data is NOT accumulated by instead refreshed (overwritten) for each interval execution. Use cases for my requirements would be once day or week where I would like to present a grid view for each of the following datasets 1. Top 5 Missing indexing information = includes Database Name, table Name, Missing index definition, User Seek count, User Scan count. This information is captured via SQL Server query on internal management views. 2. Top 5 database queries = includes Database Name, query text limited to say 512 bytes, CPU, Reads, Memory, Duration - again capture by a query 3. Top 10 File IO databases = includes Database Name, Logical data file name, physical file name, bunch of stats fields - again captured by a query So essentially this is not alert data but provides some tuning and health information in the form of a number of text fields and stats fields presented in a table/grid view that are refreshed (overwritten) in each capture execution (collection interval). thanks Rob

MoreDiscussions

Grid View or Table View for multiple text info fields | Archive | LogicMonitor Community