Monthly Archive: June 2015

ZFS reading material

Comparing ZFS, traditional RAID and mirroring:

The great thing about ZFS for home servers is that it gives you the power of RAID without the need to pay for expensive RAID-cards. In fact, the RAID options offered by ZFS rival those of really big, powerful and expensive enterprise disk systems! And all that with cheap, consumer-grade disks.

Ten Ways To Easily Improve Oracle Solaris ZFS Filesystem Performance:

ZFS can be a very fast file system. ZFS is mostly self-tuning and the inherent nature of the algorithms behind ZFS help you reach better performance than most RAID-controllers and RAID-boxes – but without the expensive “controller” part.

Frequently Asked Questions About Flash Memory (SSDs) and ZFS:

Here’s a collection of frequently asked questions about flash memory (also known as solid state disks, or SSDs) and ZFS, with answers and some useful links, and an index, too.

And lastly:

ZFS Best Practices Guide

Memory Pressure in SQL Server 2012

I have been working on a SQL Server 2012 database project using Folding@home data pulled from here every hour. As a part of that project I’ve been working on performance tuning my queries to be responsive enough to run from a public web page dynamically and I’ve been digging into memory optimizations and the concept of memory pressure- simply the amount of work the physical RAM in your server is having to do and whether or not it is a bottlenexk in the optimal performance of your application. Here are some quick cliff notes about some memory metrics to watch:

Total Server Memory / Target Server Memory Ratio
This measurement should be at around 100% once the steady state is reached.

Page Life Expectancy
Several authorities on the subject, including SQL Server’s Customer Advisory Team (CAT) [3], indicate that the value for this counter should be at least 300 for OLTP applications. SQL Server’s CAT also indicates that values for this counter should never quickly drop by 50% or more.

Buffer Cache hit ratio
OLTP applications it should equal or exceed 98%

Page reads / sec, Page writes / sec and Lazy writes / sec Measurements
If Lazy writes/sec is consistently experiencing non-zero values with a low PLE and elevated values for Page reads/sec and Page writes/sec the server is experiencing buffer pool contention and you will need to go about troubleshooting this problem further.

Memory Grants Pending
SQL Server Customer Advisory Team recommends that the value of this measurement should always be less or equal to 1.

Clipped from:
http://solutioncenter.apexsql.com/top-sql-server-memory-pressure-counters/

Re-synchronizing Windows passwords with the “Stored User Names and Passwords” tool

Recently I was having a problem on a Windows 7 PC where Outlook 2013 would randomly ask me for a password to connect to an Exchange mailbox. No matter what I did, I couldn’t get it to remember the new password and ticking the checkbox to remember the password did nothing.

I used this command:

%windir%\system32\rundll32.exe keymgr.dll, KRShowKeyMgr

from a command prompt to open the “stored user names and Passwords” tool where I could edit the credential directly.