lapz_anry | SQLServerCentral

lapz_anry

Forum Replies Created

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

RE: SQL SERVER 2014 BOTTLENECK ONCE WE CHANGE NODE --FAILOVER CLUSTER--

Michael L John - Wednesday, October 18, 2017 2:01 PM
lapz_anry - Wednesday, October 18, 2017 1:45 PM

October 19, 2017 at 1:25 am

#1964315
RE: SQL SERVER 2014 BOTTLENECK ONCE WE CHANGE NODE --FAILOVER CLUSTER--

Michael L John - Wednesday, October 18, 2017 1:14 PM
lapz_anry - Wednesday, October 18, 2017 12:53 PM

October 18, 2017 at 1:45 pm

#1964279
RE: SQL SERVER 2014 BOTTLENECK ONCE WE CHANGE NODE --FAILOVER CLUSTER--

crow1969 - Wednesday, October 18, 2017 11:27 AM
First thing I would do is cap the server max memory (MB) parameter in sp_configure. ...

October 18, 2017 at 12:53 pm

#1964267
RE: SQL SERVER 2014 BOTTLENECK ONCE WE CHANGE NODE --FAILOVER CLUSTER--

crow1969 - Monday, October 16, 2017 1:48 PM
On the surface, it looks like you are having a lot of physical disk reads. ...

October 17, 2017 at 1:08 am

#1963962
RE: SQL SERVER 2014 BOTTLENECK ONCE WE CHANGE NODE --FAILOVER CLUSTER--

Michael L John - Monday, October 16, 2017 2:19 PM
When you switch nodes, the server is fast for about 2 hours, and...

October 17, 2017 at 1:04 am

#1963961

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