From: markp28665@gmail.com   
      
   On Tuesday, June 10, 2014 2:55:51 PM UTC-4, Amit Patel wrote:   
   > Hello Experts,   
   >   
   >   
   >   
   > One of my website is hosted on IIS and the database is on MS-SQL Server 2008   
   R2 and approximately 100-120 users access this portal for data entry.   
   >   
   >   
   >   
   > But my Site is responding extremely slow and sometimes users get stuck when   
   they submit forms.   
   >   
   >   
   >   
   > And when i am checking the server status, all the hardware res   
   urces(RAM,CPU) are free I mean there is no too much cpu load or memory issue   
   on the server and hardware configuration of my server is mentioned below.   
   >   
   >   
   >   
   > Processor:- intel i7 8-core   
   >   
   > RAM:- 8GB   
   >   
   >   
   >   
   > And on the same MS-SQL server,  database of one of my other site is located   
   and approx 300 users are doing the similar task on  that other site but we are   
   not facing any slow speed with that other site and performance of that other   
   site is too good.   
   >   
   >   
   >   
   > And both sites are hosted on the same IIS.   
   >   
   >   
   >   
   > So, here i am confused and not sure why my site  is not working smoothly   
   while other site with more users is working absolutely fine and i have enough   
   hardware resources on the server.   
   >   
   >   
   >   
   > Can anyone please help me or suggest me how can i resolve or troubleshoot   
   this issue.   
   >   
   >   
   >   
   > Please let me know if you have any question.   
   >   
   >   
   >   
   > Thanks.   
   >   
   > Amit   
      
   Amit, is your slowly performing application querying the same tables in the   
   same database as the good performing application?  If not, have you checked   
   your indexing?   
      
   HTH -- Mark D Powell --   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)