Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1763

SQL Server Performance Issue

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

SQL Server Performance Issue amitpatel815@gmail.com - 2014-06-10 11:55 -0700
  Re: SQL Server Performance Issue Erland Sommarskog <esquel@sommarskog.se> - 2014-06-10 23:15 +0200
  Re: SQL Server Performance Issue Mark D Powell <markp28665@gmail.com> - 2014-06-18 13:12 -0700

csiph-web