Red Gate forums :: View topic - 1.2 observations
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

1.2 observations

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



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Mon Mar 23, 2009 5:53 pm    Post subject: 1.2 observations Reply with quote

Hi,

some observations after upgrade to 1.2

- sortable details grids are not sorting by data type ie sorting a date column in basetime details for a job duration unusual alert sorts by string value rather than date value:
02/02/2009 07:00
02/03/2009 07:00
09/02/2009 07:00
09/03/2009 07:00
12/01/2009 07:00
16/02/2009 07:00
16/03/2009 07:00
09/01/2009 07:00
etc

- showing alert details specified by a custom filter from startup still displays blank screen until filter is re-selected from drop down list

- databasemail90 processes still show as long running query

- SQL Backup jobs still show as long running query (SQBCoreService.exe process)

- the name of database involved in alert details is still missing

on the up side - it seems to be way faster.

Jonathan
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
david connell



Joined: 21 Nov 2005
Posts: 207

PostPosted: Wed Mar 25, 2009 12:27 pm    Post subject: Reply with quote

Hi Jonathan,
Thank you for your comments, I have submitted your comments about filtering and the name of the database.
Glad that it seems faster.

David
Back to top
View user's profile Send private message
Emma A



Joined: 30 Mar 2009
Posts: 40

PostPosted: Tue Apr 21, 2009 12:46 pm    Post subject: Names of databases involved in alert details Reply with quote

Hi Jonathan,

Please can you let me know which Alert details are missing the databse name from your point of view.

Thank you
Emma
Back to top
View user's profile Send private message
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Thu Apr 23, 2009 3:28 pm    Post subject: Reply with quote

Hi Emma,

Apologies for the delayed response - I have been on leave.

Just to pick the first at hand in SQL Response currently:
The alert type is Long running query.
I have no value for the Detail column.

the SQL process details has one row in it. this gives the process name as ".Net SQLClient Data Provider"
the Start Time is shown as 23/04/09 15:03:28 (it is currently 15:26)
there is no SQL query fragment displayed

From the details I know a slow query was executed but I have no way of knowing what the query was or what database it was running against ...

Would a screen shot help?

regards

Jonathan
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Emma A



Joined: 30 Mar 2009
Posts: 40

PostPosted: Thu Jul 30, 2009 12:04 pm    Post subject: Names of databases involved in alert details Reply with quote

Apologies for the extreme delay in responding. We are currently working on the next release and the information you provided has been encapsulated in an enhancement request. The reference for this feature request is SSR-706.

Thank you for this feedback
Best Wishes
Emma
Back to top
View user's profile Send private message
xyvyx



Joined: 26 Feb 2010
Posts: 2
Location: Dallas Tx

PostPosted: Tue Jul 13, 2010 12:06 am    Post subject: DB name... still missing? Reply with quote

So I just configured 1.3.0.58 for the first time... I enabled tracing & received my first Blocked SQL process alert. I was pretty surprised the trace data doesn't contain DB name nor DB ID. Pretty basic info you'd want on a server w/ over a hundred databases, no? esp. when you've got many DBs that are structurally identical...
Back to top
View user's profile Send private message MSN Messenger
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