SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Opinions on SQL Server Software


Opinions on SQL Server Software

Author
Message
rsteckly
rsteckly
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 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 Smile). I'm resisting that urge, however, because the objective is to build a dba practice, not write software.

Thanks,

Ron
GSquared
GSquared
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59733 Visits: 9730
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
John Rowan
John Rowan
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14050 Visits: 4591
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
rsteckly
rsteckly
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 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
John Rowan
John Rowan
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14050 Visits: 4591
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search