Reputation
368
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 13
Impact
~14k people reached

  • 0 posts edited
  • 0 helpful flags
  • 18 votes cast
1d
accepted High Page Faults/sec low Page Reads/sec
1d
comment High Page Faults/sec low Page Reads/sec
Thats a great link thanks. What do you think to tracking locks and blocks would this be the next logical step in troubleshooting the poor performance?
2d
asked High Page Faults/sec low Page Reads/sec
Apr
22
asked Changing the Service Account with SQL Server Mirroring
Apr
21
comment Hyper-V Dynamic Memory and SQL Server
I don't believe your remark about LPIM is correct in regards to the hypervisor grabbing back memory. My understanding is that where as previously the hypervisor would grab memory back from processes not in the buffer pool first, now that in SQL 2012 most things are in the buffer pool SQL handles the paging out to disk in a controlled manner in response to low memory events. i.e. it still pages out things from the buffer pool even with LPIM just in an optimised way now.
Apr
17
awarded  Notable Question
Apr
17
comment Hyper-V Dynamic Memory and SQL Server
Hi Sean - yes agreed I think we are going to load up the two VMs on an isolated VHost just to track their performance, then start migrating other VMs on to it and see what happens.
Apr
16
comment Hyper-V Dynamic Memory and SQL Server
Sorry for my slow response - we have decided to build two VMs and set one to static and one to dynamic and replay a SQL workload against them an monitor their performance. We will also follow the other settings in the best practice guide around min\max and startup memory and monitor the perf counters and compare. - comments welcome.
Apr
14
asked Hyper-V Dynamic Memory and SQL Server
Apr
13
accepted IO_STALL question and understanding
Mar
31
comment Kerberos and Linked Server
I have go the service account and computer objects changed to Trust this user for delegation to any Service (Kerberos only) and I still get the failed Anonymous Login problem.
Mar
30
comment Kerberos and Linked Server
OK I will get the delegation added and see how it goes.
Mar
30
revised Kerberos and Linked Server
added 184 characters in body
Mar
30
asked Kerberos and Linked Server
Mar
30
accepted CXPACKET SUSPENDED and NULL wait type
Mar
27
comment CXPACKET SUSPENDED and NULL wait type
I see, I still would have expected a wait type of some sort to have appeared in the thread doing some work though? Also whats the best way to balance the workload then, by just ensuring that you have a good indexing strategy?
Mar
26
asked CXPACKET SUSPENDED and NULL wait type
Mar
13
asked Run SSIS Package as different user
Feb
18
awarded  Popular Question
Jan
23
awarded  Popular Question