Viewing 15 posts - 301 through 315 (of 360 total)
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....
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 10, 2011 at 12:28 pm
ok..thnx
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 9, 2011 at 5:57 pm
I will create the missing index and see if there is any change in the wait types.
Thanks Much Gail.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 9, 2011 at 9:59 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 9, 2011 at 9:44 am
Thanks for the info ninja
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 8, 2011 at 10:46 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 8, 2011 at 9:56 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 3, 2011 at 9:37 am
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.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 2, 2011 at 10:04 pm
I know what time this error occured. But dont know what was happening on SQL Server then.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 2, 2011 at 10:02 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 2, 2011 at 9:46 pm
Yes..Thanks Gail.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 2, 2011 at 9:53 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 2, 2011 at 8:39 am
Thanks for the info NJ-DBA and thanks Gail for the url.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 1, 2011 at 1:11 pm
Sorry for that...Yes, I am having performance issues.
Please find the wait types attached.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 1, 2011 at 8:45 am
Since I see high network contention...shd I go with an approach of adding a new switch? Please help.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 31, 2011 at 7:40 am
Viewing 15 posts - 301 through 315 (of 360 total)