January 25, 2007 at 11:21 am
I have an environment of SQL Server 2K5 and 2000 servers. The environment is mostly data warehouse than transactional. There are some applications working continiously to provid reports. The servers must be up and running.
I have to provide high availability, monitor performance, and minimize down time. Is there any "really good" tool for a DBA for this environment? I would like to hear your experience with the tool you are using. Any practical suggestion is highly appreciated.
Thanks,
January 25, 2007 at 1:31 pm
If you are looking for monitoring tools...
QUEST and IDERA has good tools ...
http://www.sql-server-performance.com/spotlights.asp
MohammedU
Microsoft SQL Server MVP
January 26, 2007 at 8:04 am
Not necessarily just a DBA tool, but we use HP OpenView to monitor our servers, restart services that stall, page us of ports not responding ...
I find it very handy and typically will try to have it automatically restart services if the ports (1433 ...) don't respond if the service cannot restart it pages me. But it is expensive.
What about Microsoft's MOM?
B
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply