Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Proactive sql dba activities for Production Databases Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 10:24 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 78, Visits: 1,015
Hi,

Please provide some of Proactive sql dba activities for Production Databases.
Post #1408143
Posted Wednesday, January 16, 2013 10:40 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 21,343, Visits: 15,018
Index Maintenance
Backups
Integrity Checks
Deadlock monitoring




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1408148
Posted Wednesday, January 16, 2013 11:58 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
Monitor blocking
Monitor free space in the data, log and disks. Increase the DB, Log file size when required to avoid auto-growth
Alerts for job, log shipping, replication, etc.
Monitor log file size/growth
Alerts for high memory, cpu utilization.
Post #1408168
Posted Thursday, January 17, 2013 3:27 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 834, Visits: 2,695
SQLRNNR (1/16/2013)
Index Maintenance
Backups
Integrity Checks
Deadlock monitoring

Don't forget to restore those backups.




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1408280
Posted Thursday, January 17, 2013 9:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 21,343, Visits: 15,018
Sean Pearce (1/17/2013)
SQLRNNR (1/16/2013)
Index Maintenance
Backups
Integrity Checks
Deadlock monitoring

Don't forget to restore those backups.


Very true

As the saying goes, you don't have a backup until you have test restored it.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1408498
Posted Thursday, January 17, 2013 9:44 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 42,492, Visits: 35,559
Wait analysis
Performance benchmarking



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1408510
Posted Thursday, January 17, 2013 10:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:48 PM
Points: 5,976, Visits: 12,887
monitor erorlogs
monitor sqlagent jobs
ensure your backups are actually happening (dont just monitor for failure)

test your DR procedures from time to time


---------------------------------------------------------------------

Post #1408522
Posted Thursday, January 17, 2013 10:09 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 21,343, Visits: 15,018
Establish and Enforce standards



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1408526
Posted Friday, January 18, 2013 2:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 78, Visits: 1,015
Thanks to all
Post #1408767
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse