SQL

3 Topics

SQL Wizard is unable to detect Service group
Hello Everyone, We have 2 nodes Veritas Stotage Foundastion HA 6.1 cluster. It contains one SQL Server 2012 service group. I try to modify this service group using SQL Server agent configuration wizard, but on the first step wizard is unable to detect existing SQL service group and offers just to create new one (screenshot is attached). I've tried to check wizard log but it doesn't contain any errors or warnings. Please help! P.S. OS: Windows Server 2012 VSF with HA 6.1
Galex
8 years ago Place Cluster Server
1.6KViews
0likes
1Comment
SSIS in SQL cluster
Hello all, what is the recommended configuration for SSIS in a SQL cluster? If we develop the packages on a different non-clustered instance with BIDS, do I even need to install SSIS within the cluster environment? This is on a 6.0.1 cluster environment with SFWHA.
scogeb
12 years ago Place Cluster Server
682Views
1like
0Comments
SQL memory management in active/active configuration
Hi, I willhave 4 nodes in an active/active/active/active configuration. Each node will have 3 SQL instances installed on it. Each node has 256GB RAM. I know I can set the limit each instance can use, but the more memory SQL gets, the better it runs. Ideally, I would set each instance to use 80GB or so. Roughly 1/3 of the node's memory, leaving some for the OS and Veritas. What happens if one of the nodes goes down? Where would the newly failed over instance get it's memory from? Is there a way to manage this? Should I let SQL manage it? I don't want a run-away query on one instance to hog all the node's memory though and affect the other instances on that node. What are my options?
Solved
scogeb
13 years ago Place Cluster Server
1.6KViews
0likes
2Comments