SQL Server Performance

EXECSYNC?

Discussion in 'Performance Tuning for DBAs' started by Link, May 2, 2005.

  1. Link New Member

    Hi there,<br />i have a sql database server with pretty high EXECSYNC wait type - about 30%.<br />the waittype doc has only one statement on it which is Query memory and spooling to disk.<br />can anyone give me more info about it? <br /><br />thanks![<img src='/community/emoticons/emotion-11.gif' alt='8)' />]<br />
  2. deepakontheweb New Member

    Execute dbcc sqlperf(waitstats) for more informations;

    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  3. Link New Member

    the percentage (30%) is the summary of the result of dbcc sqlperf for a certain period of time.

  4. satya Moderator

    What are the memory settings for SQL and also confirm the data files location and HDD RAID levels?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. Link New Member

    it is a dedicated HP server (dual processor) for SQL with 2G memory (dynamic config) on it. files are located on raid 5 HD (data & log.) database sizes are around 10g. tempdb on separate HD with fixed 1.25g in size (can grow).
  6. derrickleggett New Member

    What are the various cache hit ratios on that server?

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  7. Link New Member

    didn't run perfmon/profiler - I only checked wait types when there was someone saying that DB server is slow. the response time is ok to me now. I'll do more dig if it shows slow again and let you know more detail.

    thanks!
  8. satya Moderator

    If it persists again then PROFILER and PERFMOn counters will help to assess further.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. Link New Member

    thks Satya.
  10. Link New Member

    forgot to let you guys know that when I'm getting the waitstats on the server, the high EXECSYNC value is not showing any more(pretty much 0 consistantly).



  11. derrickleggett New Member

    You need to be looking at perfmon and profiler. You should be doing this even if you're not getting waittimes (if you're the DBA).

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  12. Link New Member

    Hi derrick,
    since it is a production server and only one user is saying slow, my regular procedure is to get the wait types to see if I need setup counters on a test server based on where the problem is - that is why I need more info on EXECSYNC. I believe most of times wait types give you a clue quickly and fairly acurately. I do run perfmon/profiler on a production server, but as a last resource.

    thanks!






Share This Page