• SQL Server memory configurations for procedure cache and buffer cache

    To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you're using, whether it's x86, x64 or Itanium and the amount of memory allocated to the SQL Server instance. SQL Server expert Denny Cherry lays out how the system configures...

    Denny Cherry67,565 pointsBadges:
  • More SQL Server memory problems solved

    Workarounds are great, but you might want to consider solving your SQL memory problems at an OS level.

    ITKE440,570 pointsBadges:
  • The short course on how SQL Server really works

    Have you found yourself in the uncomfortable role of DBA simply because there's no one else to do the job? This series is for you. In part one, learn the basics of how data moves from disk to memory in Microsoft SQL Server.

    ITKE440,570 pointsBadges:
  • Configuring SQL Server memory settings

    While SQL Server has only a few simple memory settings, those settings are crucial. In this tip, SQL Server expert Denny Cherry shares configuration recommendations for optimal RAM amounts, how to enable AWE, the best number of gigabytes for maximum server memory and the differences between 32- and...

    Denny Cherry67,565 pointsBadges:
  • Step 3: Know your memory support limitations

    Find out what is the maximum available memory for the various editions of SQL Server.

    ITKE440,570 pointsBadges:
  • SQL Server out of memory: Troubleshoot and avoid SQL memory problems

    Ever get a SQL Server out of memory error message? If so, you know that most often this indicates a problem with the system, not simply a memory shortage. SQL Server MVP Denny Cherry shares methods to tune SQL Server to relieve memory pressure, including changing clustered indexes to non-clustered...

    Denny Cherry67,565 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.