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