I'm a newbie to SQL Server and have asked to investigate monitoring
tools. We're mostly interested in the basics...

- is it up
- has it been recently backed up
- are there any really glaring problems (locks held for a long time,
excessive CPU or DISK activity, etc.)

What tools do most folks use for monitoring SQL Server?

For reference we are mostly an Oracle shop with some MySQL as well. The
tools we use to monitor those platforms are Oracle Enterprise Manager
and MySQL Enterprise Monitor. Is there something similar for SQL Server?

We have 2000 and 2005 currently. Expecting some 2008 to be installed
over the next year.

TIA

Chuck wrote:
Does nobody have a suggestion for monitoring tools?

On Mar 3, 2:21*pm, Chuck <chuckh1958_nos... (AT) gmail (DOT) com> wrote:
MS has monitoring tools. Operations Manager I think. there is also
stuff from Redgate and Idera. search for #sql or #sqlserver on twitter
and there are employees of those companies that will answer.

where i work it's all home grown stuff.

if it's up we use Openview. Nagios is the new product. it's free i
think. also check out HP Insight Manager or the Dell equivalent if you
use Dell.
for backups we use netbackup which sends out alerts and i created a
process where i import some tables from msdb into a central location
and wrote the code and SSRS reports to report database backup
statuses.
for locks we have custom SQL code that runs every few minutes and
sends out alerts.
last month i set up perfmon. i used a central server to run the
counters and import from all our sql servers. and now i'm in the
process of writing code to mine the data and present it in SSRS
reports.

On Mar 3, 2:21*pm, Chuck <chuckh1958_nos... (AT) gmail (DOT) com> wrote:
also check out Manage Engine. we're also installing it