Post reply

SQL Server Express SP2: LONG Memory Grant Queue Wait

  • September 7, 2007 at 4:35 pm

    #374147

    I have a system (1GB Ram, 2.0GHz CPU) that I have recently upgraded from MSDE to SQL Express SP2.  I get intermittent VERY SLOW Query responses.  I ran perfmon and found an example where I had one "simple" query (select * from table XYZ) in the Memory Grant Queue Wait that took 25000ms (25 seconds!) to process. 

    The system was not under heavy or unusual load.  The disk activity was light, perfmon shows no paging, and there wasn't any unsual CPU utilization.

    Has anyone heard of a SQL Server 2005 Express memory managment or memory locking issue?

    Thanks,

    Jack

  • October 1, 2007 at 9:46 am

    #737765

    Increase the amount of memory for the DB (properties on the server) en run the command to shrink the Database to make sure that your log file is clean en run the query again.

    You can also check your diks where the DB file(s) are stored, when you disk is havy fragmented you can have a slow respons.

  • October 11, 2007 at 12:50 pm

    #741329

    The disk is not fragmented, and the log files are not too big.

    Analysis with PS shows that the OS is requesting SQL to release memory back to the OS. It appears to be taking 25 seconds to release memory and then reacquire memory for its internal buffer pool. I haven't seen this, but per PS input, the biggest delay is in releasing the memory.

    Of course, the issue is random, so 98 out of 100 times, there is no issue. Looks like a random issue with SQL Express releasing memory.

    I'm currently trying to get PS to look further, and will keep everyone posted.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply