EXECSYNC?

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 />

Execute dbcc sqlperf(waitstats) for more informations;

Deepak Kumar

--An eye for an eye and everyone shall be blind

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

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).

What are the various cache hit ratios on that server?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

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!

thks Satya.

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).

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.

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!