June 29, 2011 at 5:14 am
Hi,
Can any one suggestion me, which is best tool for monitoring SQL 2000, 2005 and 2008,
It should be like web based tool can access through URL format. and dashboard type of monitoring.
Thanks
ananda
June 29, 2011 at 5:48 am
I don't know about sql 2000. I've been testing this out for a while and it's good some great features...
June 29, 2011 at 7:37 am
We are currently using Idera SQL Diagnostic Manager and have been happy with it's performance. Also their support has been good when we have had issues, or when we have wanted to harvest information from the database for reporting.
It does provide a dashboard, but it does not have a web interface. The console is a desktop application. Last year when we were looking for monitoring tools, I colud not find any that used a web interface.
Good Luck.
Greg Roberts
June 30, 2011 at 7:15 am
Speaking honestly, there is no best tool. There is a best tool for your situation and the amount of money you're prepared to spend and the type of monitoring you need. In short, to understand what's the best tool for you, you need to understand what you're trying to monitor. Are you worried about general up-time, sql agent jobs running, backups completed, and some general performance? There are 2 or 3 tools that are better for that. Are you worried about very specific performance issues and you need to drill down on what exactly is causing performance problems? There are 2 or 3 tools that might be better for that.
I represent Red Gate Software and I can calmly state that our monitoring tool, SQL Monitor, is outstanding and that you should purchase 100's of copies. But, I'd like to be sure it does what you need first. So, what are you hoping to achieve with your monitoring?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 20, 2011 at 10:50 pm
The best tool,
is a good DBA.
However, 90% of the perfmon counters are the same across those systems.
I suggest you log the trace output and alert on them.
The benefit it's the same across all the OSs , you set it up on one and copy to another.
It's also lightweight + free. It can monitor your key areas, SQL, disk, cpu and memory.
Cheers
Jannie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply