Back Home

SQL Server database administration in sunny Cleveland, OH

SQL Server database administration in sunny Cleveland, OH

Home » 2011 » April » 25

Daily Archives: April 25, 2011


Aha!

This entry was posted in Features Troubleshooting and tagged memory Resource Governor troubleshooting on April 25, 2011 by Colleen M. Morrow

I found the answer to my Resource Governor quandary in this outstanding article, Understanding SQL Server Memory Grant, on MSDN.  The juicy bit: The server calculates the memory limit for one query. By default, this is 25% (20% on 32bit SQL 2005) of total query memory (which is set by memory broker as about 90% […]


Categories

  • BI (19)
  • Events (17)
  • Features (47)
  • General (32)
  • Internals (3)
  • Maintenance (21)
  • Non-SQL Stuff (7)
  • Powershell (9)
  • Professional Development (46)
  • Security (3)
  • SQL Tuning (7)
  • T-SQL (26)
  • Troubleshooting (16)
  • Uncategorized (4)

Recent Posts

  • SQL Server Service Broker – Security
  • Joining Fortified Data
  • SQL Server Service Broker – Networking
  • SQL Server Service Broker – Internal Activation
  • SQL Server Service Broker – Error Handling

Tags

#TSQL2sDay 70-463 a to z Auditing backup compression backups blogging certificates database maintenance data compression differential backup DMVs Event Notifications exam prep general dba goals high-availability index maintenance inventory linked servers memory mirroring Oracle page compression PASS performance powershell presenting professional development recovery Resource Governor scripts Service Broker slacking off snapshots SQL 2008 SQL Audit SQL Saturday SQL Server SSIS troubleshooting tsql update statistics WIT Women in Technology

· © 2021 ColleenMorrow.com · Designed by Themes & Co ·

Back to top