sp_lock

does the # of results from the above proc, help to determine how vulnerable the database is to resource starvation?

for example, 1000 entries vs 10,000 entries.

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
aelliso3Connect With a Mentor Commented:
No ... it would only tell you how busy it is. You can have a small server with 50 locks and it's getting killed, or a large server with 1000 locks that running fine.
There are many other tools like activity monitor that can help with checking the performance.
P.S ... sp_lock is going away in future versions, so I wouldn't get to comfortable with it ... :-)
0
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Nope, It would say the no. of locks present in your database..
And since sp_lock is going to be deprecated, its recommended to use sys.dm_tran_locks instead.
0
 
anushahannaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.