DBA task for large production database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » DBA task for large production database

DBA task for large production database

Rate Topic

Display Mode

Topic Options

Author

Message

jamessdba

Posted Sunday, October 07, 2012 11:28 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 11:36 PM
Points: 72, Visits: 797

Hi,

My production DB size is now 50Gb its increasing (sqlserver 2008 R2 Enterprice edition)

Let me know the DBA task to be done for large database like Integrity check ,fragementation free & performance point .

Thanks in advance

Post #1369619

KumarSQLDBA

Posted Monday, October 08, 2012 2:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 29, 2013 4:03 AM
Points: 81, Visits: 824

Check the following factors are considered or not?

1.Database size and growth should be mentioned initially.

2.Check the unused index and drop the unused index.

Then set up your maintenance plan for backup,dbcc reindex,etc

Regards,
Kumar
http://www.sqldbatask.blogspot.com/

Post #1369666

Suresh B.

Posted Monday, October 08, 2012 3:45 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:40 AM
Points: 1,075, Visits: 5,115

50GB is not large. You should be able to handle it just like any other smaller DB.

Integrity check is a must for all DBs whether small or large.

Post #1369692

jamessdba

Posted Monday, October 08, 2012 4:34 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 11:36 PM
Points: 72, Visits: 797

Thanks for the reply

I added Integrity check before backup task in the Maintenance plan

But Job/MP is failing as per the scheduled

Post #1369705

GilaMonster

Posted Monday, October 08, 2012 5:17 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 5:49 PM
Points: 37,671, Visits: 29,925

With what error? Just saying it's failing isn't much use.

Maintenance:
Backups, full maybe diff, probably log depending on RPO and RTO requirements
Index maintenance
Integrity checks
Possible additional statistics maintenance
Test restores to ensure your backups are useful.
Alerts configured to tell you before things break

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 #1369721

CYates

Posted Monday, October 08, 2012 12:48 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 5:48 AM
Points: 7, Visits: 97

First, before I do anything on a new server I stand up a pre-determined utility database for DBA related activities. Maintenance jobs that I run but not limiting to are:

Clearing out aged backups
Creating backups for new databases that get dropped onto my server ( in my case all DB's are mission critical )
Cycle SQL Server Error Logs
Index Defrag
Smart Re-Indexing
Alerting on Extended Blocking

Again, these are my main chunks for maintenance but definitely not limiting what I have listed. You could have more, 50GB is not really that big. Should be able to get a good grasp on it.

Thanks,
Chris

Post #1370001

« Prev Topic | Next Topic »

Permissions