Looking For third party Tools.....

Question

Looking For third party Tools.....

Chowdary's

SSCrazy

Points: 2978
More actions
September 24, 2014 at 4:32 am

#311764

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...

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

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

Grant Fritchey SSC Guru Points: 398878 More actions · Answer 1

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

Chowdary's SSCrazy Points: 2978 More actions · Answer 2

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...

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 3

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.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004302 More actions · Answer 5

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)

Grant Fritchey SSC Guru Points: 398878 More actions · Answer 6

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

Grant Fritchey SSC Guru Points: 398878 More actions · Answer 7

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

george sibbald SSC Guru Points: 104210 More actions · Answer 8

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.

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

Jeff Moden SSC Guru Points: 1004302 More actions · Answer 9

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)

Jeff Moden SSC Guru Points: 1004302 More actions · Answer 10

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)

Chowdary's SSCrazy Points: 2978 More actions · Answer 11

Thank you all for giving valuable Replies...

Regards
Chowdary...

Jerry Inman SSC Rookie Points: 27 More actions · Answer 12

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.

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 13

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.

Jerry Inman SSC Rookie Points: 27 More actions · Answer 14

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.