How can we help you today? How can we help you today?

1.2.3 Configure Distribution List is Slow to load

1. Adding new databases to the distribution list seems slower than it used to be.

Running a SQL trace it runs:
select name, cmptlevel from master..sysdatabases
Then for each of my ~800 databases it checks the db status.
SELECT DATABASEPROPERTYEX('master', 'Status')
SELECT DATABASEPROPERTYEX('db1', 'Status')
...~4 or 5 minutes later...
SELECT DATABASEPROPERTYEX('db800', 'Status')

2. Future feature request to speed up adding new databases:
My basic usage
Expand the server.
Wait 5 minutes
Select all databases starting with prefix_DBName. //Most are grayed out on the left. The new one or two databases I need to add are not grayed out.
Push Add>> and OK
Future request might be for it to auto detect databases starting with a certain prefix and prompt if I want to add them to my distribution list.
We've detect 3 new databases starting with db_. Do you want to add them to your distribution list?
csuire
0

Comments

7 comments

Sort by
  • csuire
    An alternative to get status in bulk. Though unsure of which versions of SQL this works with...
    SELECT name, state_desc FROM sys.databases
    csuire
    0
  • richardjm
    So for the upcoming release (hopefully tomorrow), I've changed the query so it just does a single select to get the databases which should be considerably quicker.
    select name, cmptlevel, DATABASEPROPERTYEX(name, 'Status') from master..sysdatabases

    For the other ability to add databases based on prefix (or exclude added databases from the list) that will have to wait for another time.
    richardjm
    0
  • csuire
    Thank you!
    csuire
    0
  • richardjm
    Happy to help, you've caught us at a particularly good time :)
    richardjm
    0
  • richardjm
    An update that should be quicker is now available via check for updates (1.2.4)
    richardjm
    0
  • csuire
    I confirmed this is quick to list many databases after upgrading to 1.2.4. Thanks again.
    csuire
    0
  • richardjm
    No worries, it's really nice to see there are people still getting good use out of the tool.
    richardjm
    0

Add comment

Please sign in to leave a comment.