Settng Memory Sql Server 2005 SP2 64Bit

20 pts.
Tags:
SQL Server
SQL Server 2005
SQL Server performance
Hi I've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

Answer Wiki

Thanks. We'll let you know when a new response is added.

There are a couple of numbers you can try.

A lot of people like setting SQL Server to use 1 Gig less than the physical memory, so in your case 11 Gigs. This leaves 1 Gig for Windows and anything else running on the server. If you have a lot of very complex SSIS packages or are running other services then you will need to leave more RAM for them.

About a year ago Microsoft begun recommending that you set SQL to use 75% of the amount of memory in the server. So in your case this would be 9 Gigs.

What else will be installed on the server?

Ok i will try ,because there is only Sql Server, in your opinion if i set DB recovery mode set Bulk-logged,it is better then simple mode?for optimize performace?

Thanks

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,335 pointsBadges:
    report
  • Jerry Lees
    Good information, Denny. I've pinned your blog too. Look forward to reading it!
    5,335 pointsBadges:
    report
  • Denny Cherry
    Bulk-Logged and Simple mode will give you the same performance. Changing the recovery mode doesn't change how fast the system runs. It simply changes what your options are for recovering the database are.
    66,335 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following