1.2 observations
fatherjack2
Posts: 311
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
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
Comments
Thank you for your comments, I have submitted your comments about filtering and the name of the database.
Glad that it seems faster.
David
Please can you let me know which Alert details are missing the databse name from your point of view.
Thank you
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
Thank you for this feedback
Best Wishes
Emma