About Me - Who is DR DBA?

Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: sqlsurgeon@outlook.com

Friday, August 17, 2012

SQL Server System Monitor as a Script

Here is a cool script that shows SQL server system information just like in System Monitor.
Copy and paste the script below, it's very small, or download script here: https://docs.google.com/file/d/0B07PMQYOhF2DZDJQQ1BiTmIyaTA/edit?usp=sharing

-- Process Moniitor Script
,DB_NAME(sp.dbid) as DBName
,a.[Text] as [TextData]
,SUBSTRING(A.text, sp.stmt_start / 2,
WHEN sp.stmt_end = -1
 ELSE sp.stmt_end
 END - sp.stmt_start
 )/2) AS [current_cmd]
FROM sys.sysprocesses sp
OUTER APPLY sys.dm_exec_sql_text (sp.sql_handle) as A
spid > 50
blocked DESC
,DB_NAME(sp.dbid) ASC

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.