1.2 observations

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

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

1.2 observations

Postby fatherjack » Mon Mar 23, 2009 5:53 pm

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
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Postby david connell » Wed Mar 25, 2009 12:27 pm

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
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am

Names of databases involved in alert details

Postby Emma A » Tue Apr 21, 2009 12:46 pm

Hi Jonathan,

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

Thank you
Emma
Emma A
 
Posts: 40
Joined: Mon Mar 30, 2009 2:53 pm

Postby fatherjack » Thu Apr 23, 2009 3:28 pm

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
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Names of databases involved in alert details

Postby Emma A » Thu Jul 30, 2009 12:04 pm

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
Emma A
 
Posts: 40
Joined: Mon Mar 30, 2009 2:53 pm

DB name... still missing?

Postby xyvyx » Tue Jul 13, 2010 12:06 am

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...
xyvyx
 
Posts: 2
Joined: Fri Feb 26, 2010 9:42 pm
Location: Dallas Tx


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests