SQL Clone
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
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: Moderators
Points: 5275 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
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1053 Visits: 895

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
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: Moderators
Points: 5275 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-Enthusiastic
SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 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
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: Moderators
Points: 5275 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