• Replies 7 replies
  • Subscribers 340 subscribers
  • Views 26 views
  • Users 0 members are here
Related

DB growth

Sharon Grayton
$organization

Hey there, IT folks,

Over the last 9 months, our database size has nearly quadrupled.

Would there be any way that just the creation of performances--with no transactions on them--could contribute unduly to use of space?

What would be the likely areas that would contribute most to such growth?

Thank you,

sharon,

Cincinnati Symphony

Parents
  • $organization

    My DBA says we’re backing up transaction logs every 15 minutes.

    Any other suggestions?

     

    From: Mohiuddin Faruqe [mailto:bounce-mohiuddinfaruqe8297@tessituranetwork.com]
    Sent: Thursday, October 21, 2010 9:47 AM
    To: Sharon Grayton
    Subject: RE: [Tessitura Technical Forum] DB growth

     

    Hi Sharon, is it just your data or log file or both? Is there any chance that your database is in Full recovery mode and you are not taking Transaction Log backup regularly? In that case your log file size will grow enormously. Just for adding new performances it sounds too much.

     

    Mo

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sharon Grayton
    Sent: Wednesday, October 20, 2010 7:17 PM
    To: Mohiuddin Faruqe
    Subject: [Tessitura Technical Forum] DB growth

     

    Hey there, IT folks,

    Over the last 9 months, our database size has nearly quadrupled.

    Would there be any way that just the creation of performances--with no transactions on them--could contribute unduly to use of space?

    What would be the likely areas that would contribute most to such growth?

    Thank you,

    sharon,

    Cincinnati Symphony




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    My DBA says we’re backing up transaction logs every 15 minutes.

    Any other suggestions?

     

    From: Mohiuddin Faruqe [mailto:bounce-mohiuddinfaruqe8297@tessituranetwork.com]
    Sent: Thursday, October 21, 2010 9:47 AM
    To: Sharon Grayton
    Subject: RE: [Tessitura Technical Forum] DB growth

     

    Hi Sharon, is it just your data or log file or both? Is there any chance that your database is in Full recovery mode and you are not taking Transaction Log backup regularly? In that case your log file size will grow enormously. Just for adding new performances it sounds too much.

     

    Mo

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sharon Grayton
    Sent: Wednesday, October 20, 2010 7:17 PM
    To: Mohiuddin Faruqe
    Subject: [Tessitura Technical Forum] DB growth

     

    Hey there, IT folks,

    Over the last 9 months, our database size has nearly quadrupled.

    Would there be any way that just the creation of performances--with no transactions on them--could contribute unduly to use of space?

    What would be the likely areas that would contribute most to such growth?

    Thank you,

    sharon,

    Cincinnati Symphony




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data