acheter chaussures christian louboutin 2014

acheter chaussures puma 2014

acheter chaussures nike air jordan 2014



 
  
Thursday, October 30, 2014     | Register
Memory Configuration

 

Locked Pages, AWE, Task Manager and the Working Set

 

A great post from Bob that de-mystifies a lot of common memory misconceptions ... Source : Bob Ward - CSS SQL Server Engineers - MSDN.com

 

 

A Walk Down Memory Lane

 

A fantastic powerpoint presentation from Christian that covers all of the important memory configuration tasks including the limits of 32 bit systems, the memtoleave area, considerations for 64 bit systems, AWE on 32/64 bit systems and setting mix/max memory values ... Source : Christian Bolton - Coeo.com - pdf presentation

 

 

64 Bit & AWE

 

In this post, Slava clears up some confusion surrounding 64 bit & AWE. Be sure to read the comments for further illumination ... Source : Slava Oks - MSDN.com - Blog Post

 

 

Does SQL Server respond to Memory Pressure?

 

Another great Q&A post from Slava. In this one, he answers a question about how SQL Server 2005 responds to memory pressure regardless of the Lock Pages in Memory Setting. He also covers the importance of setting a Maximum Memory value to avoid memory pressure situations ... Source : Slava Oks - MSDN.com - Blog Post 

 

 

MemToLeave and 32-bit SQL Backup failures

 

A common symptom of MemToLeave issues on 32 bit systems are backup failures with "reserve contiguous memory" related errors. In this post, Joe discusses adjusting the BufferCount and MaxTransferSize as an alternative to increasing the MemToLeave value (-g switch) ... Source : Joe Chang - SQLBlog.com - Blog Post

 

 

SQL Server Memory Usage & Task Manager

 

Relying on Task Manager to determine SQL Server's memory usage can be quite confusing unless you know how/what to look at ... Source : Kevin Kline - SQLBlog.com

 

 

 


Server Configuration

 

Lock Escalation & Trace Flags

 

By default, SQL Server will choose the appropriate lock granularity & escalation points. This can be overridden with trace flags and query hints, however, as Sunil points out, there are various limitations with doing so ... Source : Sunil Agarwal - MSDN.com - Blog Post

 

 

Setting Advanced Configuration Options in SQL Server 2005

 

This article discusses some of the advanced configuration options in SQL Server 2005 and their associated best practices and limitations ... Source : Dell.com

 

 

 


CPU Configuration

 

To MAXDOP or not to MAXDOP

 

… that is the question. Two of my favorite bloggers (Linchi Shea and Joe Chang) compare notes on query performance with various MAXDOP settings ... Source : Linchi Shea - SQLBlog.com

 

 

Multi-Cores and MAXDOP

 

Linchi addresses the generally accepted practice to turn off Parallelism when unexpected problems arise, and what this means for the future with multicore processers becoming the norm ... Source : Linchi Shea - SQLblog.com - Blog Post

 

 

CXPACKET Waits & MAXDOP

 

A common reaction to the presence of CXPACKET waits is to switch MAXDOP to 1. As Jason points out, this may not be the best approach, particularly if missing indexes and/or out of date statistics are the cause ... Source : Jason Massie - StatisticsIO.com - Blog Post

 

 

 


OS Configuration

 

Configuring Windows 2003 ( x64 ) for SQL Server

 

A great blog from Grumpy Old DBA! In it he discusses configuring Windows x64 for SQL Server and covers memory allocation, CPU allocation and page file sizing ... Source : Grumpy Old DBA

 

 

TCP Offloading

 

Take a deep dive with the CSS team into the internals of a TCP Chimney/Offloading problem from one of their customers ... Source : Evan Basalik - CSS SQL Server Engineers - MSDN.com

 

 

Determining Page File Size for 64 Bit Systems

 

Discusses page file usage and management and covers the special case for 64 bit systems ... Source : Microsoft.com - Knowledge Base Article

 

 



Copyright (c) 2014 sqlCrunch.com   |  Privacy Statement  |  Terms Of Use

acheter chaussres nike air max 2014

acheter chaussures nike free run 2014