April 14, 2004 at 8:26 am
Hello all. I think we cannot turn timeout in EM. Am I wrong? A user was runnig a complex view to get all the records and it keeps on timing out (one of the tables in the view has more than 5 million records)
I said that that particular view was created to run some reports and needs a parameter to get the data. He wanted to see all the records from EM.
I run the view from QA and it came back with all the records in 1 min 7 secs. Which is OK for the complexity of the view. So, I came back to basis, can we set the time when running a view from EM (30 seconds by default) to be unlimited like in QA?
I have all my seetings at the server level to allow unlimited time to run queries from remote etc. Thank you
April 14, 2004 at 8:46 am
EM is at best an administration tool, nothing to retrieve information on your data. You should tell your user to use QA, or some other front-end.
To answer your question, AFAIK you can only set a timeout option for remote servers.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 14, 2004 at 8:51 am
Thanks Frank. That's what I thought.
April 14, 2004 at 2:50 pm
Might want to look into tuning the view too. 5 million records really isn't all that much.
"Keep Your Stick On the Ice" ..Red Green
April 14, 2004 at 3:07 pm
Thanks Jeff. The query is fine. I did run the plan to check it out and there is no problem there. I think we nail this thing down with some suggestions from .NET programmers. Because the process was running from the application the time out was happening at the application (30 secs default) and the delete for those records were taking longer than that they suggested to add a couple of lines to the .NET code to turn the time to any time the developers wanted. They are testing it now and it seems to work. Thank you anyway.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply