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

Leaving Some Headroom Expand / Collapse
Author
Message
Posted Thursday, July 26, 2012 12:40 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
Comments posted to this topic are about the item Leaving Some Headroom






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1335580
Posted Thursday, July 26, 2012 7:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:05 PM
Points: 1,334, Visits: 3,068
"I'm not sure how I'd want this to work on my SQL Servers. After all, any load I placed on them wouldn't necessarily just occupy CPU. It would also impact the buffer pool, as the type of process I chose would influence what would stay (or go) in that bit of memory."

You can throttle and control individual processes (CPU & Memory) in SQL Server now. It's called the Resource Governor.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1335841
Posted Thursday, July 26, 2012 8:32 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 2:50 PM
Points: 3,135, Visits: 11,482
Putting an artificial and unneeded CPU load on a server, putting large files that are not needed on the disk, and generating unneeded disk or network IO seem like things that could cause as many problems as they fix.



Post #1335887
Posted Thursday, July 26, 2012 11:27 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
TravisDBA (7/26/2012)
"I'm not sure how I'd want this to work on my SQL Servers. After all, any load I placed on them wouldn't necessarily just occupy CPU. It would also impact the buffer pool, as the type of process I chose would influence what would stay (or go) in that bit of memory."

You can throttle and control individual processes (CPU & Memory) in SQL Server now. It's called the Resource Governor.


Resource governor doesn't limit CPU and memory for individual processes. It works with groups of logins, and it doesn't provide any ability to prevent resources from being used without a competing group.

So if your web site uses a common login, or all logins from your website, then you do not limit resources between these processes. If one pegs the server, they all suffer. They are all in the same pool.

Potentially you could use a second workload group to stick an artificial load on the server and remove it when you needed more resources.

The memory limits are not for the buffer pool, but query memory. Important, but not the same thing.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1336010
Posted Thursday, July 26, 2012 11:28 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
Michael Valentine Jones (7/26/2012)
Putting an artificial and unneeded CPU load on a server, putting large files that are not needed on the disk, and generating unneeded disk or network IO seem like things that could cause as many problems as they fix.



They can. Or they can save you in a crisis, especially disk issues. As with most things, it depends.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1336012
Posted Thursday, July 26, 2012 12:15 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
It makes sense in the same way a reserve tank made sense on old VWs. Sure, you could consolidate it all into one fuel tank and get the same total capacity, but having it separate and only accessible if you flipped a switch or whatever, saves you from "oops, I wasn't watching the fuel gauge and now I'm totally out" situations.

And with modern servers able to go from "c'mon, gimme something to do" to "he's dead now!" pretty fast under the right (wrong) circumstances), you don't have to take your eye off that "fuel gauge" very long for it to count as "not watching it".

So, yeah, I can see the value to this kind of thing. Would definitely have to be documented and drilled as part of your DR/BC plan, or it wouldn't be any use. (Walk five miles to the nearest gas station, buy and fill a gas can, get someone there to give you a ride back to the car, only to be told by that person, "you do know your car has an emergency reserve tank, right?")


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1336043
Posted Thursday, July 26, 2012 1:56 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 28, 2014 3:55 PM
Points: 256, Visits: 1,445
I presented this idea to my SAN admin. I don't think he's was very enthusiastic about the idea.





(ノ °益°) 彡┻━┻
Post #1336105
Posted Friday, July 27, 2012 7:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:05 PM
Points: 1,334, Visits: 3,068


The memory limits are not for the buffer pool, but query memory. Important, but not the same thing.



Good point Steve , it is query memory, and they are not the same thing. i stand corrected.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1336513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse