InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:49:52 GMT20http://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspx[quote][b]Michael L John (11/8/2010)[/b][hr]How about an SMS text, a Blackberry PIN message, and possibly a cell phone call?[/quote]Also just to mention - we provide a basic RSS feed of the Alert Inbox in the product allowing you to track new alerts through this mechanism also.BenTue, 09 Nov 2010 07:48:43 GMTbenjreeshttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxMost carriers offer you an email, usually yourphone@carrier.com (like 5555555@tmobile.com) to send an SMS from email.Tue, 09 Nov 2010 07:40:27 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspx[quote][b]Michael L John (11/8/2010)[/b][hr]How about an SMS text, a Blackberry PIN message, and possibly a cell phone call?[/quote]Hi MichaelThanks for the feedback - we have been looking at some of these options for future releases.There are third party companies that offer this sort of service on top of alerting systems, [url=http://www.pagerduty.com/]http://www.pagerduty.com/[/url], for example. In particular these companies often provide quite advanced call management (for example, if someone doesn't answer the phone call, the system will redirect it to the next person on the list and so on). Is this the sort of functionality you're looking for?RegardsBenTue, 09 Nov 2010 07:37:11 GMTbenjreeshttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxGlad to hear Geoff that you are liking it.Regards,PriyaTue, 09 Nov 2010 07:06:50 GMTpriya.sinhahttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxi have been running this product all through the beta. (about 2 months now) it has come along way....my company will be buying it first QTR 2011. (had to wait for the bean counters to put it in the budget)while it is not as "complete" as Diagnostic Manager or SQL Ignite, for the price, it is great!RedGate has a forum for users and testers to make recommendations and voice complaints. they are very quick to respond and tell you if they can help or not. for example, I said they were missing an alert for failed logins and they responded back with in 6 hours saying it will be added in a future update.thanks RedGate for another choice for SQL monitoring.Tue, 09 Nov 2010 06:24:47 GMTGeoff Ahttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxHow about an SMS text, a Blackberry PIN message, and possibly a cell phone call?Mon, 08 Nov 2010 12:15:10 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspx[quote][b]Robert.Sterbal (11/8/2010)[/b][hr]A really neat product, I'm especially interested in how you came up with this list of performance counters, and if the list is considered proprietary:Machine: processor timeAvg. CPU queue lengthMachine: memory usedMemory pages/secNetwork utilizationDisk usedDisk avg. read timeDisk avg. write timeDisk transfers/secAvg. disk queue lengthUser connectionsSQL Server: processor timeSQL Server: total memorySQL Server: target memoryBatch requests/secCompilations/secCompilations/batchRecompilations/secBuffer cache hit ratioBuffer free pagesBuffer page life expectancyFull scans/secPage splits/secPage splits/batch requestLatch wait timeLock timeouts/secLock waits/secAvg. lock wait timeTransactions/secActive transactionsTotal sizeData sizeLog sizeLog space usedLog bytes flushed/secLog flushes/secLog flush waits/secThanks for the wonderful detail about each counter. It would be nice to see it posted on this website.[/quote]about 9 months ago i started to really monitor our SQL servers and set up perfmon. i just selected any counter which i thought could be remotely useful. made some reports in SSIS but haven't had much time for really doing something with the dataMon, 08 Nov 2010 11:50:16 GMTalen teplitskyhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxHi MichaelYes, it is at the moment, though this is very configurable. What sort of notification were you looking for?BenMon, 08 Nov 2010 11:37:09 GMTbenjreeshttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxIs email the only method that can be used to send notifications for an alert? Mon, 08 Nov 2010 10:40:42 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxHi RobertThanks for the great feedback on SQL Monitor - glad you like what you see.First of all - the list is certainly not proprietary. Feel free to use it - I hope it's useful to you.On your main question - we put together the list by talking to [i]a lot[/i] of DBAs and doing a lot of research. We asked all sorts of DBAs the question - "What do you use to help you find and fix problems?" and we came up with that list.And great that the descriptions are useful - that was the aim of those!RegardsBen ReesRed Gate SoftwareMon, 08 Nov 2010 10:26:30 GMTbenjreeshttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxHi,Thanks a lot for your feedback. We came up with this list of counters after extensive research, feedback/ review from many DBA's and from our Beta/ EAP (Early Access Program) users. The help on the Analysis page has also been reviewed by multiple DBA's including Brad McGehee also. Regards,PriyaMon, 08 Nov 2010 10:20:18 GMTpriya.sinhahttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxA really neat product, I'm especially interested in how you came up with this list of performance counters, and if the list is considered proprietary:Machine: processor timeAvg. CPU queue lengthMachine: memory usedMemory pages/secNetwork utilizationDisk usedDisk avg. read timeDisk avg. write timeDisk transfers/secAvg. disk queue lengthUser connectionsSQL Server: processor timeSQL Server: total memorySQL Server: target memoryBatch requests/secCompilations/secCompilations/batchRecompilations/secBuffer cache hit ratioBuffer free pagesBuffer page life expectancyFull scans/secPage splits/secPage splits/batch requestLatch wait timeLock timeouts/secLock waits/secAvg. lock wait timeTransactions/secActive transactionsTotal sizeData sizeLog sizeLog space usedLog bytes flushed/secLog flushes/secLog flush waits/secThanks for the wonderful detail about each counter. It would be nice to see it posted on this website.Mon, 08 Nov 2010 09:59:28 GMTRobert.Sterbalhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxHi Alen,SQL Monitor is available from $595 per server. More information is available on the Red Gate website:http://www.red-gate.com/sqlmonitorIf you want to try SQL Monitor, you can monitor SQL Server Central's servers on www.thefutureofmonitoring.com without having to install the tool.If you have any questions, please feel free to email dba.info@red-gate.com.Thanks and with kind regards,WibkeRed Gate SoftwareMon, 08 Nov 2010 09:31:50 GMTWibke Carstensenhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxhow much is it?Mon, 08 Nov 2010 08:38:35 GMTalen teplitskyhttp://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxI'd be interested to know (from people who have seen/used both) what the difference is between this and Idera's SQL Diagnostic Manager...Mon, 08 Nov 2010 06:56:51 GMTBob Bridges-173967http://www.sqlservercentral.com/Forums/Topic1016894-824-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/press+release/71593/">Red Gate releases new SQL Monitor 2.0: The future of monitoring is wherever you are</A>[/B]Sat, 06 Nov 2010 13:59:45 GMTPress Release