On Wed, Mar 6, 2013 at 7:36 AM, crazy <crazysan...@gmail.com> wrote: > **Dear All, > > We are optimizing a web application (B2B booking engine) developed in > ASP.Net2.0 and Database MSSQL 2005. > > As a first step we upgraded the application to ASP.NET 4.0 and Database > SQL2010. > > But in certain places like making booking or looking for Prize break > down the loading of page taking too much time in production environment . > This issue was not in first two weeks of deployment in production.This > is working perfect in test environment. > > How I can find the actual reason of the issue like DB performance issue > or Web application issue ? Any tool is available to monitor performance > in production server? > > DB server and Web server are in same LAN. does it any settings issue in > IIS ? Or any improper Garbage collection issue? memory leakage? > > Please share your ideas to sort of this issue. > > > ------------------------- >
First guess is DC has poor indexes. Learning how to index properly is very important for issues like slow load time, etc. Are your indexes only built around joins and leave out any searching of data? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell -- -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net --- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To unsubscribe from this group and stop receiving emails from it, send an email to dotnetdevelopment+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
