SQL Server 2008: Memory Benchmarks

Hi Britt

In the normal configuration, SQL Server will use as much memory as it can get its little paws on, until it runs out of memory on the machine, or reaches the point of holding your whole database in memory. That’s an ideal situation, actually, if you can put enough memory in the machine.  

You can limit it, and you probably should leave some inaccessible, but SQL server normally plays well with the other children, and will give up memory to other processes if they ask nicely, so it’s not a real issue. And the more memory SQL Server can grab, the better it will perform, because it will hold more data in memory for fast access..

Ken McSwain Business solutions Manager

kmcswain@sydneyoperahouse.com

T+61 2 9250 7876  F+61 2 9251 7821  M 0418 659 360

SYDNEY OPERA HOUSE BENNELONG POINT

GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

SYDNEYOPERAHOUSE.COM

Any one out there have any benchmarks for how much memory SQL Server uses on your Tessitura servers? We are running SQL Server 2008 R2, and the memory usage seems really really high!

Also, any configuration tips for SQL to more efficiently utilize its memory?

Thanks,

Britt

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Britt

In the normal configuration, SQL Server will use as much memory as it can get its little paws on, until it runs out of memory on the machine, or reaches the point of holding your whole database in memory. That’s an ideal situation, actually, if you can put enough memory in the machine.  

You can limit it, and you probably should leave some inaccessible, but SQL server normally plays well with the other children, and will give up memory to other processes if they ask nicely, so it’s not a real issue. And the more memory SQL Server can grab, the better it will perform, because it will hold more data in memory for fast access..

Ken McSwain Business solutions Manager

kmcswain@sydneyoperahouse.com

T+61 2 9250 7876  F+61 2 9251 7821  M 0418 659 360

SYDNEY OPERA HOUSE BENNELONG POINT

GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

SYDNEYOPERAHOUSE.COM

Any one out there have any benchmarks for how much memory SQL Server uses on your Tessitura servers? We are running SQL Server 2008 R2, and the memory usage seems really really high!

Also, any configuration tips for SQL to more efficiently utilize its memory?

Thanks,

Britt

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!