SQL Server is well known for being a memory hog. When installed, the default configuration allocates a ridiculous amount of memory (2147483647 MB) to the instance. In effect, this grants SQL Server access to whatever memory is assigned to the server, which it will try to use at times at the expense of operating system…

This content is for subscribers. Please enter the password to access it.

  • This field is for validation purposes and should be left unchanged.
About Jennifer

Jennifer (aka Pixie) has over 30 years of experience in the Information Technology field, which includes 13+ years of Systems Administration, 16+ years of developing and implementing technical documentation and training, and 14+ years of supporting OnBase. She has extensive experience with OnBase, SQL, and a firm foundation in computer science. Despite this, she considers herself a well-adjusted nerd with hobbies including gardening (poorly), archery, and knitting in public.

Jennifer Siegel
Jennifer Siegel
Feb 25, 2013
Other Solutions
You May Also Like:
Other Solutions
Jennifer Siegel
Jennifer Siegel • Jun 08, 2015
Other Solutions
Jennifer Siegel
Jennifer Siegel • Oct 13, 2014
Other Solutions
Jennifer Siegel
Jennifer Siegel • Mar 24, 2014