My database application is failing and giving timeout error. Attached file has to snapshot of error messages and Database status health. Due to timeout error i also tried to increase 'Query Wait' time of SQL Server 2000 to 6000 sec. But it is still giving me the same error. Presently database and this appliaction is running on the same machine.
Additional Information:
Presently database has 55 Millions records into it.
following the table structures:
Table Structures
Master Table- DateID
ID Bigint PK
DateTime Smalldatetime
Detail Table- Ch_Details
Ch_No int
ID bigint FK
Value numeric(5,2)"
Awaiting for your help."
Regards
Rakesh
