Posted on 2010-08-27
Medium Priority
Last Modified: 2012-05-10
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.

Question by:anushahanna
LVL 11

Accepted Solution

aelliso3 earned 1000 total points
ID: 33542599
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 ... :-)
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 33542648
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.

Author Comment

ID: 33543090

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question