Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Today @ 3:06 AM
Points: 96, Visits: 1,164
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: Wednesday, June 22, 2016 2:24 PM
Points: 19,803, Visits: 18,086
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, June 21, 2016 5:23 AM
Points: 1,101, Visits: 5,315
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:43 AM
Points: 1,144, Visits: 3,420
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: Wednesday, June 22, 2016 2:24 PM
Points: 19,803, Visits: 18,086
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 @ 3:11 PM
Points: 44,780, Visits: 42,685
Wait analysis
Performance benchmarking



Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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 @ 10:44 AM
Points: 6,124, Visits: 13,607
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: Wednesday, June 22, 2016 2:24 PM
Points: 19,803, Visits: 18,086
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: Today @ 3:06 AM
Points: 96, Visits: 1,164
Thanks to all
Post #1408767
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse