THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Memory   (RSS)
  • Setting max server memory

    If there is one server setting that is close to universal to configure, then it is probably the ''max server memory'' setting. The setting is documented here. There are plenty of articles out there on this subject. The purpose for this article is for me to have somewhere to point when I get the question: ''What value should I set this to?''. I ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 6, 2014
  • Squishy Limits in SQL Server Express Edition

    It's an old story you've probably heard before.  Provide a free version of your software product with strict limitations on performance or other specific capabilities so that folks can give it a try without risk, while you minimize the chance of cannibalizing sales of your commercial products.  Microsoft has take this strategy ...
    Posted to Kevin Kline (Weblog) by KKline on March 28, 2013
  • PASS Summit 2011 - Zen and the Art of Workspace Memory - Demos

    What a rush. Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed and I had to reboot it two minutes into the talk--I found my rhythm and the entire 90 minutes ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 16, 2011
  • The Windows Page File and SQL Server

    What is the best “Page File” size for a Windows system running SQL Server? I see this question over and over – and I see people answering it incorrectly all the time. Note: I’m talking specifically about 64-bit architectures here. The information is different for 32-bit architectures, but I’ll blog about that at another time. First, let’s start ...
    Posted to Buck Woody (Weblog) by BuckWoody on June 29, 2010
  • Managing multi-instance cluster failovers with different hardware

    Windows Clustering no longer requires identical hardware Because you can now easily create Windows clusters with different metal, I hear more and more about environments where nodes in a cluster are vastly different.  Whether this is because they can only deck out one server at a time, or because they need to mix older and newer hardware, it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 18, 2009
  • SQL Server Procedure Cache: More Relief on the Way

    If you've read many of my blog posts, you know that I consider lack of procedure cache control to be a major SQL Server pain point. Badly written apps that use non-parameterized ad hoc queries can quickly flood SQL Server's memory pools and bring the server to its knees. SQL Server 2005 brought some relief in the form of the Forced ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 15, 2008
  • A funny thing happened on the way to the database

    A funny thing happened the other day. I was running 64-bit Dev edition on my 4Gb Vista 64-bit notebook. SQL Server was set to 1Gb RAM and I was running 10 scripts each continually inserting a new randomly generated person into a table. The goal was to generate 500 million rows. Meanwhile, I was checking email, doing some browsing, doing some ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on December 14, 2007
Privacy Statement