Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 R2 running very slowly after Hardware upgrade Expand / Collapse
Author
Message
Posted Tuesday, January 10, 2012 6:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 2:28 PM
Points: 10, Visits: 84
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.

Post #1233108
Posted Tuesday, January 10, 2012 6:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 6:53 PM
Points: 1,932, Visits: 1,589
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.

Dev

Devendra Shirbad | BIG Data Architect / DBA | Ex-Microsoft CSS (SQL 3T)
*** Open Network for Database Professionals ***

LinkedIn: http://www.linkedin.com/in/devendrashirbad
Post #1233115
Posted Tuesday, January 10, 2012 6:18 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Monday, September 22, 2014 6:13 AM
Points: 20,578, Visits: 9,618
+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.
Post #1233117
Posted Wednesday, January 18, 2012 7:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
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/
Post #1237950
Posted Wednesday, January 18, 2012 7:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 3:57 AM
Points: 91, Visits: 125
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
Post #1237958
Posted Wednesday, January 18, 2012 10:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 2:28 PM
Points: 10, Visits: 84
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.
Post #1238137
Posted Tuesday, March 6, 2012 6:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 23, 2013 2:28 PM
Points: 10, Visits: 84
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.
Post #1262134
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse