Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    105

    Unanswered: How often to do certain maintanence tasks.

    Hi,

    I just volunteered to be the database administrator of our new sql server. I am normally the programmer so I have little experience with database administration. There are some basics that I need some assistance with mainly when to perform various maintanence checks. For example, how often do I need to perform some of the dbcc commands that I have read about? How often do I check for data integrity, index fragmentation, rebuilding indexes, or defrag indexes?

    I have to come up with a plan by tomorrow and I don't know if I have anything solid enough since I don't exactly know when to perform some of these tasks.

    Thanks so much for your advice.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you get what you need from SQLTeam?

    Anyway...there is never an absolute answer...

    How big ids the db?

    Assume it's small

    Dump everynight at 3:000AM

    Tranny dumps every hour (I do 15 minutes)

    Integrity everynight at 4:30AM

    Refrag at 5:00 Sunday morning

    ship tranny logs to warm stand by

    By a margarita

    Flirt with closer women (or gender preferecne)

    Hope pager doesn't go off

    Have another 'rita

    repeat last 4 steps
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    http://weblogs.sqlteam.com/tarad

    The only thing I do different is the reindexes. That happens pretty much every night where we can afford it. Weekends where we can't.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Look at you posting Tara's utils...need to let her know....

    Refrags every night?

    How big is the db?

    How much activity?

    Damn...the glass is empty again.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    The databases range from 16 gig to 40 gig. Our archives are quite a bit bigger so we don't do it on those every day to say the least. We run 300-400 t/sec with peaks way over 1000. The read/writes are pretty high also, so we have some indexes that can get pretty messed up if we don't do this.

    We've stopped doing it several times and watched the performance suffer because of it, so it's not just because it "makes me feel good".
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  6. #6
    Join Date
    May 2004
    Posts
    105
    Well, there is no production database on the sql server yet. A new accounting application, deltek Vision, is going to be installed on the sql server. Also, deltek is going to do the whole data migration and database structure.

    I don't even know that much about anything because I am jumping into new territory and I have not been working at the company very long. All I know is that the system is not going to be as big as a hospital setup but more for a managing a small company.

    I know this information is probably not helping. Maybe what would help me is perhaps I need to be told what I need to know or what I should research?

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •