Looking For third party Tools.....

  • Hi Experts i need some suggestion from your side..

    We are planning to take third party tools for

    1>Performance Tool

    2>Backup & Restore Tool....

    Any Suggestion that would be very appreciate...

    Regards
    Chowdary...

  • Personally, the best ones are from Red Gate Software[/url]. They have tools for both monitoring and backups. But then, I am prejudiced since I work for them.

    You should just do some online research. There are simply tons and tons of reviews of all the third party tools out there. Most of the third party tools will let you download a copy and install it for a trial period. That's one of the best ways, evaluate them for your own needs.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thank you for response Grant,

    I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So am searching for within my budget.

    once again thank you Grant....:-)

    Regards
    Chowdary...

  • I've used Idera SQLsafe quite extensively and to be honest, I wouldn't recommend it purely because it's quite memory hungry.

    I've seen the program use up to 3GB of memory on a server. I really don't think that a backup tool should be using that amount of memory.

    As Grant says there are loads of tools online, have a google and see.

  • For performance monitoring, I used SQL Sentry and really like it. It does everything I want and more. I would recommend it to anyone.

    As for the backup and restore tools, I prefer to use native backups. I find that the "backup database" and "restore database" work just fine. I've heard of third-party tools, but haven't used any of them, so I have no recommendation.

  • Chowdary's (9/24/2014)


    Thank you for response Grant,

    I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So am searching for within my budget.

    In that case, I strongly recommend that you just skip the idea of purchasing a backup tool. The native backups are very effective and... they're free.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Chowdary's (9/24/2014)


    Thank you for response Grant,

    I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So am searching for within my budget.

    once again thank you Grant....:-)

    Not a problem. Completely understood.

    Fair warning though, Red Gate is reasonably priced compared to most of the other options out there.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Jeff Moden (9/24/2014)


    Chowdary's (9/24/2014)


    Thank you for response Grant,

    I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So am searching for within my budget.

    In that case, I strongly recommend that you just skip the idea of purchasing a backup tool. The native backups are very effective and... they're free.

    Yeah, pretty much.

    The third party backup tools, all of them, are just adding functionality on top of the existing functionality, which is adequate for most systems. We get more compression than native compression, for example, but native compression works and doesn't cost anything.

    Why, specifically, are you looking for a backup tool? You don't need to say "why" for a monitoring tool. That's just common sense.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • what version of SQL are you on? From 2008R2 compression is available with the native backups on all versions, you should only need 3rd party tools (sorry grant) if you want encryption or copy off to tape. Even then TDE is an option.

    I would avoid the enterprise level backup tools for SQL, stick to targeted tools designed for SQL backups.

    ---------------------------------------------------------------------

  • Grant Fritchey (9/24/2014)


    Jeff Moden (9/24/2014)


    Chowdary's (9/24/2014)


    Thank you for response Grant,

    I installed Red Gate Soft and using but its very costly tools ,as we are in small infrastructure my management will not go for that.So am searching for within my budget.

    In that case, I strongly recommend that you just skip the idea of purchasing a backup tool. The native backups are very effective and... they're free.

    Yeah, pretty much.

    The third party backup tools, all of them, are just adding functionality on top of the existing functionality, which is adequate for most systems. We get more compression than native compression, for example, but native compression works and doesn't cost anything.

    Why, specifically, are you looking for a backup tool? You don't need to say "why" for a monitoring tool. That's just common sense.

    To be sure, though, I've worked with the RedGate backup tools before. They do make life real easy for backups and management of backup files. A lot of people make the mistake of deleting all of the backup files before they start a single backup natively so that they "have room" for the backups. They don't understand that why they shouldn't do that and delete a backup only after they have a good one on disk and ready for tape.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • DBA From The Cold (9/24/2014)


    I've used Idera SQLsafe quite extensively and to be honest, I wouldn't recommend it purely because it's quite memory hungry.

    I've seen the program use up to 3GB of memory on a server. I really don't think that a backup tool should be using that amount of memory.

    As Grant says there are loads of tools online, have a google and see.

    Oddly enough and serendipitously, I've been looking for unsolicited recommendations and comments on Idera SQLSafe. Thanks for taking the time to post that comment.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thank you all for giving valuable Replies...

    Regards
    Chowdary...

  • I used RedGate at a previous job (Kennedy Space Center), but chose Idera products for my current place of employment (Healthcare company). Price and features were the primary factors in the decision to purchase, but after 7 years, I'm very pleased with their products and support. We are currently running SQLsafe on about 40 instances, ranging from 30GB to 800GB. It is highly dependable and faster than native, with more compression--even with encryption enabled.

  • Jeff Moden (9/24/2014)


    DBA From The Cold (9/24/2014)


    I've used Idera SQLsafe quite extensively and to be honest, I wouldn't recommend it purely because it's quite memory hungry.

    I've seen the program use up to 3GB of memory on a server. I really don't think that a backup tool should be using that amount of memory.

    As Grant says there are loads of tools online, have a google and see.

    Oddly enough and serendipitously, I've been looking for unsolicited recommendations and comments on Idera SQLSafe. Thanks for taking the time to post that comment.

    No worries, it has got features I like. I'm using it to log ship databases from SQL 2005 to SQL 2012 (for the compression) and it hasn't missed a beat. Nice GUI with latency stats but I've just checked and it's back up to consuming ~2GB of RAM.

  • Are you referring to the SQLsafe backup agent, running on the client? It does seem to leak a little, over time, but mine usually stay between 150 and 500 MB. A quick restart of the SQLsafe agent service, if the instance doesn't get regular reboots, will usually clear that up.

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply