Comments
Sort by recent activity
I tried this issue again and was able to reproduce. It doesn't happen every time. Used version 1.4.16.1316 I could reproduce with 8 databases and 3 threads. Shows 7 results. I could reproduce with 3 databases and serial execution. Shows 2 results. It is inconsistent. Sometimes it will show all the results and sometimes it's missing one or more results.
Steps to reproduce: 1. Load 3 databases. Set options to use serial execution. 2. Run the query below and immediately switch to the "Results" tab to watch the results come in. 3. When footer showed "Script executed successfully on 3 databases", the results only had 2 rows. 4. Switching between Messages and Results tabs redraws the results and then all 3 database results are visible. Example Query used to give enough delay to click on Results tab before all results are shown: WAITFOR DELAY '00:00:05' --Big enough number to allow you to click script and switch to Results SELECT 'test' I tried this on two computers and was able to reproduce the issue on both. [image]
/ comments
I tried this issue again and was able to reproduce. It doesn't happen every time.Used version 1.4.16.1316I could reproduce with 8 databases and 3 threads. Shows 7 results.I could reproduce with 3...
Thanks Eddie. I submitted the information by email as requested.
For anyone else following this issue, to reproduce this problem, you must select the results grid as soon as possible and before all of the databases are processed. If you wait until after all of the databases are processed, then you will be selecting the results grid and forcing a draw of the results. The problem is that when watching the results stream in, the program doesn’t always draw all of the results into the grid. But a forced redraw by for example clicking Messages and then Results does fix the issue.
I currently have about 1000 databases and am using 25 threads. This takes 9 seconds. That is enough time to switch to results grid under normal usage before all of the results are available.
But I just reproduced this problem with 36 databases and 25 threads, by adding a WAITFOR DELAY to the query to give me time to switch to results and watch them stream in.
I tried reproducing this issue with 5 databases and 2 threads, but wasn’t able to with a couple of attempts.
Here is the query I used for the 36 database 25 thread test that did reproduce the issue:
WAITFOR DELAY '00:00:03'
SELECT 'test' / comments
Thanks Eddie. I submitted the information by email as requested.
For anyone else following this issue, to reproduce this problem, you must select the results grid as soon as possible and before al...
1.3.4.886 still has this problem.
I almost missed gathering some data the other day before I remember to use my workaround to refresh the results tab. Simple steps to reproduce:
1. Load 4 databases. Set options to use parallel execution against 2 databases at a time.
2. Run the query below and immediately switch to the "Results" tab to watch the results come in.
3. When footer showed "Script executed successfully on 4 databases", the results only had 3 rows.
4. Switching between Messages and Results tabs redraws the results and then all 4 database results are visible. Various combinations
Using 2 threads, I reproduced this with even number of databases (4, 6, and 8 databases). Each time is was missing 1 row of results.
Using 2 threads, I could NOT reproduce this with odd number of databases (3,5, and 7 databases).
Using 3 threads, with 7 databases, it would drop 2 rows of results until refreshed.
Using 3 threads, with 8 databases, it would drop 1 row of results until refreshed. QUERY:
WAITFOR DELAY '00:00:05'
SELECT 'test' / comments
1.3.4.886 still has this problem.
I almost missed gathering some data the other day before I remember to use my workaround to refresh the results tab.Simple steps to reproduce:
1. Load 4 databases....
I confirmed this is quick to list many databases after upgrading to 1.2.4. Thanks again. / comments
I confirmed this is quick to list many databases after upgrading to 1.2.4. Thanks again.
Thank you! / comments
Thank you!
An alternative to get status in bulk. Though unsure of which versions of SQL this works with...
SELECT name, state_desc FROM sys.databases / comments
An alternative to get status in bulk. Though unsure of which versions of SQL this works with...
SELECT name, state_desc FROM sys.databases
I'll work around my pinning issue until I upgrade.
I did just add a new post about a slowness when adding new databases to the distribution list.
I think this slowness is new in v1.2
It appears to be related to checking if each database is online or not.
Post title: 1.2.3 Configure Distribution List is Slow to load / comments
I'll work around my pinning issue until I upgrade.
I did just add a new post about a slowness when adding new databases to the distribution list.
I think this slowness is new in v1.2
It appears to ...
Thanks for the update.
I'm using Windows 8.1 -- still need to upgrade to Windows 10.
Any my favorite new feature is the script progress indicator. Thanks for whoever added that! / comments
Thanks for the update.
I'm using Windows 8.1 -- still need to upgrade to Windows 10.
Any my favorite new feature is the script progress indicator. Thanks for whoever added that!
lol -- if you click that link, you'll see I added that uservoice suggestion on April 6, 2011. Three years ago. / comments
lol -- if you click that link, you'll see I added that uservoice suggestion on April 6, 2011. Three years ago.