Mid-Year Review, Career, and Getting Ahead

Note: This article is updated at Getting Ahead in Your Career. Mid-year is always a hot time at Microsoft.  It’s a time to recap the impact and check the scoreboard.  For some, it’s a time to shine.  For others, it’s a wake up call.  And for others, it’s Phoenix time. I think between the slowing…


SQL Performance Meditation: Duration and CPU Reveal a Profound Truth

Have you wondered if there is a simple way to find out if a query is slowed down by bottlenecks? Looking at the Duration (Elapsed Time) and CPU (Worker Time) reported by a completed query can reveal the answer. See, Duration/Elapsed Time indicates the overall lifetime of a query, while CPU shows only the time…


Meditation: Is the IOCP listener actually listening?

What is the IOCP Listener? The IOCP listener is a dedicated system thread that accepts incoming connections to SQL Server. It is a SQL Network Interface (SNI)-layer thread that listens for TCP/IP sockets or Named Pipes traffic (VIA is going away but still in the code). When a connection comes in, the listener accepts it…


Meditation: Locked Pages in Memory and User Rights

A colleague had the following question not too long ago Question: Does SQL Server check for “OS permissions” such as Locked Pages In Memory (LPIM) and if so does it use the Windows “macro-style” constants for them – such as SE_VOLUME_MANAGE? The reason I ask is that I’m still wanting to determine “major things” that…


Meditation: SQL Trace performance Impact and Wait types

  Is SQL Trace,  or SQL Profiler,  or any other 3rd party tracing tool impacting SQL Server performance? The DBAs often contemplate this issue when they want to get insight from their SQL Server. Essentially the tracing mechanisms in SQL Server will present themselves as a bottlenecks (waits). See, when a SQL worker thread is…


Meditation: Slow Inserts in SQL Server

This SQL Meditation contemplates on some common reasons why INSERT statements are taking a long time (slow) 1. Each Insert in a large batch is causing a log flush thus causing waiting Is each insert a separate transaction or are those grouped in a transaction? If you review KB 230785 you will notice the section “Increasing performance”…


Slow I/O – SQL Server and disk I/O performance

This SQL meditation provides a general approach on how to troubleshoot SQL Server I/O related issues. My belief is that if you truly understand this, you are empowered to solve the disk I/O challenges yourself.    Define slow disk performance: The metric commonly used to measure slow I/O performance is the metric that measure how…


Troubleshooting an IIS Add Roles and Features error

This articles has been moved to its new home here: https://benperk.github.io/msdn/2012/2012-12-troubleshooting-an-iis-add-roles-and-features-error.html It is common to install or uninstall Web Server features.  You need these features to execute ASP.NET pages, perform logging, authenticate user requests, etc….  Figure 1 shows a sub-set list of features which you may choose to install. Figure 1, Add Roles and Features list, small…


How to capture a memory dump of a W3WP process that consumes too much CPU

This article has been moved to its new home here: https://benperk.github.io/msdn/2012/2012-12-how-to-capture-a-memory-dump-of-a-w3wp-process-that-consumes-too-much-cpu.html If you want to find out why a W3WP worker process is consuming so much CPU, you can use ProcDump.  You might also use LogParser to look at the time-taken field, but to get to the root cause you will need to get deep into the…


Recreate Event Viewer logs

This article has been moved to its new home here:  https://benperk.github.io/msdn/2012/2012-12-recreate-event-viewer-logs.html If you ever receive “the event log file is corrupted” on Windows 2008 R2, try the following list of actions to fix it.  Following these steps result in the recreation of the event logs. 1.  Open a command as an Administrator and enter “NET STOP…