Thanks for your comment ... This slow may be due to poor indexing .. I have gone thorogh the executaion plans of most of Sps.
Do we reduce the Number seek or Number of scan. , do you have any usefult links about DB indexing ? rgds Vipin On Wed, Mar 6, 2013 at 7:32 PM, Stephen Russell <[email protected]>wrote: > > > On Wed, Mar 6, 2013 at 7:36 AM, crazy <[email protected]> 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 [email protected] > To unsubscribe from this group, send email to > [email protected] > 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- "People who never make mistakes, never do anything." dEv -- -- 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
