[RESOLVED] Performance Issue with Asp.net 2.0 and SQL Server 2008

Hi All,

  We have a webapplication written in 2.0 and SQL Server 2008, the application runs pretty fast for 2012 and 2011 data, but it takes long time to get 2013 data, is it because too much of data in database or what else could be the reason. We have not changed
anything in the code.

We are planning to archive the old data so that way it should fetch 2013 data faster, any suggestions are greatly appreciated.

Thank You

 

It sounds like your database could need tuning.  I would use the Database Engine Tuning Advisor to help do this.

http://msdn.microsoft.com/en-us/library/ms166575(v=sql.100).aspx

 

Hi,

As you said, archive the old data is one of the good way to improve the performance. I hope its due to data overload. Since you dont have any problem with Previous year (2012 and 2011) data.

However, its better to analyze where the bottle neck is and fix it.

Think about database tunning such that in which table or procedure is slow. Check indexes etc.

Please try the following URL:

http://www.mssqltips.com/sql-server-tip-category/9/performance-tuning/

Hope this helps!!

Thanks!

Hi,

As you said, archive the old data is one of the good way to improve the performance. I hope its due to data overload. Since you dont have any problem with Previous year (2012 and 2011) data.

However, its better to analyze where the bottle neck is and fix it.

Think about database tunning such that in which table or procedure is slow. Check indexes etc.

Please try the following URL:

http://www.mssqltips.com/sql-server-tip-category/9/performance-tuning/

Hope this helps!!

Thanks!