Performace problem with sql server 2008 r2 and framework 3.5

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  August 6, 2011 at 11:56 am

  #390137

  Dear Experts,

  I have sql server 2008 r2 server with 24 gb RAM and .net 3.5 web applications,I have maximum optimized the DB like table, Query,view , functions ,indexing etc.. but when clients loged into application(web sites our products) from different areas up to 20 users its working fine, after the 21 users getting very slow their pages are timed out or loking.

  please give me your valuable suggestions to overcome this issues, where i solve in Dot net side or sql side ? I am getting confused

  Thank

  saravanan

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 6, 2011 at 12:46 pm

  #1364804

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  August 11, 2011 at 5:48 pm

  #1367667

  Seems like blocking issue, Try this...

  Quick SQL Server Sessions Troubleshooting

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA