SQL Meditation

A forum for sharing what I have learned about SQL Server over many years of thought, contemplation and practice
Posts
  • SQL Meditation

    Slow I/O Mediation - SQL Server and disk I/O performance

    • 0 Comments
    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. I offer to teach you how to fish. What kind...
  • SQL Meditation

    The Tao of the Deadlock Scheduler in SQL Server

    • 1 Comments
    Just thought I would summarize the concept of a SOS Scheduler and a Deadlocked Scheduler since many have inquired over the years for a brief summary of these concepts UMS/SOS Scheduler in SQL Server Since SQL Server 7.0, SQL Server has used its...
  • SQL Meditation

    Meditation on Slow Inserts in SQL Server

    • 0 Comments
    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...
  • SQL Meditation

    "Waits, Waits, Do Tell Me" - how to analyze bottlenecks in SQL Server

    • 1 Comments
    “Waits” in SQL Server are often a major source of performance issues. "Waits" as they are known in the SQL Server world essentially indicate that a worker thread inside SQL Server is waiting for a resource to become available before it can...
  • SQL Meditation

    Tasks, Workers, Threads, Scheduler, Sessions, Connections, Requests – what does it all mean?

    • 5 Comments
    With this meditation I attempt to explain what some of the more common concepts that get used with SQL Server thread management and scheduling are. Parable: There was an all-powerful, but humble and benign Master, whom the workers revered and humbly...
  • SQL Meditation

    Meditation on SQL Trace performance Impact and Wait types

    • 2 Comments
    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...
  • SQL Meditation

    Meditation: Is IOCP listener actually listening?

    • 0 Comments
    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...
  • SQL Meditation

    SQL RPC vs. Windows RPC

    • 0 Comments
    Question : “If one executes stored procedures using the RPC events mechanism (instead of Language events ), do any additional RPC ports need to be open (as is the case with SSIS )? Configuring the Windows Firewall to Allow SQL Server Access ...
  • SQL Meditation

    "Hello MSDN World!"

    • 1 Comments
    I am not quite sure the world needs another SQL Server Blog, so I have hesitated to get one started for ... let's just say "quite a while". Finally, through some encouragement from friends and peers I decided to do it so that I could share ideas that...
  • SQL Meditation

    SQL Performance Meditation: Duration and CPU Reveal a Profound Truth

    • 0 Comments
    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...
  • SQL Meditation

    Meditation on Locked Pages in Memory and User Rights

    • 0 Comments
    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...
Page 1 of 1 (11 items)