SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Sql 2008 r2 "freeze" unexpected
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 05/14/2013 :  16:43:17  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
quote:
Originally posted by apsogos

quote:
Originally posted by Transact Charlie

It's very hard to say for sure. It could be something as mundane as missing indexes, or poorly performing inserts / updates.

did you try running the script I posted?

If you do you should be able to see what processes are blocked by which other processes. Also you should be able to copy out the sql text of those jobs and see what they are trying to do.

Transact Charlie
Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
http://nosqlsolution.blogspot.co.uk/



i tried to run your script but on sql and error appears:

incorrect syntax near '.'.




odd - that script should work fine for 2008 -- just checked it.

Transact Charlie
Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
http://nosqlsolution.blogspot.co.uk/
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000