I am using foglight for SQL Server 5.7. I want to create a report giving trend for Page life expectancy for a SQL server. How can I do that?
I am not sure I am at right community forum but I couldn't find community for 'foglight for sql server'
Take a look at the Memory Summary - SQL in the Database Expansion Pack, which you can download here:
After you've downloaded and installed the expansion pack to your Foglight Management Server, navigate to DB Expansion Pack -> SQL Server -> Dashboards -> Memory Summary - SQL. Choose your instance using the parameter list in the right hand tray and you should see a trend of page life expectancy in addition to other memory related metrics.
If you need any additional assistance, please let me know.
This is terrific! it solves so many annoying reporting questions!