Activity overview
Latest activity by buttonbj
Thank you Evan and Colin for your suggestions! I will check out that simple-talk article and mess around with custom metrics more. Thank you again!
-Brandon / comments
Thank you Evan and Colin for your suggestions! I will check out that simple-talk article and mess around with custom metrics more. Thank you again!
-Brandon
Monthly Trending with SQL Monitor
Hi everyone,
To start off, I have purging setup on SQL Monitor to happen once every month. I am looking at creating a trending report for SQL Server and I was wondering if SQL Monitor already had ...
As a follow up, Priya Sinha was able to help identify my issue. My Query was returning null values at times and this was interfering with the alert working correctly. Once I fixed my query to not return a null value, the alert worked as intended. / comments
As a follow up, Priya Sinha was able to help identify my issue. My Query was returning null values at times and this was interfering with the alert working correctly. Once I fixed my query to not...
Custom Metric does not fire off
Hello everyone,
I created a custom metric to watch for transactions that are running for more than a day. The reason why I have to do this is, is because one of our vendors has followed poor codin...
Thank you for the reply and sorry for the late post. This does not seem to work either. No matter what value I use for the TcpMaxConnectRetransmissions value, it doesn't change my results. If this helps anyone, I am using this on Windows Server 2008 R2. / comments
Thank you for the reply and sorry for the late post. This does not seem to work either. No matter what value I use for the TcpMaxConnectRetransmissions value, it doesn't change my results. If th...
Could you send that link again? It doesn't seem to be in your post. The network adapters are definitely not overloaded on either the SQL box or the SMTP server. I have verified this. Thank you! / comments
Could you send that link again? It doesn't seem to be in your post. The network adapters are definitely not overloaded on either the SQL box or the SMTP server. I have verified this. Thank you!
Thank you for your reply. I went on our server and added the DWORD as mentioned in the previous post. This did not work. I tried multiple values (1 minute, 6 minutes, and others), restarted the service and the cluster resource, but nothing seems to work. When I kick off the job, the job ends in 24 seconds with the same error message. It's seems like SQL Backup is ignoring the new registry value. I forgot to mention that this is a clustered environment too... / comments
Thank you for your reply. I went on our server and added the DWORD as mentioned in the previous post. This did not work. I tried multiple values (1 minute, 6 minutes, and others), restarted the ...
E-mail notifcation not working
Hello everyone,
We have SQL Backup 7.2 installed on our server and when we run the backup job, no notification gets sent to any of the recipients. The error we receive is: Warning 151: MAILTO er...