is there command to run and see who is locking or if there is any problems with specific database

Question

is there command to run and see who is locking or if there is any problems with specific database

Krasavita

SSC-Insane

Points: 23138
More actions
March 10, 2009 at 11:25 am

#128947

is there command to run and see who is locking or if there is any problems with specific database

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

The quick place to look is activity monitor if you are in SQL Server 2008 the location have changed, it is the option to the right of the print option in the new query menu.

http://msdn.microsoft.com/en-us/library/ms175518(SQL.90).aspx

Kind regards,
Gift Peddie

SQL_EXPAT SSCrazy Points: 2708 More actions · Answer 2

I still use:

EXEC sp_who2 active

to check for blocking and slow, long running queries.

thanks

SQL_EXPAT