• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
2 Solutions
 
aelliso3Commented:
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 RSQL 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now