Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Opinions on SQL Server Software Expand / Collapse
Author
Message
Posted Wednesday, August 5, 2009 12:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 24, 2011 6:24 PM
Points: 20, Visits: 62
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
Post #765764
Posted Wednesday, August 5, 2009 1:16 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
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
Post #765790
Posted Wednesday, August 5, 2009 1:56 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 10:01 AM
Points: 3,840, Visits: 3,841
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?




John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #765815
Posted Wednesday, August 5, 2009 2:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 24, 2011 6:24 PM
Points: 20, Visits: 62
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
Post #765823
Posted Wednesday, August 5, 2009 2:22 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 10:01 AM
Points: 3,840, Visits: 3,841
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.



John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #765831
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse