August 5, 2009 at 12:47 pm
Hi,
As I've mentioned in my previous posts, I'm coming to DBA work from the .NET developer world. I'm investigating the tools I need to proceed.
Right now, I'm investigating monitoring tools. I'd like a tool that monitors the database server(s) and notifies me when issues arise. Ideally, this tool would allow me to export the data.
I'd like to be able to export the data because I want a customer portal (right now SharePoint seems to be the best solution for this portal) where customers can log in to see information on what issues have arisen and what steps have been taken.
I've downloaded a trial of Redgate's SQL Response. Because it is north of $400 a server, it seems a little pricey. I also don't see a way to export data.
I haven't investigated xsqlsoftware or apexsql yet. Do people have any suggestions on a) sql monitoring software and b) help desk/portal software that can be plugged into it?
I don't mind having to tweak it/or build part of it (I am a developer after all :)). I'm resisting that urge, however, because the objective is to build a dba practice, not write software.
Thanks,
Ron
August 5, 2009 at 1:16 pm
The RedGate one is what I'm more familiar with.
When I want to export the data, I generally just query it myself directly.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 5, 2009 at 1:56 pm
rsteckly (8/5/2009)
Hi,.......I'd like a tool that monitors the database server(s) and notifies me when issues arise. Ideally, this tool would allow me to export the data.
I'd like to be able to export the data because I want a customer portal (right now SharePoint seems to be the best solution for this portal) where customers can log in to see information on what issues have arisen and what steps have been taken.
What types of issues are you looking to identify? Since you bring up exporting the data that caused the issue do you mean that you want some software to identify any data related integrity violation and export that data off for reporting?
August 5, 2009 at 2:10 pm
Hi,
No actually I just want a monitoring tool that identifies the most common performance issues and allows me to export it into a common file format, such as csv, tsv or Excel.
I basically want a way to represent to my customers what is going on with their servers and provide comments on the event. The idea would be to export the data, filter it, provide comments and upload it.
They could then log in and see what is going on with each instance of their server and drill down to make comments.
Ron
August 5, 2009 at 2:22 pm
You could pull this off with SQL Server profiler along with some well written queries to pull the server level performance metrics. As far as a third party tool, Spotlight on SQL Server may work. I used to work with a guy that loved it because of the graphical display. Personally, I do all monitoring with Profiler and Windows Perfmon.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply