CODEWITHSUNDEEP
sqltimeout
Abdul Wasie
Abdul Wasie

Reputation: 45

SQL Server query timeout when restarting it is ok

SQL Server is running fine application is also running fine but after every 15-20 days it is giving query time out exception and then if I restarted my Server machine then every thing is okay. Can any body give any clue so I can solve this problem?

Upvotes: 1

Views: 669

Answers (1)

Steve Wellens
Steve Wellens

Reputation: 20640

You have a tiny leak somewhere.

  • Maybe memory is being used and not released.
  • Maybe a temporary file is growing slowly.
  • Maybe threads are being spawned and not released.

Look in the event logs for anything that has a continuous growth.

Upvotes: 1

Related Questions