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

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

Re: SQL Server Performance Issue

Show all headers | View raw

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 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

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 --

Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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