Paul Nielsen
pauln at sqlserverbible.com
Fri Feb 1 09:23:27 CST 2008
The difference has nothing to do with the view, but how you're connecting. ADO has a built in timeout of 30 seconds, SSMS does not. And if you show me the query execution plan, I'll bet we can make it run in seconds not hours. -Paul -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, February 01, 2008 8:03 AM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Timeouts executing views Paul, It isn't about how long the query takes. No I can't show you the execution plan because this happens for ANY query that takes longer than 30 seconds. I understand that you want long running views to time out, but why does a view time out and the query based on that SQL not time out? It is irritating to have to go get the sql, create a query, dump the SQL in there, then run it in order to get results. I just want to run the View and get the results. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul Nielsen Sent: Friday, February 01, 2008 9:53 AM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Timeouts executing views Even of it takes hours? Can you show us the SQL and the Query Execution Plan? -Paul -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, February 01, 2008 5:55 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Timeouts executing views When I try to execute a view, if results aren't returned within some short period of time (about 30 seconds) I get a timeout message. OTOH, if I copy the Sql, open a new query, paste it in and run, it will complete even if it takes hours. Does anyone know where to go to change the timeout period for views run directly? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com __________ NOD32 2843 (20080201) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com __________ NOD32 2844 (20080201) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com