search

DataDog / dd-agent

Datadog Agent Version 5
https://docs.datadoghq.com/
Other
1.3k stars 812 forks source link

SQLServer Customization #3187

Open husmanjr opened 7 years ago

husmanjr commented 7 years ago

We would like to monitor considerably more information then can be provided in the dm_os_performance_counters view. we have some custom queries that we use to date to monitor top sql, job status, statistics and some other factors inside sql server. We would like to add these custom queries to the SQL Server yaml or py files similar to the functionality that can be obtained from MySQL. Is this possible? How can this be accomplished?

Thank you,

I have tried to add a function to the sqlserver.py but this is not erring but is not providing the information requested to the datadog page for monitoring.

zsimpso commented 7 years ago

I'd also like to know how to/if it is possible to monitor results from custom queries similar to how is currently possible with mysql.

@husmanjr Have you found any resources yet?

husmanjr commented 7 years ago

I have not, we are still trying to utilize this system but require more customization in what we can query. We would like to get job status and other things like that out of this as we do with the MySQL monitors.

Thank you,

J.R. Husmann Database Engineer

CONNECTRIA HOSTING 314-587-7048 (Office) 314-330-6701 (Mobile) 314-622-5099 (Fax) jhusmann@connectria.commailto:jhusmann@connectria.com

NO JERKS ALLOWED® www.connectria.comhttp://www.connectria.com/index.php Connectria Bloghttp://www.connectria.com/blog Recommend us on Linkedinhttp://www.linkedin.com/company/connectria/products?trk=top_nav_products Follow us on Twitterhttps://twitter.com/Connectria [NJA Signature Block]

From: Zachary Simpson [mailto:notifications@github.com] Sent: Wednesday, April 19, 2017 8:14 AM To: DataDog/dd-agent dd-agent@noreply.github.com Cc: JR Husmann jhusmann@connectria.com; Mention mention@noreply.github.com Subject: Re: [DataDog/dd-agent] SQLServer Customization (#3187)

I'd also like to know how to/if it is possible to monitor results from custom queries similar to how is currently possible with mysqlhttps://help.datadoghq.com/hc/en-us/articles/115000133723-How-to-collect-metrics-from-custom-MySQL-queries.

@husmanjrhttps://github.com/husmanjr Have you found any resources yet?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/DataDog/dd-agent/issues/3187#issuecomment-295265369, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AYjznwKIH5irN9ohL9NdmT4FeDF1T0UXks5rxgiJgaJpZM4L_nRH.