June 4, 2008 at 9:49 am
my sql server froze last night and I didn't have profiler running. I would like to know if there's a way I can query the events that happened last night. In other words, I'd like to know what process exactly is the message below talking about?
This instance of SQL Server has been using a process id of 3476 since 5/28/2008 1:09:26 PM (local) 5/28/2008 5:09:26 PM (UTC).
June 4, 2008 at 11:50 am
Try reading the default trace file(running in background only in 2005). I think its located under default log file directory). See if it has captured anything that you are looking for.
Manu
June 4, 2008 at 11:52 am
If you do not have profiler, trace or some other utilities like foglight,.. etc. in place than there are not many options in sql server to look at past incidents. You can check sql errorlogs or event logs but many times that will not give you any clue of problem.
With process id you can try Who_2 or sysprocess, last option is to kill that process / better reboot the server and have some diagnostic in place for future error pattern.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
June 4, 2008 at 12:09 pm
that's a great option but unfortunately this sql server is 2000.
June 4, 2008 at 12:30 pm
An SQL log parser will at least tell you what transactions, if any, were the last ones run. If that will help, RedGate's log parser for SQL 2000 is currently free.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply