jwcolby
jwcolby at colbyconsulting.com
Fri Feb 1 09:44:08 CST 2008
Paul, I don't think you understand still. I am not saying that a specific query is too long. What I am saying is that I create DOZENS of queries. Some I can just run, others I have to go through this crap to see the data. You can't spend your life examining my execution plans (though I appreciate the offer), and I don't need you to. These are queries run against 50 million records, with complex wheres. There are GOING TO BE queries that take longer than 30 seconds. I just want to find where I tell SQL Server to let a view to take up to X seconds to complete before timing out, so I can up that number to something more reasonable. For tiny databases, 30 seconds is probably quite reasonable. For my large databases 30 seconds is not reasonable. 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 10:23 AM To: 'Discussion concerning MS SQL Server' Subject: Re: [dba-SQLServer] Timeouts executing views 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com