SQL Server 2008 R2 running very slowly after Hardware upgrade

  • vladimir.guerreiro

    SSC Enthusiast

    Points: 140

    Hi,

    In my company, we have a SQL Server 2008 R2 Cluster, a few days ago, we doubled the CPU and memory of one cluster node.

    We have 1 HP BL680C G7 with 2 Intel Xeon X7550 2Ghz and 64Gb RAM.

    We doubled this hardware, now we have 64 Logical Processors and 131Gb RAM.

    The problem is, my server is VERY slowly, I have to set SQL Server to use just 2 processors and 60Gb RAM, and this way, it works.

    My doubt is, we need to configure or execute something to make SQL use all new hardware?

    Thanks.

    Guerreiro.

  • Devendra (Dev) Shirbad

    SSC-Forever

    Points: 42488

    SQL Server Performance Tuning is a big chapter / book in itself. There is no straight answer for your question because it depends on various factors (hardware/software/OS/networking etc.). If you are uncomfortable in doing it, please hire a professional to assist you.

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    +1 for the consult

    but if you have some spare time (maybe 1 week), it can be done online with a LOT of back and forth.

  • Dugi

    SSCoach

    Points: 17998

    Seems, time for the consultancy or reading and searching lot of stuff about Performance ...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • padhis

    SSCommitted

    Points: 1762

    This may help you to narrow down performance issue by following hardawre performance checklist.

    http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/#_Toc209585605

  • vladimir.guerreiro

    SSC Enthusiast

    Points: 140

    Hi everyone,

    My problem was solved, when my infrastructure team made the upgrade, beyond the memory and CPU, they have included a cache plate, that was malfunctioning, they substituted e now is OK.

    Thanks a lot by the help.

  • vladimir.guerreiro

    SSC Enthusiast

    Points: 140

    Guys,

    Just to give fair closure to this topic, wasn't just the cache the problem.

    In fact, our infrastructure team just forgot to upgrade one windows server to SP1, so, this cause a huge performance problem in our structure.

    So, if you are a DBA, just double check a few points by yourself.

Viewing 7 posts - 1 through 7 (of 7 total)

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