December 21, 2010 at 3:15 am
Hello,
I need a query where i can see in the output the following information.
The spid xxx that is locking spid yyy for x min (for example 5 min.), tell me too the origin of the lock (machine/user), and that print kill command for use it if people says that we can kill processes that are blocking transactions.
I need to know too if there's any query that i can use to tell me the time the rollback action will take after i kill the process that its being blocking.
I dont know if im asking you to much.
I wish you a merry christmas.
Thanks and regards,
JMSM 😉
December 21, 2010 at 12:31 pm
This one too is really unclear what you are looking for. The one thing I can say for certain is there is no query that will tell how long a rollback is going to take.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 22, 2010 at 3:59 am
Ok.
So can you send me a query where i can see in the output the following information.
The spid xxx that is locking spid yyy for x min (for example 5 min.), tell me too the origin of the lock (machine/user). Inn the sequence of the output of the previous query, i need the kill command with the spid that is blocking transactions.
Thanks and regards,
JMSM 😉
December 22, 2010 at 8:29 am
JMSM (12/22/2010)
Ok.So can you send me a query where i can see in the output the following information.
The spid xxx that is locking spid yyy for x min (for example 5 min.), tell me too the origin of the lock (machine/user). Inn the sequence of the output of the previous query, i need the kill command with the spid that is blocking transactions.
Thanks and regards,
JMSM 😉
A given process is not locking another process, it is locking a table that the other process is trying to query.
You can check out the syntax to kill a process at http://msdn.microsoft.com/en-us/library/ms173730.aspx.
I am guessing you are having some serious locking issues? I would recommend figuring out what is causing the locking issues and resolve those instead of just killing sessions.
Be VERY careful if you start executing the kill command. Make sure you read the link I sent completely and spend some digging around other articles to understand what you are doing. You can seriously damage your system if you not careful.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 23, 2010 at 6:09 am
Thanks and regards,
JMSM 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply