August 4, 2004 at 2:56 pm
|
I am working with a query involving around 7 tables. Each table has average records of around 16 millions. While designing query through Enterprise manager, when I try to run the query in Enterprise Manager, it throws an error "Connection Timed Out". It happens with Analysis Service too when I try to process a dimension. Same query when I copied and pasted to Query analyzer, it works. I have set the Connection Time Out property for Server to "Infinite". Any idea ?
Thanks Nilesh Leuva |
August 4, 2004 at 11:46 pm
Don't know about Analysis Services but you only have 30 seconds, and only ever 30 seconds in EM for your query to return data.
If you have an affection for the graphical designer within EM you can try removing sorts or reducing the columns returned but you eventually will have to go to Query Anayser to build your full query. (Or some SQL ODBC/OLE DB app connection)
Does anyone know if this has been changed - I would think not since I believe this time out is in place in order to conserve server resources.
DB
The systems fine with no users loggged in. Can we keep it that way ?br>
August 5, 2004 at 1:04 am
In EM :
Tools / Options / advanced :
you can set : - Login timeout
- Query timeout
- packet size
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 5, 2004 at 4:01 pm
And you still will have only 30 seconds.
The systems fine with no users loggged in. Can we keep it that way ?br>
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply