Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Review of sqlSentry 2.5


A Review of sqlSentry 2.5

Author
Message
Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1955 Visits: 235
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/areviewofsqlsentry25.asp

Brian Knight
Free SQL Server Training Webinars
jeffrey yao
jeffrey yao
SSC Veteran
SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)

Group: General Forum Members
Points: 265 Visits: 868

Brian, does SQLSentry cause any overhead cost on performance? I remember in SQLSentry ver2, I notice the product runs two jobs, one of which runs every minute (I guess it is the default setting). So I am just wondering whether this is a potential problem....

Jeffrey





Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1955 Visits: 235
In the 2.x form, I ran it for almost 6 months solid on a pretty intense server and never noticed anything. What it's doing is hitting a sysjobs table for a subsecond query.

Brian Knight
Free SQL Server Training Webinars
abeljda
abeljda
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 107
Hi Brian, I noticed you said there were no competitors for sqlsentry, Idera has a SQLSchedule tool, have you looked at that? I believe it has a lot of the same features.



Brian Knight
Brian Knight
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: Moderators
Points: 1955 Visits: 235

You are correct. sqlSentry provides the application to Idera to be marketed as SQLschedule under an OEM arrangement. This gives you the option of getting sqlSentry for stand alone use or as a part of Idera’s Suite of products



Brian Knight
Free SQL Server Training Webinars
Heinrich-492677
Heinrich-492677
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 21
Hi Brian

I got a Question about your review of sqlSentry 2.5
this statement:
"•A method to close "tickets" for jobs that failed with notes. "
what exactly does it mean

I think what it means is that u can actually create a ticket on a failed job and then go back to SQLSentry fix the job and close it?
Can you please tell me is this option still available in SQLSentry 2.7 and if it is, please guide me on where to find it in SQLSentry and how to use it.

thx in advance
Fluffy
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