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

DBA task for large production database Expand / Collapse
Author
Message
Posted Sunday, October 7, 2012 11:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 3:30 AM
Points: 84, Visits: 1,060
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
Posted Monday, October 8, 2012 2:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 5:10 AM
Points: 102, Visits: 1,063
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
Post #1369666
Posted Monday, October 8, 2012 3:45 AM
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
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
Posted Monday, October 8, 2012 4:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 3:30 AM
Points: 84, Visits: 1,060
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
Posted Monday, October 8, 2012 5:17 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 @ 11:31 AM
Points: 40,177, Visits: 36,578
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
Posted Monday, October 8, 2012 12:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 11:24 AM
Points: 7, Visits: 139
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 »

Add to briefcase

Permissions Expand / Collapse