Red Gate forums :: View topic - Multi script limit?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Multi script limit?

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
efdavila



Joined: 10 Jun 2009
Posts: 5

PostPosted: Wed Jun 10, 2009 11:51 pm    Post subject: Multi script limit? Reply with quote

Hi,
I'm querying ~150 servers. I'm getting results for 96 of those servers and then multiscript seems to hang. No errors, just keeps running with no further results. Any idea?

I'm running a simple @@version for the query.

TIA
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Thu Jun 11, 2009 10:46 am    Post subject: Reply with quote

Hi,

Is the application locking up (as in the ui stops working?) or does it just not return any more results?

If you leave it running for a few min do the SQL Queries time out?

Cheers,
--
Daniel
Back to top
View user's profile Send private message
efdavila



Joined: 10 Jun 2009
Posts: 5

PostPosted: Thu Jun 11, 2009 3:56 pm    Post subject: Reply with quote

Hi,
The application sort of locks up. What I mean by that is that I see the spinning "wheel" to the left hand side of the Script execution in progress... status whirling but nothing seems to be happening. As well if I click on the Cancel button it greys out but doesn't stop the spinning wheel thing.
To actually cancel the script, or so I think, I have to go to File|Exit and shutdown the app.

Results of the query itself are the same this morning. I don't get any error messages at all and the script stops at about server ~95 of 150.
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Thu Jun 11, 2009 4:01 pm    Post subject: Reply with quote

Can you run the query against the last 55 servers only?
--
Daniel
Back to top
View user's profile Send private message
efdavila



Joined: 10 Jun 2009
Posts: 5

PostPosted: Thu Jun 11, 2009 4:17 pm    Post subject: Reply with quote

Sure.

Is there a way to export the list of servers so I can pull a subset out? Along the same lines if I maintain a list of servers with the sa password is there a method to import (the list is always getting updated)?

TIA
Back to top
View user's profile Send private message
efdavila



Joined: 10 Jun 2009
Posts: 5

PostPosted: Thu Jun 11, 2009 6:56 pm    Post subject: Reply with quote

I couldn't find a way to easily pull out a subset so instead went through the server list and executed an @@version for each server individually. I found that one of the servers was offline (shutdown) and this is where Multi Script hung. Once I unchecked that particular server the script ran against all servers without problem.

This is a pretty good tool but it would benefit greatly if it had the ability to import a list of servers with their associated password. Also the list of servers you add isn't in alpha order so comparing against an existing list is quite a pain.

Thanks...
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Fri Jun 12, 2009 9:14 am    Post subject: Reply with quote

Hi,

Lots of Multi Script users have asked for an import/export/organization utility for database lists, so I have written a small utility that should tide you over until some more list management finds its' way into the product.

http://labs.red-gate.com/index.php/Multi_Script_list_manager

I hope this is useful for you!
Back to top
View user's profile Send private message
efdavila



Joined: 10 Jun 2009
Posts: 5

PostPosted: Tue Jun 16, 2009 9:56 pm    Post subject: Reply with quote

Thank you. I'll give it a try.
Back to top
View user's profile Send private message
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