Results 1 to 4 of 4
  1. #1
    Newcomer
    Join Date
    Aug 2011
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default MSSQL log backup Capacity Planning

    Hi,


    I'm trying to produce a report for all SQL servers backup up with TDP, which should include the space reserves available for each DB, in case of a TSM disaster/failure.
    In other words, I need to know for each of the Databases its average use of transaction logs, so that I can calculate how long that DB could run, staying in Full Recovery mode while the TSM backup is unavailable, considering its current disk space and limits.

    Does anyone know a relevant SQL command or tool to see statistics of this sort, in order to understand how much transaction logs does a DB create every day on average?

    Thanks,

  2. #2
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    272
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    Code:
    select START_TIME,bytes from summary where entity='SQLTDP' and schedule_name='YourLogSchedulename'
    This will give you a time range and bytes transferred. The actual log size on the sql server may be larger. If possible, allow for 2-3 days of logdata on the sql server.
    Last edited by Trident; 06-06-2012 at 08:22 AM. Reason: Typo
    -= Trident =-

  3. #3
    Newcomer
    Join Date
    Aug 2011
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Trident View Post
    Code:
    select START_TIME,bytes from summary where entity='SQLTDP' and schedule_name='YourLogSchedulename'
    This will give you a time range and bytes transferred. The actual log size on the sql server may be larger. If possible, allow for 2-3 days of logdata on the sql server.
    Thanks Trident, I will check this query this week and will report back.

  4. #4
    Newcomer
    Join Date
    Aug 2011
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Well, tested the query and it looks like it's exactly what I need, thanks!
    Now I'm just gonna write a script to wrap it in to and I'm ready to go.

Similar Threads

  1. DB2 memory: capacity planning
    By DanGiles in forum Capacity Planning
    Replies: 0
    Last Post: 03-28-2011, 04:31 PM
  2. Replies: 7
    Last Post: 04-11-2008, 10:56 AM
  3. Library capacity planning
    By smith_ja in forum Capacity Planning
    Replies: 3
    Last Post: 02-20-2008, 10:49 PM
  4. Correct message about problems with capacity planning
    By alexmarco in forum Capacity Planning
    Replies: 0
    Last Post: 11-09-2007, 10:26 AM
  5. Enterprise Capacity Planning
    By arivera140 in forum Capacity Planning
    Replies: 3
    Last Post: 03-18-2004, 06:08 PM

Tags for this Thread

Posting Permissions

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