Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Redundant Redundancy Expand / Collapse
Author
Message
Posted Saturday, January 18, 2014 12:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 32, Visits: 579
Comments posted to this topic are about the item Redundant Redundancy
Post #1532356
Posted Saturday, January 18, 2014 5:55 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:29 PM
Points: 601, Visits: 1,733
I have done stuff like this for years.

I've built up a long set of SQL Agent jobs that monitor backups, disk space and similar things. It even sets up the SQL Server Mail functions and just has to be modified for things like the email accounts and drive destinations. But it is fairly generic.

As a script when I setup a new SQL Server, I just pull out the scripts and run them.

I also can had it over to junior techs to run once it is configured for the environment. I consider it part of my toolkit.

The other part of it is to know when you have too many that it gets ignored. I do it that I get an e-mail everyday for full backups regardless of success or failure. Using Outlook rules I then filter them into a s sub email box unread. I then just do a search in the box for "failure" and if any come up I investigate why. That is a daily job.

But I setup tran log backups to only notify on failure. So if I see a message come into the box at 2P I know I need to investigate it. If I was getting them for each one, then I would probably ignore it because it is now "noise" and not something to be concerned with.

You need that balance.




----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Post #1532370
Posted Saturday, January 18, 2014 9:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 35,954, Visits: 30,243
Oooooo... very nice article, Rodney. It really hit a sweet spot with me because I'm taking care of a disk space problem tonight during the "maintenance period" and I'm doing so without it being a panic.

I wrote a stored proc (that calls PowerShell for its WMI capabilities) that not only alerts me to such problems via email, but it also captures daily disk usage (size, freespace, "IsDirty", etc, etc) so that I can forcast when we'll need to buy more disk space under normal growth. It even checks CDROMs because it's a real bugger when one of the folks in NetOps forgets which server they may have left a CD or DVD in. They can just check the morning report for non-empty volume names (hi-lited in Yellow in the report) where the disk type is CD/DVD type of drive.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1532386
Posted Saturday, January 18, 2014 10:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:00 AM
Points: 522, Visits: 2,013
No matter how well you automate things there comes a time when SQL Agent gets stuck and just hangs and no jobs would start. This happened to me fairly recently. So far I haven't found a really clever solution to this.
Post #1532391
Posted Saturday, January 18, 2014 11:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:07 AM
Points: 1, Visits: 246
Hey there, what I have developed is my own SCOM data warehouse which I have then out into Analysis Servies. This has enabled me to extend the wealth of information from SCOM.

What I also have create is a disks running out of space report. It uses the linear regression function with MDX to try and calculate based on the past 7 days of disk usage potentially how long it will take before it runs out of space.

I have then put this into a simple SSRS report with some Kpis to make it easy to read. Also there is a drill down chart showing the past 2 weeks worth of disk usage as well as the entire history of the disk, which often can show you a pattern or trend.

It has helped us countless times to avoid having similar issues of servers running out of disk space.

Just another means of ensuring that the disk space doesn't get critically low.

You can download and try it out for yourself here: http://gqbi.wordpress.com/2013/11/14/scom-systems-center-operations-manager-cube-and-data-warehouse/

Any questions please let me know.
Post #1532392
Posted Monday, January 20, 2014 5:35 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:20 AM
Points: 4,862, Visits: 2,243
Jim P. (1/18/2014)
...The other part of it is to know when you have too many that it gets ignored...


This is key. The same is true with the communications from my bank. Clearly they have understood what all of us probably know: the response to communication overload is inaction i.e. send too many notifications and none of them will be dealt with.


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1532586
Posted Monday, January 20, 2014 7:56 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, April 10, 2014 11:06 AM
Points: 733, Visits: 1,869
The trick is isolating the critical warnings. Email for everything simply means that critical stuff will get lost. Getting the right balance, getting bothered only when necessary, is the tricky part.

I had a similar experience with my bank. I was driving to work, got a phone call, threw it on speaker phone and heard a recorded voice talking about account security but with no mention of bank name or my account. So assuming it was spam, I dumped the phone call.

Later that day I found that the bank had determined my account number had be compromised somewhere and was cancelling it for reissue.


...

-- FORTRAN manual for Xerox Computers --
Post #1532653
Posted Monday, January 20, 2014 9:20 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:12 PM
Points: 20,458, Visits: 14,081
Gary Varga (1/20/2014)
Jim P. (1/18/2014)
...The other part of it is to know when you have too many that it gets ignored...


This is key. The same is true with the communications from my bank. Clearly they have understood what all of us probably know: the response to communication overload is inaction i.e. send too many notifications and none of them will be dealt with.


Very true




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1532723
Posted Monday, January 20, 2014 9:22 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:12 PM
Points: 20,458, Visits: 14,081
Nice article Rodney.

I have built redundant alerts in the past and had gotten away from it. But, it makes a lot of sense. Especially considering the high frequency of failures I have seen with some monitoring tools.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1532725
Posted Monday, January 20, 2014 10:25 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 572, Visits: 2,070
I just got caught by this yesterday. The replication monitor said everything was fine, everything passed a validation test, then a user phoned me about a missing transaction. Sure enough it was missing, so I've spent my morning so far coding other alerting. I should know better than trust replication. I find it very untrustworthy when it comes to reporting errors.
Post #1532748
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse