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 «««4,2234,2244,2254,2264,227»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, November 27, 2013 6:26 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 42,822, Visits: 35,953
Ed Wagner (11/27/2013)
GilaMonster (11/27/2013)
Anyone want to handle this one?

'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'
http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx

I offered up the system Performance Logs and Alerts, but I have no idea if this is it. Could be a database job or scheduled task, but how would a query be aware of a database that's offline? After all, it's offline.


A query against sys.databases could be aware, it could check the status column, see if any DBs have been set to offline, but if so, that'll be custom code/job



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1518043
Posted Wednesday, November 27, 2013 6:30 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 980, Visits: 5,112
Greg, thanks for the suggestion, thankfully the method of "upgrading" here is to deploy a new server, clean-loaded with the new OS. I think what's potentially going on is the VMDK file(s) may either be corrupt, or the physical storage they're on has a problem. Either way, the server in question for that should be getting turned off next week.

Revenant, I don't drink, but a good recommendation for a decent beer might help... Or a box of 100rds 9mm FMJ ammo so I can go to the range after work and pretend the targets are the people I was complaining about...

Maybe even spring for silouhette targets and tape pictures of the faces to them...



Thankfully, my direct superiors are working to avert a disconnection of the servers in question, so hopefully I won't be facing hordes of angry users before the end of the day...
Post #1518045
Posted Wednesday, November 27, 2013 7:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 1,232, Visits: 6,641
jasona.work (11/27/2013)
Greg, thanks for the suggestion, thankfully the method of "upgrading" here is to deploy a new server, clean-loaded with the new OS. I think what's potentially going on is the VMDK file(s) may either be corrupt, or the physical storage they're on has a problem. Either way, the server in question for that should be getting turned off next week.

Revenant, I don't drink, but a good recommendation for a decent beer might help... Or a box of 100rds 9mm FMJ ammo so I can go to the range after work and pretend the targets are the people I was complaining about...

Maybe even spring for silouhette targets and tape pictures of the faces to them...



Thankfully, my direct superiors are working to avert a disconnection of the servers in question, so hopefully I won't be facing hordes of angry users before the end of the day...


It's up and running now, so I wouldn't think the physical storage is the issue.
Dig just a bit further into how the current one is configured vs. the cleanly deployed one might lead to a quick answer.

With the price and availability of ammo, you might run into cost and time delays.
Be cautious shooting custom silouhettes. Kind of raises red flags.

So Castle Danger has a couple good beers.
But they are only open 3pm to 8pm Friday and Saturday, and location on the north shore of Lake Superior might be problems.
Finding a local brew pub sounds like a better idea.

Post #1518074
Posted Wednesday, November 27, 2013 7:50 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 36,995, Visits: 31,516
Greg Edwards-268690 (11/23/2013)
L' Eomot Inversé (11/23/2013)
Ed Wagner (11/22/2013)
I never had the "pleasure" of working with either of those IBM products, but I've been forced to work with other ones. If they're any judge, it's a wonder the company is still in business.

That sounds as if you worked with DB2 and SNA. Or did they have another two that bad?


DB2 on an AS400 was pretty rock solid. I kind of wished SQL Server ran on an AS400.
I think if some places added up the total costs, they might think twice about Windows Servers.


I can atest to that. They take a lickin' and keep on tickin'. The only time they don't is when the battery on cache runs dry. Then, it's a world of hurt performane wise and you have to re-convince people that the system has a bloody battery in it.


--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."

(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 #1518083
Posted Wednesday, November 27, 2013 7:52 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 36,995, Visits: 31,516
jasona.work (11/26/2013)
/rant mode on

Frickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle servers I've been baby-sitting for a couple months may get pulled from the network because they're not "updated." Let's see, a SQL server that is required to go away by Monday because it's running Win Server 2008 and not 2008R2 that when I tried to update it lost several drives after the reboot (VM, so I was able to revert to the snapshot from before doing anything,) and Oracle databases that are in a:
"You need to patch for this vulnerability.
There's no patch from Oracle for the version being run for that vulnerability and there's no Oracle DBA to handle upgrading.
You need to patch for this vulnerability.
See my previous response.
You need to patch for this vulnerability or upgrade.
See my previous response.
We're threatening to pull these servers from the network if you don't apply the patch.
THERE IS NO D*MN PATCH FOR WHAT YOU WANT!!!!"

So now I get to go in early, potentially to explain to the customers why stuff isn't working, where my only answer can be "IA pulled them because there's no patch to fix what they want fixed from the vendor, or "fixing" the problem breaks the server anyways."

yay
/rant off

So, hope everyone has a happy Thanksgiving if you celebrate it, or a nice weekend otherwise!


Document the problem, save all emails, forward to the CEO, and enjoy your ThanksGiving off.


--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."

(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 #1518084
Posted Wednesday, November 27, 2013 4:49 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 980, Visits: 5,112
Jeff Moden (11/27/2013)
Document the problem, save all emails, forward to the CEO, and enjoy your ThanksGiving off.


Thankfully my boss has been involved from nearly the start and knows what's been going on. Plus he gets CC'ed on the e-mails about it.

But what a day...

So, the servers didn't get taken off the network, so that's a plus. But, the SQL server that was giving me problems did restart last night, when the VMWare host it was on failed. So wound up taking a snapshot before doing anything, then trying to straighten out the problem. Chkdsk did report problems, but once I assigned permissions to the drives and folders, managed to get (most) of the Sharepoint DBs up.

The two that didn't come back we restored from last nights backup and all was well. The Sharepoint Admin sorted out an issue he had been having, and we're go to switch to the new SQL and SP servers next week. The SP guys want to hold off until Thursday to do the switch so as to not have to deal with users having fits because SP is down. I had the backup admin (Commvault handles the backups, does "normal" SQL backups) bump up the frequency of TLog backups to cut down on potential data loss if the SQL server dies before then...

Then I went to the gun range and burned some frustration on paper targets...
Post #1518228
Posted Wednesday, November 27, 2013 6:07 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 1:00 PM
Points: 4,196, Visits: 3,235
jasona.work (11/27/2013)
Jeff Moden (11/27/2013)
Document the problem, save all emails, forward to the CEO, and enjoy your ThanksGiving off.


Thankfully my boss has been involved from nearly the start and knows what's been going on. Plus he gets CC'ed on the e-mails about it.

But what a day...

So, the servers didn't get taken off the network, so that's a plus. But, the SQL server that was giving me problems did restart last night, when the VMWare host it was on failed. So wound up taking a snapshot before doing anything, then trying to straighten out the problem. Chkdsk did report problems, but once I assigned permissions to the drives and folders, managed to get (most) of the Sharepoint DBs up.

The two that didn't come back we restored from last nights backup and all was well. The Sharepoint Admin sorted out an issue he had been having, and we're go to switch to the new SQL and SP servers next week. The SP guys want to hold off until Thursday to do the switch so as to not have to deal with users having fits because SP is down. I had the backup admin (Commvault handles the backups, does "normal" SQL backups) bump up the frequency of TLog backups to cut down on potential data loss if the SQL server dies before then...

Then I went to the gun range and burned some frustration on paper targets...

Good to hear they're back and online. At least you got to have some fun. Enjoy your Thanksgiving off and don't forget to eat too much.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1518239
Posted Thursday, November 28, 2013 1:50 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:21 PM
Points: 33,202, Visits: 15,350
Hope everyone is enjoying the holiday in the US, or having a good day elsewhere.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1518405
Posted Thursday, November 28, 2013 2:02 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
Steve Jones - SSC Editor (11/28/2013)
Hope everyone is enjoying the holiday in the US, or having a good day elsewhere.

You bet your a**. Once again, Steve, I do appreciate your work. whatever I can do for you.
Post #1518406
Posted Thursday, November 28, 2013 6:08 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 1:00 PM
Points: 4,196, Visits: 3,235
Revenant (11/28/2013)
Steve Jones - SSC Editor (11/28/2013)
Hope everyone is enjoying the holiday in the US, or having a good day elsewhere.

You bet your a**. Once again, Steve, I do appreciate your work. whatever I can do for you.

You too, Steve. The food, clean-up and visiting are done. Now for the food coma. I'll wait a while before the snack.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1518427
« Prev Topic | Next Topic »

Add to briefcase «««4,2234,2244,2254,2264,227»»»

Permissions Expand / Collapse