Post Closed as "too broad" by Erik Darling, Sean Gallardy, mustaccio, Jon of All Trades, Marcello Miorelli
2 fix of subjects
source | link

My system specifications are;

  • Windows Server 2008 R2 Enterprise SP1
  • 128 GB RAM
  • Intel Xeon E5-2620 (3 processors)
  • MS SQL Server 2012 StandartStandard (11.0.2100.60)

There is 3 NumaNodes and 12 CPU's in them. 6 of them was checked. Yesterday, iI have checked all of them (12 CPU's) and after that performance issues started.

First, iI've restarted SQL Server. Problems were still going on. After that iI have restarted OS, still the same issues was going on.

At night, user called me for performance problems and i unchecked them to 6. I have restarted OS and still performance problems are going on.

When iI look resource usage on Task Manager, only 1-2 of them working on %100 performance for 1 second. 7 GB RAM used.

Do you have any suggestions?

My system specifications are;

  • Windows Server 2008 R2 Enterprise SP1
  • 128 GB RAM
  • Intel Xeon E5-2620 (3 processors)
  • MS SQL Server 2012 Standart (11.0.2100.60)

There is 3 NumaNodes and 12 CPU's in them. 6 of them was checked. Yesterday, i have checked all of them (12 CPU's) and after that performance issues started.

First, i restarted SQL Server. Problems were still going on. After that i have restarted OS, still the same issues was going on.

At night, user called me for performance problems and i unchecked them to 6. I have restarted OS and still performance problems are going on.

When i look resource usage on Task Manager, only 1-2 of them working on %100 performance for 1 second. 7 GB RAM used.

Do you have any suggestions?

My system specifications are;

  • Windows Server 2008 R2 Enterprise SP1
  • 128 GB RAM
  • Intel Xeon E5-2620 (3 processors)
  • MS SQL Server 2012 Standard (11.0.2100.60)

There is 3 NumaNodes and 12 CPU's in them. 6 of them was checked. Yesterday, I have checked all of them (12 CPU's) and after that performance issues started.

First, I've restarted SQL Server. Problems were still going on. After that I have restarted OS, still the same issues was going on.

At night, user called me for performance problems and i unchecked them to 6. I have restarted OS and still performance problems are going on.

When I look resource usage on Task Manager, only 1-2 of them working on %100 performance for 1 second. 7 GB RAM used.

Do you have any suggestions?

1
source | link

MS SQL Server Performance Issues After Enabling All CPU's

My system specifications are;

  • Windows Server 2008 R2 Enterprise SP1
  • 128 GB RAM
  • Intel Xeon E5-2620 (3 processors)
  • MS SQL Server 2012 Standart (11.0.2100.60)

There is 3 NumaNodes and 12 CPU's in them. 6 of them was checked. Yesterday, i have checked all of them (12 CPU's) and after that performance issues started.

First, i restarted SQL Server. Problems were still going on. After that i have restarted OS, still the same issues was going on.

At night, user called me for performance problems and i unchecked them to 6. I have restarted OS and still performance problems are going on.

When i look resource usage on Task Manager, only 1-2 of them working on %100 performance for 1 second. 7 GB RAM used.

Do you have any suggestions?