Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Is there any way to flush out a stuck process in sql server Expand / Collapse
Author
Message
Posted Thursday, September 3, 2009 7:22 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 62, Visits: 234
1) Checked logs it didn’t say anything
2) Already checked backupset as backup didn’t complete no info in backupset
3) I also thought about trace because this is the best option but no idea about time frame and I cann’t schedule trace for a month or so...
Post #782144
Posted Friday, September 4, 2009 2:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:55 AM
Points: 2,366, Visits: 1,845
Well in that case .....are there many applications that connect to the databases. Any chance of checking their source code ? I know this is

"Keep Trying"
Post #782768
Posted Friday, September 4, 2009 3:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
have you checked the windows security log, for the time that it last ran, to try and isolate an account that might have been used to kick off that process. also ask your wintel team about server level tracing/auditing that they perhaps could put on temporary for a month or so.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #782778
Posted Friday, September 4, 2009 3:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 62, Visits: 234
I also thought about this option but unfortunately logs for that date washed off.
Post #782781
Posted Friday, September 4, 2009 3:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
DKG (9/4/2009)
I also thought about this option but unfortunately logs for that date washed off.



if there is a server backup taken daily, ask your infrastructure/wintel team for the eventlogs for that date, and see if they can restore it for you.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #782785
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse