Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Monitor

Status
Not open for further replies.
Bell1991

Bell1991

Programmer
Aug 20, 2003
386
0
0
US
I have a job that runs every 30 minutes.. Lately, while this job is running i get mant timeouts to the database. Is there anyway to find out what is causing the timeouts (if in fact it is the job)
 
Sort by date Sort by votes
Could you send more details?? What is the job doing??
Did you check the job history??

Cyno
 
Upvote 0 Downvote
The job just inserts records into a table.. It usually takes about 1:15 to run.

If the queries that were timing out were hitting the table that i am inserting into - that could be the problem.. But the queries that are failing are not calling that table..

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
SQL Server monitoring tools - suggestions
Replies
0
Views
27
TheBugSlayer
TheBugSlayer
biglebowski
  • Locked
  • Question
Use 1 DB to monitor another
Replies
1
Views
15
biglebowski
biglebowski
jsteph
  • Locked
  • Question
Seeing many open transactions in activity monitor during idle hours?
Replies
5
Views
33
mrdenny
mrdenny
jsteph
  • Locked
  • Question
Can I run the SMS 2005 Activity monitor with SMS 2008?
Replies
4
Views
22
djj55
djj55
jsteph
  • Locked
  • Question
Where is Activity monitor?
Replies
1
Views
10
djj55
djj55

Part and Inventory Search

Sponsor

Back
Top