https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213724#M23015 <P>Thanks ryanconnor. I have a sql query which gives me list of long running queries. Below is the query.</P> <P>Can I represent this output in line graph, if yes, how can I do it? Please help me</P> <PRE><CODE>SELECT TOP 100 qs.total_elapsed_time / qs.execution_count / 1000000.0 AS average_seconds, qs.total_elapsed_time / 1000000.0 AS total_seconds, qs.execution_count, SUBSTRING (qt.text,qs.statement_start_offset/2, (CASE WHEN qs.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) AS individual_query, o.name AS object_name, DB_NAME(qt.dbid) AS database_name FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt LEFT OUTER JOIN sys.objects o ON qt.objectid = o.object_id where qt.dbid = DB_ID() ORDER BY average_seconds DESC; </CODE></PRE> Thu, 23 Jun 2016 09:24:46 GMT pprakash2 2016-06-23T09:24:46Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213722#M23013 <P>Hi, </P> <P>May I please know if there is any documentation to create dashboards, graphs etc, for desired SQL queries? I've connected the app to an MSSQL database. I want to create a dashboard for long running queries. Any suggestions?</P> Mon, 20 Jun 2016 11:37:47 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213722#M23013 pprakash2 2016-06-20T11:37:47Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213723#M23014 <P>You might benefit from using the following add-on:</P> <P><A href="https://splunkbase.splunk.com/app/2648/#/overview">https://splunkbase.splunk.com/app/2648/#/overview</A></P> <P>This should give you plenty of information regarding performance of your MSSQL database. </P> Mon, 20 Jun 2016 15:20:44 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213723#M23014 ryanoconnor 2016-06-20T15:20:44Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213724#M23015 <P>Thanks ryanconnor. I have a sql query which gives me list of long running queries. Below is the query.</P> <P>Can I represent this output in line graph, if yes, how can I do it? Please help me</P> <PRE><CODE>SELECT TOP 100 qs.total_elapsed_time / qs.execution_count / 1000000.0 AS average_seconds, qs.total_elapsed_time / 1000000.0 AS total_seconds, qs.execution_count, SUBSTRING (qt.text,qs.statement_start_offset/2, (CASE WHEN qs.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) AS individual_query, o.name AS object_name, DB_NAME(qt.dbid) AS database_name FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt LEFT OUTER JOIN sys.objects o ON qt.objectid = o.object_id where qt.dbid = DB_ID() ORDER BY average_seconds DESC; </CODE></PRE> Thu, 23 Jun 2016 09:24:46 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213724#M23015 pprakash2 2016-06-23T09:24:46Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213725#M23016 <P>It might help if you can post a csv of the output of the above query for those of us who don't have an active SQL Server DB handy. </P> Tue, 28 Jun 2016 13:46:24 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-Is-there-documentation-on-how-to-create-a/m-p/213725#M23016 tmuth_splunk 2016-06-28T13:46:24Z