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: Friday, November 7, 2014 1:57 AM
Points: 89, Visits: 1,075
Hi,

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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:31 PM
Points: 17,964, Visits: 15,967
Index Maintenance
Backups
Integrity Checks
Deadlock monitoring




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
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 @ 9:49 AM
Points: 972, Visits: 3,026
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:31 PM
Points: 17,964, Visits: 15,967
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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 @ 1:43 PM
Points: 40,411, Visits: 36,861
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: Today @ 8:11 AM
Points: 5,886, Visits: 13,043
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:31 PM
Points: 17,964, Visits: 15,967
Establish and Enforce standards



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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: Friday, November 7, 2014 1:57 AM
Points: 89, Visits: 1,075
Thanks to all
Post #1408767
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse