February 5, 2016 at 10:26 am
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 5, 2016 at 10:29 am
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2016 at 10:40 am
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
Invasion time! Release the hippos! :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 5, 2016 at 10:58 am
Alvin Ramard (2/5/2016)
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
Invasion time! Release the hippos! :w00t:
Let's try sanctions first. We may be able to get him to give it up if we flood his box with alerts then refuse to allow him near it to fix the problem.
February 5, 2016 at 1:07 pm
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
You guys haven't seen the dust bunnies in my basement...
They'll go through Seal Team 6 like poop through a goose!
Ever see Predator?
:hehe:
February 5, 2016 at 1:33 pm
jasona.work (2/5/2016)
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
You guys haven't seen the dust bunnies in my basement...
They'll go through Seal Team 6 like poop through a goose!
Ever see Predator?
:hehe:
Is that before or after gavage?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2016 at 10:05 pm
jasona.work (2/5/2016)
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
You guys haven't seen the dust bunnies in my basement...
They'll go through Seal Team 6 like poop through a goose!
Ever see Predator?
:hehe:
If there's going to be an invasion and we're talking about Predator, I call dibs on the gatling gun. 😀
February 6, 2016 at 6:57 am
Ed Wagner (2/5/2016)
jasona.work (2/5/2016)
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
You guys haven't seen the dust bunnies in my basement...
They'll go through Seal Team 6 like poop through a goose!
Ever see Predator?
:hehe:
If there's going to be an invasion and we're talking about Predator, I call dibs on the gatling gun. 😀
Might be time to start building a wind farm to support the server farm!
Does seem a bit high if the server is idle most of the time.
I wonder if generating bitcoins would be a good test to see if it can pay for itself.
February 7, 2016 at 4:25 pm
Brandie Tarvin (2/5/2016)
Alvin Ramard (2/5/2016)
SQLRNNR (2/5/2016)
WayneS (2/5/2016)
Lynn Pettis (2/5/2016)
jasona.work (2/5/2016)
So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had been last year at the same time. My first thought was, they raised the rates and I didn't notice, so I looked back at previous bills. August, my bills doubled! The problem was, I couldn't pull up the detailed bills from then to see what the rate was.Then I got thinking, something *else* had changed in August...
I'd gotten my shiny new (used) PowerEdge R900 with 4x quad core Xeons, 64GB of RAM, dual 1200w power supplies...
Hmm...
So, to test, I've shut it down for the month. Last night I fired up an app our electric company has that will show you your daily / weekly / monthly electric usage and took a look. There was a difference of 10kw/h use between the day the server was shut down, and the previous day...
Not quite enough to cover the entire increase I think, but enough to put a dent in it (I think the new NAS I put in is probably the other chunk, and I can't shut the NAS down.)
Sigh, so my fun toy is now a "gotta go plug it in before I can use it for stuff, and unplug it when I'm done" toy. I don't want to leave it plugged in when it's off, as the power supplies will still draw some power (and I'm too lazy right now to figure out how to get the DRAC card in it to handle powering on / off remotely)
Anyone want a nice rack-mount server?
DRACs are great when you have to power cycle remote servers, especially in hostile country.
So, Jason's basement is a hostile country now? Hmm... time to make some invasion plans. :w00t::w00t:
Call in SEAL team 6 to liberate the hostage server.
Invasion time! Release the hippos! :w00t:
Let's try sanctions first. We may be able to get him to give it up if we flood his box with alerts then refuse to allow him near it to fix the problem.
I shall never yield to your illegal and despicable sanctions! My ultimate power project shall not be denied in the glorious workers paradise of my basement!
:hehe:
PS Lynn: THANK YOU for giving me just enough of a nudge to take a look at the DRAC option! Being able to power the box on and off with out having to go down to the basement for on, is so nice!
February 8, 2016 at 11:09 am
So, who showed up to SQLSat Cleveland as Mimi?
It sounds like Wayne chickened out. He should get flying porkchops for that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 8, 2016 at 11:15 am
Heading to Seattle soon and wondering if MS gives campus tours or not. Because... why not?
Anyone know if they do?
February 8, 2016 at 11:16 am
SQLRNNR (2/8/2016)
So, who showed up to SQLSat Cleveland as Mimi?It sounds like Wayne chickened out. He should get flying porkchops for that.
No Mimi, but while trying to explain to someone about the pork chop launcher, we found a recipe for Modenese Pork Chops.
http://allrecipes.com/recipe/59866/modenese-pork-chops/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 8, 2016 at 11:20 am
Michael L John (2/8/2016)
SQLRNNR (2/8/2016)
So, who showed up to SQLSat Cleveland as Mimi?It sounds like Wayne chickened out. He should get flying porkchops for that.
No Mimi, but while trying to explain to someone about the pork chop launcher, we found a recipe for Modenese Pork Chops.
I was present at that conversation. It was hilarious. The odd thing was that the recipe didn't mention velocity or propellant in any way. 😛
In all seriousness, it was a good event. I got to meet a few new people and most of the sessions I went to were good. Some good, some great.
February 8, 2016 at 11:38 am
Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in about 3-4 months. Was up for another hour or so cleaning him and then taking a shower. Working from home today since I smell even worse than normal.
Then my dad got news that the tumor in his bladder is very aggressive cancer. They are going to take his bladder and create a new one from part of his intestines. Sounds pretty crazy to me but they say he has a very good chance at a full recovery.
Hoping this week turns out sometime soon.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 8, 2016 at 11:44 am
SQLRNNR (2/8/2016)
So, who showed up to SQLSat Cleveland as Mimi?It sounds like Wayne chickened out. He should get flying porkchops for that.
Wayne does not chicken out, he turkeys out:-D
😎
There is a quantifiable difference.
Viewing 15 posts - 52,591 through 52,605 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply