ASP.NET Application time out error

Question

Please help me,I have a time & attendance application in ASP.net using SQL Server 2005 as database,The application was wornking very fine for thelast 5 years,suddenly last week,It is getting data for the first query,but for the second query it is taking long time and finally showing time out error

Recently my system Admin updated windows, dotnet & Sqlserver hotfixes

Community · Accepted Answer · 2017-05-23 11:52:43Z

2

Rebuild your indexes and statistics.

See here.

[Which version of SQL Server BTW?]

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Jun 23, 2013 at 6:27

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2513019 Over a year ago

Thanks Mitch,I am using SQL server 2005,It creating a table using bulkcopy methode then that table is binding to a datalist after that i have some colour formating in the datalist say red colour for absent,coral & pink colour for weekenddays,then another colour scheme for leave days.Every thing working fine for the first two operation but if i am checking the next one,the application will take long time and time out error will throw,I check the database,the bulk copy is working fine,but iam getting the error in the binding of datalist..Thanks again

user2513019 Over a year ago

Thansk Mitch I rebuild all my index & stats,Now the application working fine...It was a great help from your side thanks again...!

Collectives™ on Stack Overflow

ASP.NET Application time out error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related