SQL Error Logs -- Need your input

Question

SQL Error Logs -- Need your input

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

ChrisTaylor SSCarpal Tunnel Points: 4527 More actions · Answer 1

have a look at this link, should help you calculate the size required.

IIRC, as a general rule of thumb the page file should be 1.5x size of the ram in the box......could stand corrected with this......?

_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

WasimAli SSC-Addicted Points: 423 More actions · Answer 2

Thanks..yeah that is what we came to the conclusion as well (1.5 X RAM = Page File)

However, since we upgraded from 32 to 64, it comes out to 96 GB now which is not avaiable on local system drives ...so we are trying to see if we can get it to work with 50 GB PF.

btw, even with 53 GB for SQL (max memory setting) -- it still threw some of the 'insufficient memory error logs' when the backups and other jobs ran over night.

I am going with "LOCK Pages in Memory" + 50 GB PF + Reboot ....will keep you posted with the developments.

any other suggestions w.r.to 64 BIT - Windows 2008 R2 -- Page File setup w.r.to SQL -- do send it my way.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

SQL shouldn't need to use the page file, so on a server that just has SQL, page file size isn't as cut and dried as 1.5xRAM, especially on larger machines...

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ChrisTaylor SSCarpal Tunnel Points: 4527 More actions · Answer 4

hence why i posted the link on how to calculate it

_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

WasimAli SSC-Addicted Points: 423 More actions · Answer 5

PF - 50 GB applied.

So far no 'insufficeint memory issues' noted, but it could be too early to call it a success.

Haven't restarted the SQL Server services, so the 'lock pages in memory' option is still not applied.

Thank you all for your input...maybe it was just the missing PF -- but I will wait till at least a few more days just to be sure.