troubleshooting Question

SQL 2008 R2 on 64Bit Memory Configuration BEst Practice

Avatar of wyze1
wyze1 asked on
Windows Server 2008Microsoft Server Apps
1 Comment1 Solution774 ViewsLast Modified:
Hi All,

Could someone provide me with the best way to configure a Windows 2008 R2 64 bit on an HP Proliant DL380p Gen8 server with SQL Server 2008 R2?
It's a dedicated database server with 32GB RAM that is, no other applications will be on the server and it will be running most of the SQL services. I was of the opinion that I could just leave the Page File to be determined by the System but not too sure about that. As a reluctant dba (came about as a result of the last guy leaving) I'd be grateful if someone could point me in the right direction.
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros