en-UShe-IL
You are here:   Blog
Register   |  Login

Blog Archive:

Maximize
* Can be used in order to search for older blogs Entries

Search in blogs


Blog Categories:

Maximize
* Can be used in order to search for blogs Entries by Categories

Blog Tags:

Maximize
* Can be used in order to search for blogs by keywords

TNWikiSummit


Awared MVP

 


Microsoft® Community Contributor 


Microsoft® Community Contributor


 Read first, before you you use the blog! Maximize

Recent Entries

Minimize
נוב9

Written by: ronen ariely
09/11/2010 01:16 RssIcon

ניטור שרת SQL

http://sqlserverplanet.com/troubleshooting/sql-server-slowness/
Troubleshooting SQL Server Slowness

כלים מובנים (פרוצדורות לא רשמיות):

sp_who

http://sqlserverplanet.com/dba/using-sp_who/

sp_who2

http://sqlserverplanet.com/dba/using-sp_who2/

sp_who3

http://sqlserverplanet.com/dmv-queries/a-better-sp_who2-using-dmvs-sp_who3/

-- execute sp_who

EXEC sp_who

-- execute sp_who2

EXEC sp_who2

 

sp_lock

Reports information about SQL locks.

sp_lock2