10,586 reputation
52458
bio website maxvernon.tel
location Canada
age 45
visits member for 2 years, 4 months
seen 11 hours ago

Max Vernon is an independent consultant operating in the SQL Server and Microsoft.Net spaces. He has reasonable rates, and is open to engagements world-wide.

profile for Max Vernon on Stack Exchange, a network of free, community-driven Q&A sites
DBA.se all time rank

Join me on LinkedIn at http://www.linkedin.com/pub/max-vernon/23/a0/598
I'm on Twitter at: http://twitter.com/max_vernon
Check my Flickr photo stream: http://flickr.com/photos/max_vernon

My careers 2.0 profile is at http://careers.stackoverflow.com/maxvernon


2d
reviewed No Action Needed Update Trigger in MYSQL
2d
reviewed No Action Needed Is it advisable to use a temp table when the stored procedure could be run simultaneously by different users?
2d
reviewed Close Creating a db for time slots in a day
2d
reviewed Close How to Shift a column up in a ring buffer?
2d
reviewed Close Phantom vs. Non-repeatable read
2d
reviewed Close GROUP BY Returning Different Totals
2d
reviewed Leave Open Is there a SELECT statement to subtract rows of the same column?
2d
reviewed Leave Open A way to clear/restart virtual memory creep automatically?
2d
reviewed Close Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
2d
reviewed Leave Open Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?
2d
reviewed Leave Open Backup Database Task - What's the number at the end of the filename?
2d
reviewed Leave Open Improving a search query
2d
reviewed Close What could be resons for slow performing application
2d
reviewed No Action Needed Remove dupes from joins
2d
reviewed Looks OK Suspended query causing high CPU usage
Dec
13
comment Which keyword i should use?
I1 INNER JOIN I2 ON I1.A = I2.A AND I1.C = I2.C
Dec
12
comment How can you tell if a SQL Server instance max'ed out bottleneck is CPU or Memory?
Why is this server only 8GB? Seems pretty low. How much data?
Dec
11
answered What is a deterministic method for evaluating a sensible buffer pool size?
Dec
11
comment What is a deterministic method for evaluating a sensible buffer pool size?
Also, looking at PLE compared to the max server memory setting is kind of a chicken-and-egg thing; the lower the max server memory setting, the lower the minimum "acceptable" PLE would be, so I could get stuck in an ever-lowering spiral. I'm sure, as you mention, the user performance will at some point be affected.
Dec
11
comment What is a deterministic method for evaluating a sensible buffer pool size?
Good points, Brent. I was asked to see if some servers are over-provisioned because we pay for memory per GB per year. Many of the instances I'm looking at have what I consider to be a very small amount of RAM in max server memory (mb), and as such I'm pretty reluctant to down-size them. However, some other instances have 1,000,000 + PLE, and as such are pretty obvious potential candidates for a drop in RAM. Clearly, lowering RAM will cause an increase in IOps, and I'm not sure what the cost of that will be.