I saw a doc for that in sql 2008 but didn't see it was a feature in
2005, I'm far from a SSMS guru however. are you sure it is in 2005? thanks
On 4/3/2012 10:22 PM, [log in to unmask] wrote:
> Shawn,
>
> How about SQL management studio's activity monitor? Resource Waits
> and Recent Expensive Queries ribbons
>
>
>
> Michael Berkowitz
> Project Manager, CGS Application Solutions
> 5530 Corbin Ave Suite 313
> Tarzana, CA 91356-6033
> Direct: 818 635-0816
> Message: 212 261-9610
> Fax: 646 710-1889
> [log in to unmask]
>
>
>
>
>
> From: Shawn Gordon <[log in to unmask]>
> To: [log in to unmask]
> Date: 04/03/2012 10:14 PM
> Subject: [HP3000-L] sql server monitoring tools?
> Sent by: HP-3000 Systems Discussion <[log in to unmask]>
> ------------------------------------------------------------------------
>
>
>
> Hi,
>
> I'm helping a friend of mine that has a 2005 version of SQL Server, the
> products they are using hide the database layer pretty well, but it is
> obvious some functions are locking tables and blocking other processes.
> I was wondering if anyone on here might recommend a tool that would show
> table locks and waiting locks, that kind of thing, so they can narrow
> down what functions are going on. Thanks for any suggestions. Oh, and
> they are a small shop and super cheap :).
>
> --
> Regards,
>
> Shawn Gordon
> President
> theKompany.com
> www.thekompany.com
> www.mindawn.com
> 949-288-3771
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> /
>
>
>
> NOTICE OF COMPANY CONFIDENTIALITY
> This e-mail, and any attachment to it, contains company confidential
> and/or privileged information intended only for the use of the
> individual(s) named on the e-mail. If you are not the intended
> recipient, you are hereby notified that any disclosure, copying or
> distribution of this information or the taking of any action in
> reliance on the contents of this e-mail transmission is strictly
> prohibited. If you have received this e-mail in error, please notify
> the sender by telephone immediately, and/or immediately return it to
> the sender, and delete it from your system.
> Thank you for your cooperation. /
--
Regards,
Shawn Gordon
President
theKompany.com
www.thekompany.com
www.mindawn.com
949-288-3771
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|