Setting Timeout to "0"

[DrSql]

Are there anything to be concerned about setting the timeout to "0". Our developer has a report that has a long running query and he would like to set to "0" to avoid time out. By defauly its 600 ms, and 0 is infinite.
I am looking for Pro and Cons.
Thanks
Varghese

Dr.Sql
Good Luck.

 

[mrdenny]

To which timeout are you referring? There are several.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[DrSql]

Sorry.. I was reffering to SQL Server Query Timeouts.

What other timeouts are there?
Is there any timeouts for reporting services?

Thanks

Dr.Sql
Good Luck.

 

[mrdenny]

There's the timeout is IIS which could be effecting you.

The only query timeout that comes to mind relates to queries against linked servers. Regular queries should run for as long as needed.

Try running the query manually and see if it finishes. If it does, then the SSRS is the problem. At that point it's probably the IIS default timeout.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[gbraden]

Hi,

We are researching that very thing. There seems to be a timeout using client (SMS). We changed the default from 600 to 65535 on the client as well as with the servers but still face a ten minute timeout.

We are now looking at doing online commands (SQLCMD) with the -t option to overcome the timeouts.


Glen Braden

 

[mrdenny]

I know that SSMS doesn't have a query run time timeouts. I've left queries running for days or weeks in SSMS without getting a timeout message.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[SQLWilts]

There is another timeout in SSMS - but its a bit hidden.
Its under tools/options. click "designer" and there is a "transaction timeout". Resetting that may help.....