Re: Recommended Max Memory for SQL - MSFW, WSUS, SBSMonitoring, SharePoint
- From: "wdsnews" <wdsnews.0640@xxxxxxxxxxxxxx>
- Date: Tue, 10 Jul 2007 11:03:10 -0700
Susan,
Thank you. That blog was very helpful to me. I suppose the good news about
new technology is it's more forgiving of by-gosh-guesses. But you and I
come from a time when a blind guess often punished us for not fully
understanding. So it's hard to surrender to by-gosh guesses even though
they seem to work these days. Thank you for the numbers.
"Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@xxxxxxxxxxx>
wrote in message news:OLoSbwDwHHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
Allocated Memory - what's the max/min values? - E-Bitz - SBS MVP the
Official Blog of the SBS "Diva":
http://msmvps.com/blogs/bradley/archive/2007/07/06/allocated-memory-what-s-the-max-min-values.aspx
Cris Hanna [SBS-MVP] wrote:
Adjusting the memory of the database is like doing a tune up of a race
care
You select a base number, based on the amount of RAM in your box and what
the SQL server is doing
Then you query users on performance of the application and you monitor
the SBS box
If they say its running fine...back it down abit...is it still running
fine?
If they tell you from the start that its bad...bump it up...how is it
now...and so on
Its a painstaking process to find the sweet spot.
.
- References:
- Re: Recommended Max Memory for SQL - MSFW, WSUS, SBSMonitoring, SharePoint
- From: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]
- Re: Recommended Max Memory for SQL - MSFW, WSUS, SBSMonitoring, SharePoint
- Prev by Date: Re: slow disk response
- Next by Date: Re: slow disk response
- Previous by thread: Re: Recommended Max Memory for SQL - MSFW, WSUS, SBSMonitoring, SharePoint
- Next by thread: Re: slow disk response
- Index(es):
Relevant Pages
|