Viewing 15 posts - 76 through 90 (of 211 total)
Jeff Moden (3/14/2013)
allmhuran (3/14/2013)I'm not sure what happened to this forum, the level of courtesy and respect seems to have dropped off. Perhaps it has become too cliquey.
Nah... don't let...
March 14, 2013 at 9:08 pm
Ah, well that's interesting. I am seeing performance degradation with the PLE drops as well as the movement of other related counters (eg disk % jumping to 100,000%... yes... one...
March 14, 2013 at 5:00 pm
TheSQLGuru (3/14/2013)
March 14, 2013 at 4:58 pm
Hm, some more weirdness.
SELECT
database_id, COUNT_BIG(*) / 128 as bufferMB
FROM sys.dm_os_buffer_descriptors
...
March 13, 2013 at 8:31 pm
Yes, it's an odd one eh. I'll let you know if we get anything out of premier support.
My last action was to fail over the instances due to the hotfix...
March 13, 2013 at 6:05 pm
I've been watching PLE closely on our new 2012 box (see thread: PLE drops to sub 10 on 128gb server). Grabbing two nodes and graphing them over several days shows...
March 13, 2013 at 12:23 am
Just an update for any curious observers:
I've installed a hotfix because we were experiencing the msiexec issue ( http://support.microsoft.com/kb/2793634 ), so right now (after failover, install, reboot,...
March 9, 2013 at 6:22 am
SQLRNNR (3/8/2013)
Which Patch level of 2012 are you running?RC0
RTM
or SP1?
No VM involved (mentioned earlier but easy to miss).
Version is 2012 SP1. I will be installing CU2 this Saturday night.
It's funny...
March 8, 2013 at 9:28 am
Gail,
I appreciate your help, I get the impression you are finding this frustrating. Obviously I don't pretend to think that anyone here is obligated to provide assistance. I'm sensing a...
March 8, 2013 at 5:55 am
GilaMonster (3/8/2013)
allmhuran (3/8/2013)
GilaMonster (3/8/2013)
sys.dm_os_wait_stats
Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.
Yep, that's kinda the point I'm making...
March 8, 2013 at 5:25 am
GilaMonster (3/8/2013)
sys.dm_os_wait_stats
Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.
Yep, that's kinda the point I'm making by noting...
March 8, 2013 at 5:13 am
All SQL baby!
The next highest memory consumer (right now, per resource monitor) is the DTS service with a commit charge of 353 meg (this is a 2 node clustered...
March 7, 2013 at 10:52 pm
I haven't been tracking PLE by node before now, but the max I've seen for the buffer manager counter is plenty high: 50,000.
If I graph the this counter over the...
March 7, 2013 at 10:41 pm
SQLRNNR (3/7/2013)
NUMA - did you make any changes to CPU affinity or is the default setting still active (SQL...
March 7, 2013 at 10:35 pm
Hardware reserved set at 64
CPU use is way down at 5 - 15%.
March 7, 2013 at 10:17 pm
Viewing 15 posts - 76 through 90 (of 211 total)