Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Edward Pochinski profile

   Items 1 to 15 of 15   

Open Transaction Alarm to Log to the Event log

If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.  Read more...
By Edward Pochinski 2016/04/22 | Source: | Category: transactions
Rating: |  Discuss |   Briefcase | 510 reads

Transaction Log VLF Alarm

This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.  Read more...
By Edward Pochinski 2016/03/17 | Source: | Category: transaction log
Rating: |  Discuss |   Briefcase | 730 reads

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.  Read more...
By Edward Pochinski 2016/02/23 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 906 reads

SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.  Read more...
By Edward Pochinski 2016/01/12 | Source: | Category: dmv
Rating: (not yet rated) |  Discuss |   Briefcase | 300 reads
   Items 1 to 15 of 15