Solved

sp_lock

Posted on 2010-08-27
3
290 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now