X-Received: by 10.43.65.4 with SMTP id xk4mr908106icb.12.1402426551805; Tue, 10 Jun 2014 11:55:51 -0700 (PDT) X-Received: by 10.50.103.10 with SMTP id fs10mr516000igb.12.1402426551637; Tue, 10 Jun 2014 11:55:51 -0700 (PDT) Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!peer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!a13no777836igq.0!news-out.google.com!qf4ni19597igc.0!nntp.google.com!a13no777829igq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Tue, 10 Jun 2014 11:55:51 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=14.141.89.18; posting-account=hVZyLQoAAABcmXpvH9FBiat1ihymB2CG NNTP-Posting-Host: 14.141.89.18 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: SQL Server Performance Issue From: amitpatel815@gmail.com Injection-Date: Tue, 10 Jun 2014 18:55:51 +0000 Content-Type: text/plain; charset=ISO-8859-1 X-Received-Bytes: 2126 X-Received-Body-CRC: 3999264547 Xref: csiph.com comp.databases.ms-sqlserver:1763 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