Home > IT Answers > SQL Server > SQL Monitoring
Taney2000
0 pts.
 SQL Monitoring
SQL Server
I am just wondering what others are currently usig for monitoring and projection of databases and server? Currently I use code I wrote allong with Excel.

Software/Hardware used:
ASKED: December 9, 2004  4:13 PM
UPDATED: October 17, 2010  2:56 PM
RELATED QUESTIONS
Answer Wiki:
My company is using BMC patrol for Windows and SQL server. It's very comprehensive, it also costs. We found that perfmon will do in a pinch but leave's a lot of issues unresolved and MOM does not work with our other platforms.
Last Wiki Answer Submitted:  December 9, 2004  4:29 pm  by  Mgrafton   0 pts.
All Answer Wiki Contributors:  Mgrafton   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Idera’s SQLCheck is great and it’s free.

Dgdavidgreene
 0 pts.
 

My company gave me 60+ servers to monitor with no money for fancy tools like Lumingent or BMC. Therefore, I wrote one Foxpro application that uses ODBC to scan log files every 30 minutes and reports erros via SMTP. I belive it works better than other tools that I have seen just because it catches errors that those don’t report. I also have another Foxpro application that gathers various stats and disaster recovery information and outputs it to a web site. It proves to be very useful.

Jackass
 0 pts.