Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I was wondering if there is a free tool to monitor state of SQL Server 2000. I would prefer a web tool.

I would like to see if some database is accessible, or are there any problems on server, etc. Also I would like not to put to much extra load on SQL Server.

If anybody knows tool like this, please help

Thanks

share|improve this question
    
this might be useful: zabbix.com/screenshots.php –  bummi Dec 21 '12 at 11:34

1 Answer 1

up vote 1 down vote accepted

The Zabbix tool, posted in the comment, is not really working, because the server doesn't run on Windows, only the agent. See info in their requirements page. This means you'd need to install the tool on a Linux machine and only an agent on the Windows machine. Great if you have a heterogeneous environment, not really helpful in a full Win environment.

The same situation is for Nagios, another interesting open source monitoring tool. They say there is a package only for Windows, but the doc page it redirects to doesn't work now.

Of complete free monitoring tools useful for SQL 2000 I'm not really aware, but you can use successfully a pair of:

  • Perfmon (find more info here)

  • Server trace (trace specific queries, not just everything) -> actually files that can be open in SQL Profiler

  • SQL Alerts (info in MSDN article or here, in this SimpleTalk article)

PS: found that a great monitoring tool is also working on SQL 2000. So you'd better try to test Confio Ignite free. It's fantastic for the price :-).

PS2: there is also a small free monitoring tool from Idera -> SQL Check, but I don't know if it works on SQL 2000.

share|improve this answer
    
I would prefer a lightweight tool. From all tools you listed, what tool least put load on server? –  mikipero Dec 24 '12 at 8:07
    
None of them would put any big load on a system, except traces done with Profiler on the server itself. That's why I suggested server traces. The others shouldn't weigh too much. Anyway, you can use Perfmon, Ignite or SQL Check from another machine, so the database server itself remains mostly untouched. You might wanna find out that there's no free lunch out there, each tool has its cost (in learning, load, configuration, space..etc). That cost you'll find out after you'll do your own assessments. –  Marian Dec 24 '12 at 9:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.