Search


	Podcast:		voiceofthedba's podcast
	Episode:		Lack of Memory
	Category:		Technology
	Duration:		00:03:09
	Publish Date:		2019-01-02 20:00:00
	Description:		I was reading Brent's look at "normal memory" for his SQL ConstantCare® clients. It's a look at some stats from quite a few servers that customers have set up and he is monitoring. Since most of us only have a limited set of instances to examine, it's nice to see what a wide variety of installs are using. Even though this doesn't necessarily mean we should change anything in our environment, it does help me to understand some general trends, and perhaps think about how to recommend settings for new installations. When we build a server, we expect it to work a certain way. Over time, we are almost always adding data to the system, but often we don't add more RAM. This would be like buying a vehicle and loading it up with supplies you need for work. If the amount of supplies kept growing, would you keep piling them on or buy/rent/borrow a bigger vehicle? Some would, some wouldn't. I'm always amazed by how far people will push a situation, especially when fairly small and inexpensive changes might make a big difference. Read the rest of Lack of Memory
	Total Play:		0