October 27, 2009 at 3:36 pm
In the near future I will be getting a new server with 32 GB of RAM, 64-bit O/S, on which I will be installing a single SQL db-engine instance, 64-bit SQL 2008 Enterprise Edition with SQL-CLR enabled.
I wonder how I should configure the min/max buffer memory on the server, so that I leave enough MemToLeave memory for the CLR stuff to work properly.
I have quite a few of CLR sprocs and UDFs doing REGEX and FileIO operations, and I want to make sure the SQL-CLR part has enough resources to function properly.
How should I go about this? Any hints more than welcome.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 16, 2009 at 11:14 pm
I'd probably set max memory to 28GB and see how it does. The file io CLR functions are the only things that concern me. If they pull large binaries into memory you might have issues otherwise I think you will be ok..
CEWII
November 29, 2009 at 2:53 pm
If this is a dedicate database server leave 4 GB for the OS System and 28GB to database server, please enable AWE setting and lock pages in memory rights to get better performance of use memory in 64 bits system.
November 30, 2009 at 6:41 am
No need for AWE in 64-bit.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply