SQLTeam.com | Weblogs | Forums

Timeout in ssms sql server 2014

I get the following message when running a complex query in SSMS
sql execution error
executed sql statement: SELECT list of table names...
error source: .Net SqlClient Data Provider
error message Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I have increased the timeout period 600 secs on both the connection and query duration.

I am seeking some general assessments first.

The best option is to simplify the 'complex' query...the timeout is probably caused when SQL Server is trying to generate the execution plan and it finally gives up.

Actually, duplicate rows were on the input tables from SSIS. Once they were fixed the query ran w/o incident.