| Author |
Topic |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-04-08 : 17:28:38
|
| Today we had a meeting with Microsoft Guys over here regarding SQL 2008.They have cool features like compressing backup upto 50% and Geographically dispersed Clustering with (SAN Mirrored).Well that sounds good . Our company is looking for 3rd-party tools?So,[Experts/friends] Which 3rd-party tools should we go for regarding backups,monitoring and maintenance?I have looked for Idera,Iway,SQLlitespeed,Redgate? So couldn't decide which to choose? This is for SQL 2005.Show me the way.... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-08 : 17:39:11
|
| Personally I don't use any.For monitoring I write my own.Backups and maintenance I think are too important to trust to anything compplicated (and that includes maintenance plans).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-08 : 17:43:18
|
| Thats right nr.Thats the reason we are not having any 3rd-party-tool bcoz of trust factors. But nowdays We(DBA) are tired of writing scripts . Using 3rd-party-tools ,we want to save some spaces as well as Monitoring our server (like NetIQ monitoring). |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-08 : 22:36:02
|
| Microsoft's MOM is same as NetIQ monitoring. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-08 : 22:53:07
|
| rmaio,What does it(MOM) do? Is it good tool? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-08 : 23:30:26
|
quote:
Originally posted by rmiao
Microsoft's MOM is same as NetIQ monitoring.
It hasn't been the same in a few versions. NetIQ is far superior to the MOM product and unfortunately we use MOM since it's so much cheaper than NetIQ.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-08 : 23:31:45
|
quote:
Originally posted by sodeep
rmaio,What does it(MOM) do? Is it good tool?
It's Microsoft's monitoring product. It monitors a ton of different Microsoft products plus other vendors have written management packs for MOM for their products such as Veritas. We use MOM for Exchange, SQL Server, Clustering, and Veritas monitoring. I'm sure we use it for more things than that too, but those are the ones that I can remember.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-08 : 23:33:51
|
| We also use SQL Litespeed, Red Gate's SQL Toolbelt, and I believe some of the Idera products. I highly recommend SQL Litespeed if you have large databases to backup. It saves you 75-90% in backup time and space. People says disks are cheap but they aren't so cheap when it comes to certain SANs.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-09 : 14:36:29
|
| SQL Litespeed and Red Gate's SQL Compare here. I second Tara on Litespeed, Litespeed is great. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-09 : 14:38:33
|
| We also use i3 from Symantec, great for historical performance of your servers, tons of stuff you can monitor and drill into. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-12 : 06:57:41
|
| You might want to check out.http://www.quest.com/www.apexsql.com (They gave out free licenses to sqlteam active members in december) |
|
|
|
Ola Hallengren
Starting Member
33 Posts |
Posted - 2008-04-13 : 12:19:19
|
| I thought about the the future for LiteSpeed now when SQL Server 2008 comes with built in backup compression. I know that LiteSpeed has some other nice features, but the compression is the major argument for most companies as i see it. Any views on this?Ola Hallengrenhttp://ola.hallengren.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-13 : 15:40:47
|
| Agree unless those tools adding more recovery options. |
|
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2008-04-17 : 13:00:43
|
| SQL Sentry is a job scheduling/monitoring tool which is pretty useful. It displays all of your jobs in a calendar-style interface and allows drag-and-drop rescheduling. It also provides some good visibility into your general job performance, with historical timelines kept and a display of what was running, when the job stopped, and it gives you the SQL reason why in a tooltip. It is a little pricey for what it does, but in an environment with many jobs running on/across multiple servers, it is helpful. |
|
|
|
|
Which third-party tools you trust?