Querying/Reporting from SQL Response

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Querying/Reporting from SQL Response

Postby Scott Herbert » Fri Feb 06, 2009 1:58 am

I'd like to be able to make the performance of our SQL Servers more transparent to my bosses. In particular, I'd like to be able to report on worst queries for blocking, most common deadlock situations, and performance stats over time.

Is there any way to query & report on the data that SQL Response is collecting?
Scott Herbert
 
Posts: 11
Joined: Tue Jan 06, 2009 3:34 am

Postby Linda Hawksworth » Mon Feb 09, 2009 2:22 pm

The ability to query and report on the data that SQL Response collects has been requested by a number of other customers. It is logged in our tracking system and I have added your ticket number to the issue. It will be considered for a future release of SQL Response although I cannot guarantee if/when it may be included.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Status on reports?

Postby johnhise » Tue Apr 20, 2010 3:02 pm

I've just purchased SQL Respones and like what I see so far. The abscence of reports or at least a query function is a glaring ommision. When will this be added?
johnhise
 
Posts: 3
Joined: Tue Apr 20, 2010 2:58 pm

Postby ben.rees » Tue Apr 20, 2010 3:46 pm

Hi John

Thanks for your question. Just to say that we're currently working on the new version of SQL Response (v2.0), and Reporting will definitely form part of that release. The back-end will be SQL Server, allowing the user to generate his/her own reports and run queries as required.

Is this the sort of thing you were looking for?

Regards

Ben Rees
ben.rees
 
Posts: 2
Joined: Wed Jul 29, 2009 12:51 pm

SQL Response Reports

Postby johnhise » Tue Apr 20, 2010 4:11 pm

At a minimum, having a queryable repository would be expected. Having some canned reports to handle common scenarios would be even better. One thing that comes to mind is showing the chain of blocking that occured or a histogram of processes that cause the most blocking.

Glad to see there will be something in this area with version 2...bring it on!
johnhise
 
Posts: 3
Joined: Tue Apr 20, 2010 2:58 pm

Postby ben.rees » Tue Apr 20, 2010 4:21 pm

John

Thanks for the feedback - the plan is to deliver a series of canned reports, primarily as examples and to cover the obvious things users would like to see. This is because our research has found that almost every customer wants different reports to be provided - covering all of these would lead to an overwhelming volume of reports out-of-the-box, most of which would be of little use a individual user.

Regards

Ben
ben.rees
 
Posts: 2
Joined: Wed Jul 29, 2009 12:51 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests