home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,070 of 19,505   
   amitpatel815@gmail.com to All   
   SQL Server Performance Issue   
   10 Jun 14 11:55:51   
   
   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 resources(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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca