Link to home
Start Free TrialLog in
Avatar of Len Kally
Len KallyFlag for United States of America

asked on

SQL 2012 + shared storage

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

Thanks
Avatar of arnold
arnold
Flag of United States of America image

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.
Avatar of Len Kally

ASKER

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.
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?
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.
SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.