Red Gate forums :: View topic - Querying/Reporting from SQL Response
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Querying/Reporting from SQL Response

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Scott Herbert



Joined: 06 Jan 2009
Posts: 11

PostPosted: Fri Feb 06, 2009 1:58 am    Post subject: Querying/Reporting from SQL Response Reply with quote

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?
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Feb 09, 2009 2:22 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
johnhise



Joined: 20 Apr 2010
Posts: 3

PostPosted: Tue Apr 20, 2010 3:02 pm    Post subject: Status on reports? Reply with quote

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?
Back to top
View user's profile Send private message
ben.rees



Joined: 29 Jul 2009
Posts: 2

PostPosted: Tue Apr 20, 2010 3:46 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
johnhise



Joined: 20 Apr 2010
Posts: 3

PostPosted: Tue Apr 20, 2010 4:11 pm    Post subject: SQL Response Reports Reply with quote

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!
Back to top
View user's profile Send private message
ben.rees



Joined: 29 Jul 2009
Posts: 2

PostPosted: Tue Apr 20, 2010 4:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group