Its not a trace but a job that inserts into the monitor table. Infact, I created this table and the job just to track the cause for this timeout error....

ok..thnx

I will create the missing index and see if there is any change in the wait types.

Thanks Much Gail.

Thanks for the response Gail.

Does that mean whether or not I add the missing nonclustered index or irrespective of increasing the bandwidth of network switches I would still encounter...

Thanks for the info ninja

Shd i still consider it a best practice to have the checkdb run before my differential backup that runs every night (except friday night). I am running the checkdb even...

Thanks so much for the info everyone...Right now I dont wanna go with the idea of running profiler all day and we are waiting on approvals for the third party...

I got the error as an alert. Not during office hours and I wasnt in front of a computer then. I checked the error almost after an hour and half.

I know what time this error occured. But dont know what was happening on SQL Server then.

I dont see any logs for this in sql server logs or in the eventvwr. The problem is we never know when we will get this error so that I...

Yes..Thanks Gail.

NinjasRGurus,

This was for testing some of the indexes that were newly created on a database which is a backup copy of our production database. I restored a diff. backup from...

Thanks for the info NJ-DBA and thanks Gail for the url.

Sorry for that...Yes, I am having performance issues.

Please find the wait types attached.

Since I see high network contention...shd I go with an approach of adding a new switch? Please help.