Sending stats to Graphite from within SQL Server

I am playing with Graphite and StatsD with all the different possibilities to record and transmit metrics lately.

My recent addition to the “graphite-client” project is a TSQL CLR procedure for sending stats to Graphite directly from within SQL server: https://github.com/peschuster/graphite-client/tree/master/source/Graphite.TSql.

It is just a simple one-liner in SQL:

exec sp_graphitesend '192.168.0.1', 2003, 'stats.events.myserver.test', 1

Installation of the stored procedure is “described” here: https://github.com/peschuster/graphite-client/blob/master/source/Graphite.TSql/sp_graphitesend.sql

Only restriction is that it requires a “TRUSTWORTHY” database, clr code execution enabled and import of a custom DLL (Graphite.TSql.dll).

A typical scenario for sending stats directly from within SQL Server is e.g. logging of backup or maintenance tasks for being able to put it in correlation with other metrics like cache-hit-ratio or memory usage.

3 Comments

  1. Srumith

    I have integrated dropwizard metrics with graphite reporter.Actually my metrics contain sql queries and urls. SQL queries, as they contain commas and dots, Graphite is unable to display the metrics, same with urls, problem is with { and } characters. Please help me if there is some fix or I am doing something wrong.

  2. Nathan

    I am not sure where to download Graphite.TSql.dll. It is not available in Github. Please help.

Comments are closed, but trackbacks and pingbacks are open.