SQL Server 2008 R2 running very slowly after Hardware upgrade

Question

SQL Server 2008 R2 running very slowly after Hardware upgrade

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

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

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

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 More actions · Answer 2

+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 More actions · Answer 3

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 More actions · Answer 4

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 Veteran Points: 200 More actions · Answer 5

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 Veteran Points: 200 More actions · Answer 6

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.