Post reply

SQL SERVER 2005 32-bit Performance

  • October 27, 2010 at 9:33 pm

    #230474

    We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH is always high and the procedure cache is always around 700mB. What is wrong here?

  • October 28, 2010 at 12:40 pm

    #1243778

    I would suggest check Disk IO ,Identify long running sp or queries and create indexes\stats for it, also make max dop equal to number of cpu core.

  • October 28, 2010 at 12:45 pm

    #1243782

    Currently my MaxDOP is 1

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

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