Solved

sp_lock

Posted on 2010-08-27
3
295 Views
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.

thanks
0
Comment
Question by:anushahanna
3 Comments
 
LVL 11

Accepted Solution

by:
aelliso3 earned 250 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 ... :-)
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 250 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.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33543090
Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

856 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