July 11, 2005 at 11:33 am
Hello.
I am in the middle of a search for third-party admin software for multiple SQL boxes. My questions for you are simple:
1. What do you use?
2. Do you like it?
3. What did it cost you?
Any help would be most appreciated. I did a demo with Quest Central but that is quite pricey, even though I like it very much, and I am looking for options.
July 11, 2005 at 11:45 am
Admin to do what exactly?
July 11, 2005 at 12:15 pm
Ummmm... everything?
You know, a console that shows you all of your databases and which allows you to see every aspect of there functions like the transaction logs, performance, locks, users online, etc.
Look at Quest, Apex, etc. to see what I am talking about.
July 12, 2005 at 1:33 am
Just a stupid question here: Would QA ans EM not be fine? Maybe together with some notification Service, alarms, mail sending like http://www.sqldev.net/xp/sp_smtp_sendmail.htm
Bye
Gabor
July 12, 2005 at 6:14 am
I have used a software product called Spotlight. It is made by Quest Software. You can find all of their database management products here: http://www.quest.com/database%5Fmanagement/
Spotlight (since I've used it) gives a graphical picture of what is happening on your SQL server. When we had it (I'm not sure if it has changed much, it's been about a year) it would tell you disk I/O, mem usage, cpu usage. You could view at a glance how many sessions there were, then you could drill down into what each spid is doing. Yes, you can find all this information out by manually going and checking, but it was nice to have it all pretty much right there.
Hope that helps...
-Chris
July 12, 2005 at 10:44 am
While you are looking at the QUest site; it would be no harm to look at TOAD.this is a top product for Oracle anyway so I reckon it would be just as good for SQLServer
Regards,
M
July 12, 2005 at 10:54 am
I've used the trial version of Embarcadero's DBArtisan and liked it, especially for multiple platform administration. At the time, we had both Oracle and SQL Server and I could use it to administer both. Since we no longer have Oracle, we settled on Enterprise Manager for SQL Server.
Greg
Greg
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply