Hello,



I have experienced a timeOut problem while executing the following query:
How may i solve the "timeout problem"


RESTORE FILELISTONLY FROM DISK='S:\ProductCatalog.bak'


The error message is Unhandled Exception:
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.

Below we see the errorLog of the Sql Server 2k5

----------------------------------------------------------------------------------------------------------------------------------------------------------------
2008-08-29 12:30:06.57 Server Stack Signature for the dump is
0x0000000000000368
2008-08-29 12:31:14.85 Server Timeout waiting for external dump process
4700.
2008-08-29 12:31:14.90 Server Resource Monitor (0xf9c) Worker
0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 33704
KB. Approx CPU Used: kernel 46 ms, user 62 ms, Interval: 60046.
2008-08-29 12:33:44.92 spid1s A significant part of sql server process
memory has been paged out. This may result in a performance degradation.
Duration: 359 seconds. Working set (KB): 3361292, committed (KB): 12958252,
memory utilization: 25%.
2008-08-29 12:38:16.49 spid1s A significant part of sql server process
memory has been paged out. This may result in a performance degradation.
Duration: 631 seconds. Working set (KB): 4874372, committed (KB): 11755412,
memory utilization: 41%.
2008-08-29 12:44:10.01 Server Resource Monitor (0xf9c) Worker
0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed:
105448 KB. Approx CPU Used: kernel 203 ms, user 62 ms, Interval: 65000.
2008-08-29 12:55:17.34 spid119 Error: 8628, Severity: 17, State: 0.
2008-08-29 12:55:17.34 spid119 A time out occurred while waiting to
optimize the query. Rerun the query.
2008-08-29 12:55:29.04 spid159 Error: 8628, Severity: 17, State: 0.
----------------------------------------------------------------------------------------------------------------------------------------------------------------


Regards,
Ziver MALHASOGLU

On Aug 29, 11:17am, "Ziver MALHASOGLU" <z...@zam.web.tr> wrote:
> I have experienced a timeOut problem while executing the following query:
> How may i solve the "timeout problem"
>
> RESTORE FILELISTONLY FROM DISK='S:\ProductCatalog.bak'

Ziver - Refer to the following article, it may be of some (go to
the section "8628 - A time out occurred while waiting to optimize the
query. Rerun the query."):

http://www.microsoft.com/technet/pro.../tsprfprb.mspx

- Curtis

Have a look at this:

http://blogs.msdn.com/psssql/archive...rver-working-s
et-message.aspx

The most important lesson from this is to identify the cause of the
paging, rather than apply fixes to prevent it.

<a href="http://www.sql-server-pro.com">SQL Server Pro</a>
SQL Server Articles and Tips


*** Sent via Developersdex http://www.developersdex.com ***