We have dynatrace 6.1 implemented in our production environment pulling data which is great. One thing I was requested to offer however analytics around the size of the content databases for sharepoint. These are stored out on sql however so It does not appear something we can easily get to with Dynatrace. Does anyone have experience with getting to this data? Or getting to similar data in a sql database?
I know there is a sql query monitor plugin but to use this our DBA would need to great a standalone table just for us to look at which he is not wanting to do. Is there a way to track data returned by a stored procedure at all?
Answer by Michael F. ·
Jared,
SQL Server provides many performance counters including Data File(s) Size (KB) under the SQL Server Database Instance where you can pick the desired database.mdf. If that works then you could can use the Dynatrace Windows Performance Monitor and add the desired performance counter, and point it at your SQL Database. No agent required, it will remotely collect this data.
Thanks,
Mike
JANUARY 15, 3:00 PM GMT / 10:00 AM ET