Thanks Cathal... really appreciate your help... if you ever around Costa Rica let me know. I'm attaching the sql trace when it normally works. Maybe you can spot something wrong

http://www.4shared.com/file/cddwcHGf/trace.html?

As mentioned before it gets stuck on the line to addnewtab of the core. We use DNN 5.5.0 and it happens when the site gets slow (we pressume for traffic)

thanks

Once again thanks for your help. Another piece of information is that I had to setup pooling=false @ webconfig since the site was throwing. The line being mentioned below is:

newTab.TabID = tabController.AddTab(newTab);

I have also collected trace info and a dump of iis which I will post. Thanks.. I'm desperate to fix this.


=================================

Error System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScalar(String ProcedureName, Object[] commandParameters)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String ProcedureName, Object[] commandParameters)
   at DotNetNuke.Entities.Content.Data.DataService.AddContentItem(ContentItem contentItem, Int32 createdByUserId)
   at DotNetNuke.Entities.Content.ContentController.AddContentItem(ContentItem contentItem)
   at DotNetNuke.Entities.Tabs.TabController.AddTabInternal(TabInfo objTab, Boolean includeAllTabsModules)
   at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean includeAllTabsModules)
   at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab)
   at Pernix.Modules.News.EditNews.CreateNewPage(Int32 ParentID, String pageTitle, String categoryName) in c:\HostingSpaces\adn\DesktopModules\News\EditNews.ascx.cs:line 738
   at Pernix.Modules.News.EditNews.SaveNewsInformation() in c:\HostingSpaces\adn\DesktopModules\News\EditNews.ascx.cs:line 511

Big delays in a sql action are commonly associated with a sql index being corrupted.  It may be worth looking and forcing a manual reindex or your tabs and modules tables.

Westa