Reputation
811
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
9 16
Impact
~28k people reached

Apr
4
awarded  Popular Question
Mar
29
awarded  Notable Question
Feb
2
awarded  Yearling
Dec
17
accepted Update an Indexed View “Online”
Dec
17
asked Update an Indexed View “Online”
Dec
16
asked Indexed (Materialized) View for Parent and Newest Child
Oct
23
awarded  Popular Question
Oct
7
comment Using RowLock to enforce Once-And-Only-Once
That is great! Thanks!
Oct
7
accepted Using RowLock to enforce Once-And-Only-Once
Oct
6
revised Using RowLock to enforce Once-And-Only-Once
deleted 30 characters in body
Oct
6
asked Using RowLock to enforce Once-And-Only-Once
Sep
29
comment How can I Debug a Buffer Issue?
@AaronBertrand - If that happens I will adjust at that time. As 'usr' said in the question comments, most of my data is cold. The amount of data that is heavily transacted is just the most recent stuff. I think that is why I am able to see high performance with as little memory as I have. Also a large portion of that data is partitioned so that the cold stuff is separate from the recent stuff. Either way, for now, performance is much better and PLE averages around 3500. While I believe that this "bug" was the cause of my problems, I thank you for the time you spend on my issue!
Sep
29
comment How can I Debug a Buffer Issue?
After installing SP2 my PLE is over 2000 95% of the time.
Sep
29
accepted How can I Debug a Buffer Issue?
Sep
28
comment Buffer Size Changing?
After installing SQL Server 2012 SP2, my PLE is above 2000 almost all the time! Thank you for pointing me to this! I asked a related question (about how to debug this issue) over here: dba.stackexchange.com/q/115671/6383 If you like, you could post that the issue is not with configuration, but rather a bug in SQL Server 2012 (like you did here) and I would change the accepted answer. (If not, I will just post it myself.) Thank you again! This fixed a very frustrating issue!
Sep
24
accepted Buffer Size Changing?
Sep
24
comment Buffer Size Changing?
I am going to. I tested the three things that KB indicated (sharp PLE drop, lazy writes (when it drops) and sharp rise in free memory (again, when PLE drops). All were present for my server. I am betting that is it.
Sep
23
comment Buffer Size Changing?
Looks like I am on an old enough version that I need to look at that bug (and updating to SP2):
Sep
22
awarded  Inquisitive
Sep
21
revised How can I Debug a Buffer Issue?
added 1286 characters in body