SQL 2012 + shared storage

what is the best practice for memory confirmation of SQL 2012 when the server is using shared/LUN storage?

Thanks
zero000koolAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
Is that a typo meaning memory configuration?
Could you provide detail to make the setup clearer.

Is this a clustered install? Is this an active/active setup  meaning each node will have an active instance serving a databases while the other serves up another instance with another database. One node has to handle both instances if it is the remaining node running.
In this scenario the SQL instance can only be allocated as much memory leaving space for the OS as well as the other instance if it were to failover to this node.
0
zero000koolAuthor Commented:
No this is not a clustered environment.  This server is going to be a test server so it will be a stand alone server.

The SQL server will be virtual using Hyper-V.   This will be a single instance.
0
arnoldCommented:
I do not understand what your question is.

Do you mean what is the memory configuration for the VM ?
Physical system spec, presumably the shared storage/lun will be from hyper-v host or is it going to be from a SAN outside the host?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

zero000koolAuthor Commented:
All I am asking for is, I am building a SQL server in a test environment.
What is the best practice for configuring proper memory management for the SQL server.

-- It will have shared storage
-- SQL 2012 R2
-- Server 2012 R2
-- It will not be clustered, it will be stand alone server.
0
arnoldCommented:
Unfortunately, I do not understand what you are asking. You should hit the request attention to have others notified of your question who might understand what you are after.
 You need to provide the physical system's available resources which will be functioning as the host and the "slated activity" growth rate, db size.
I understand you are building a test, but even in a test environment you have to frame the conditions for which you are allocating resources.
0
arnoldCommented:
SQL is highly memory/Io based application. Configuration of the system is to prioritize network, memory as an application server. Properties of computer, advanced settings, advanced, performance settings, advanced.
Optimally, you want to have memory as much or larger than the combined databases that it serves.

The VM should have two separate paths (tied to two separate network interfaces, one for the query access and the other for the access to the storage.

SQL has an iosql and similar tools which you can use to test the storage IO.

You should hit the request attention to request that others be notified of your question.
0
Deepak ChauhanSQL Server DBACommented:
@What is the best practice for configuring proper memory management for the SQL server.

Which edition of SQL server you are planning ?

SQL server Standard edition support up to 64 GB memory.
Enterprise 2 TB
Express 1GB

You are planning to install SQL 2012 in Pilot environment. Will other memory consuming application be run on the same server.

Initially you can leave 25% of the total system memory for the OS to handle other request and process. This setting can be change anytime after installation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
what is the best practice for memory confirmation of SQL 2012 when the server is using shared/LUN storage?
There's no relation between the storage and memory configuration.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.