using sp_lock - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

using sp_lock

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-25 : 01:26:29

Dear All,
what is the exact difference between dbcc opentran and sp_lock?

i use dbcc opentran to kill locks. but what is the use of sp_lock? and what is blocking issues? is it related to the locks? while searching in google, i got sp_lock. after executing this on database, i'm getting the result like this. how can i analyze this...please guide me
the result is like this
51 1 1115151018 0 TAB IS GRANT

Arnav
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-25 : 01:31:41

see
http://msdn.microsoft.com/en-us/library/ms187749.aspx
http://blogs.techrepublic.com.com/datacenter/?p=321
http://www.sql-server-performance.com/search_results.aspx?cx=008394378370439510111%3Aoukd4z_wcve&q=lock&sa=Search&cof=FORID%3A9#965

KH
[spoiler]Time is always against us[/spoiler]

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-25 : 02:07:48

KH, sorry for asking a small doubt, a lock is nothing but a dead lock?

Arnav
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-25 : 02:12:48

no. dead lock is a lock. a lock is not necessary a dead lock

KH
[spoiler]Time is always against us[/spoiler]

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-25 : 02:26:52

thank you very much KH, i've read some articles provided by you thank you very much,
how exactly we can monitor the performance? i've read from one article stating as below.
"collect performance data for the CPU, Memory, physical disk, SQL Buffer Manager and all the other counters that are relevant"
if so, where can i get these details?

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-25 : 08:23:29

quote:
Originally posted by sunsanvin

thank you very much KH, i've read some articles provided by you thank you very much,
how exactly we can monitor the performance? i've read from one article stating as below.
"collect performance data for the CPU, Memory, physical disk, SQL Buffer Manager and all the other counters that are relevant"
if so, where can i get these details?

Arnav
Even you learn 1%, Learn it with 100% confidence.

In performance monitor.

Also DBCC opentran -displays open active transaction.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources