Solved

sql server: View lock information using Activity Monitor

Posted on 2011-02-12
1
792 Views
Last Modified: 2012-05-11
Hi experts, can give me a hand on lab or something to do this:
View lock information using Activity Monitor
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 17

Accepted Solution

by:
dbaSQL earned 250 total points
ID: 34880482
Have you seen this?
http://www.mssqltips.com/tip.asp?tip=1917

I think you need to take a look at the 'Resource Waits' section.
http://www.networkworld.com/community/node/32224


§    Resource Waits -  This section displays resource waits  vertically that are based on the following wait categories CPU, SQLCLR, Network I/O Latch, Lock, Logging, Memory, Buffer I/O, Buffer Latch and Compilation.  From a horizontal perspective, the Wait Time, Recent Wait Time, Average Waiter Counter and Cumulative Wait Time metrics are published for each Wait Category.  Similar to the Processes section, data can be filtered based on items within a column.

0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

707 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

15 Experts available now in Live!

Get 1:1 Help Now