Hello, Does your application get a connection to the database at all?
You can use NHProf http://nhprof.com/ to examine what is happening when the timeout occurs. Keith. 2009/4/21 Jan Limpens <[email protected]>: > hello, > > on the production server (where else), my otherwise snappy web app suddenly > has timeouts and crawls like a snail. > > my config is: > <settings> > <item key="show_sql">true</item> > <item key="max_fetch_depth">1</item> > <item > key="dialect">NHibernate.Dialect.MsSql2005Dialect</item> > <item > key="connection.provider">NHibernate.Connection.DriverConnectionProvider</item> > <item > key="connection.driver_class">NHibernate.Driver.SqlClientDriver</item> > <item key="connection.connection_string">Data > Source=.\SQLEXPRESS;Initial Catalog=dbname;Integrated Security=True</item> > <item key="connection.isolation">ReadCommitted</item> > <item key="default_schema">dbname.dbo</item> > <item key="query.substitutions">true 1, false 0, yes > 'Y', no 'N'</item> > <item key="adonet.batch_size">10</item> > <item > key="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, > NHibernate.ByteCode.Castle</item> > </settings> > > on the same server, different database, with the almost identical > connectionstring, I get good results, too. but here... > > System.Data.SqlClient.SqlException: Timeout expired. The timeout period > elapsed prior to completion of the operation or the server is not > responding. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, > Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > exception, Boolean breakConnection) > at > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject > stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet > bulkCopyHandler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, > RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, > DbAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior > behavior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior > behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean > autoDiscoverTypes, Boolean callable, RowSelection selection, > ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, > QueryParameters queryParameters, Boolean returnProxies) > at > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor > session, QueryParameters queryParameters, Boolean returnProxies) > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, > QueryParameters queryParameters) > > anyone could give me hints where to look? > you know, it works on my machine ;) (duck). > > thanks! > > -- > Jan > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
