TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
SQL Server KBs and Blogs
Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news
Tags
"Be Aware" Problems
2000
2005
2005 SP2
2008
2008 R2
ADAM
Alwayson
Analysis Services
Azure
Azure Reporting
blob data
Bulk Insert
Claims
Connectivity
CPU
database engine
Database Mirroring
database tuning advisor
DBVideo
Debugging
Engine
Featured
File Stream
Guillaume
How It Works
How to
intra-query parallelism
IO
JDBC
Kerberos
Linked Server
Manageability
Memory
missing msp
msi missing
Native Data Access Technologies
NONSSIS
Normalization
Nt Authority\System
ODBC
OLEDB
Oracle
pass
Performance
Performance Monitoring
Performance Tools
Power View
PowerPivot
query hints
query plan
Replication
Report Design
Reporting Services
RML Utilities
Security
setup sql server
SharePoint
SharePoint Adventures
SharePoint Integration
snapshot replication
sp_reset_connection
SQL 2005
SQL 2008
SQL 2012
SQL 2014
SQL Azure
SQL CLR
SQL Connectivity
SQL Engine
SQL Performance
sql query performance
SQL query plan
SQL replication
SQL replication types
SQL Server
SQL Server 2005 SP2
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 SP1
SQL Server 2012
sql server cache
SQL Server Performance
SQL Server Performance Tuning
SQL Setup
sql tuning
SQL update statistics
SQLOS
SSIS
SSMA
Tools
trace
Tracing
Transactional Replication
Troubleshooting
update statistics
update statistics sql server
VSS
Wait Types
Windows Azure SQL Database
Browse by Tags
TechNet Blogs
»
SQL Server KBs and Blogs
»
All Tags
»
memory
Related Posts
Blog Post:
SQL PFE has a Pre-Con at the PASS Summit!
SQL Server Support Content
At the 2014 PASS Summit in Seattle on Tuesday November 4, Denzil Ribeiro and I (Tim Chapman) will be giving a Pre-Conference seminar entitled “ Troubleshoot Customer Performance Problems like a Microsoft Engineer .” In this full-day session ...read more
on
9 Oct 2014
Blog Post:
As The World Turns: SQL Server NUMA Memory Node and the Operating System Proximity
SQL Server Support Content
It felt a bit like ‘As The World Turns’ as I unraveled how the following worked so the title is a bit of a tribute to my grandmother. She could not miss here ‘stories’ in the afternoon. Proximity Before I dive into the details I would like to talk ...read more
on
4 Feb 2014
Blog Post:
How It Works: CMemThread and Debugging Them
SQL Server Support Content
The wait type of CMemThread shows up in outputs such as sys.dm_exec_requests. This post is intended to explain what a CMemThread is and what you might be able to do to avoid the waits. The easiest way to describe a CMemThread is to talk about ...read more
on
20 Dec 2012
Blog Post:
How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
SQL Server Support Content
This issue was puzzling until we stepped through the code and studied it in some detail. The report was “SQL Server won’t use the physical memory I expect it to use.” Scenario: SQL Server 2008 R2, 32GB RAM - SQL only using ~22GB ...read more
on
11 Dec 2012
Blog Post:
SQLCLR and sp_OA* procedures are not compatible
SQL Server Support Content
We ran into an issue today that is a bug you may need to be aware of because of its behavior. When a SQLCLR procedure calls back into the SQL Server (in proc provider) and executes sp_OA*, during the callback activity, it triggers a bug (currently ...read more
on
20 Dec 2012