0
votes
1answer
39 views

How do I know which node in a cluster answers?

I have set up an NLB with two servers (nodes) which are running the same service. The filtering is single host, because I don’t want them to run at the same time, because there is data in the cache ...
0
votes
1answer
156 views

HA Options for Windows Servers

We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all ...
0
votes
1answer
78 views

SQL Server 2008 instance's listening on mulitple ports on a cluster [closed]

I have three SQL Server 2008 instances running on a cluster. SQLInstance1 is listening on default port 1433, SQLInstance2 is listening on port 39999 and SQLInstance3 is listening on port 49999. Can ...
2
votes
1answer
203 views

Should a SQL Server tempDB partition be shared by the cluster?

We have a 2-node SQL Server 2008 RS cluster. The data and log partitions are shared among the cluster nodes. Does the tempDB partition need to be shared as well, or will local server node storage ...
0
votes
2answers
40 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
0
votes
3answers
261 views

“Virtual” shared storage for SQL Server 2008 R2 Cluster

I am trying to set up a virtual test environment for a SQL Server 2008 R2 Cluster (2 nodes) running on Hyper-V. The cluster requires a shared storage to function properly, however in this test ...
0
votes
1answer
304 views

Is it possible to install SQL instances with different Collations in a SQL Cluster

We have a two node active-active SQL Server 2008 Cluster. Running on Windows Server 2008 R2. The three excisting instances have Latin1_General_CI_AS as the Server Collation. I need to add an instance ...
0
votes
2answers
311 views

Is it possible to set up multiple named instances running on a SQl Server 2008 R2 Active/Passive Cluster?

I'm trying to plan a SQL Server 2008 R2 2 node Active/Passive failover cluster. Is it possible to set up multiple named instances running on the cluster? e.g. sqlcluster sqlcluster\demo ...
1
vote
2answers
324 views

SQL + Hyper-V cluster on the same hardware

We have 5 new Windows (2008 R2) servers on our disposal. We plan to configure them this way: 3 web servers running IIS and DFS-replication (load balanced) 2 SQL servers running SQL server 2008 R2 in ...
0
votes
1answer
98 views

SP2 install on A\P fail-over cluster for SQL2008 & Win2008 - How to?

Any recommendations and any known issues with installing SP2 for SQL2008 on Win2008 fail-over Active\Passive Cluster? And the best procedure to get this done with minimum downtime? Replication and ...
0
votes
1answer
667 views

sql server 2008 cluster hang when a heavy load is run

we have a sql server 2008 active/active cluster running on wondows 2008R2 O/S. 14GB RAM, 4xCPU. we have set a ceiling of 12GB for sql server. We're running an agent job which loads 3 million records ...
0
votes
3answers
2k views

Failover clustering: tempdb on SAN?

We are considering clustering our SQL Server 2008 EE instances. The storage is on SAN. Can we put tempdb data/log files on SAN? What are the pros and cons on this solution? For optimal performance, ...
4
votes
1answer
424 views

SQL Server 2008 R2 100% availability

Is there any way to provide 100% uptime on SQL Server 2008 R2? From my experience, the downtimes for the different replication methods are: Log Shipping: Lots (for DR only) Mirroring w. NLB: ~ 45 ...
0
votes
1answer
110 views

SQL Server 2008 setup issue

I am setting up SQL Server 2008 fail over cluster on Windows Server 2008 Enterprise. I met with the following issue during setup process. Here is detailed message, any ideas what is wrong? The ...
4
votes
3answers
305 views

SQL Server 2008 Fail-over Cluster

I am using SQL Server 2008 Enterprise and I want to install SQL Server 2008 fail-over Cluster. I am wondering, (1) do I need an active directory domain? (2) what is the minimal number of machines do ...
1
vote
5answers
2k views

Best way to improve disk performance (SQL Server 2000)

I am having some disk access issues on a web application. The main load is many concurrent inserts/updates/selects on large tables. It is currently a single 2ru rackmount running SQL Server 2000 and ...
1
vote
1answer
697 views

Boost SQL Server priority: should it be used?

I'm trying to optimize my SQL Server 2008 instances on Windows cluster (on Windows Server 2008). I'm having several SQL Server instances on two cluster nodes. I was thinking that should I enable the ...
0
votes
2answers
536 views

Problem with installing SQL Server 2008 SP2 on Win XP

I'm not much of an IT person but I've been struggling with this issue for hours and I hope maybe someone here will know how to assist me. I've just installed SQL Server 2008 Developer, I've chosen the ...
1
vote
3answers
144 views

High Availability on SQL Server (Suggestions)

We have a database intensive Java application. The DB we use is SQL Server 2008. We are thinking of shifting our Java application to a 2-3 node load-balancing cluster. We have frequent application ...
1
vote
2answers
484 views

Cluster setup recommendation for a Java-WebSphere-SQL Server application

We currently have a Java based web application that runs on WebSphere and accesses SQL Server 2008. The application requires frequent code and file changes and hence we update the EAR files in ...
2
votes
2answers
11k views

Does Windows Server 2008 R2 standard edition support cluster?

I want to install sql server 2008 r2 edition in a cluster environment. Can I use Windows Server 2008 R2 Standard edition? Thanks.
2
votes
3answers
243 views

MSSQL Two Database Servers 1 Database

We have two servers. They are both HP DL 380 G6 servers with the same hardware and specs running Windows Server 2008. Currently the second server is a warm standby for the first with an automatic fail ...
3
votes
2answers
3k views

SQL 2008 R2 Clustering options

I am looking to setup SQL 2008 R2 clustering on Windows Server 2008 R2. Can someone give me some options available for installing SQL Server clustering or best practices? I thought SQL had ...
3
votes
6answers
1k views

SQL Clustering on Hyper V - is a cluster within a cluster a benefit

This is a re-hash of a question I asked a while back - after a consultant has come in firing ideas in to other teams in the department the whole issue has been raised again hence I'm looking for more ...
1
vote
1answer
847 views

Add second ip address to an existing SQl 2008 failover clustering

I have a failover cluster on Windows Server 2008, with SQL server 2008. On each server I have two network cards, with two different networks. One is on 10.10.10.x and the other is on 192.168.99.x I ...
1
vote
1answer
203 views

Run a script prior to start of SQL instance via Windows clusters

We have a Windows 2008 cluster with several SQL 2008 instance. We would like to run a script that modifies 4 registry keys prior to the startup of SQL. I do not know if there is a way to have a ...
1
vote
2answers
760 views

Two clustered SQL instances on one cluster - same port 1433?

Can two clustered SQL instances on a 2003 windows cluster use the same 1433 tcp port setting reliably? It seems to be up and working right now.
2
votes
2answers
801 views

SQL Cluster install on Hyper V options

I've been reading up on running a SQL Cluster in a Hyper V environment and there seems to be a couple of options: Install guest cluster on 2 VMs that are themselves part of a fail over cluster. ...
3
votes
2answers
986 views

Hardware Requirements of SQL Server Clustering

My task is to do clustering in SQL Server 2008. What are the hardware requirements for windows clustering? Is either SCSI or SAN compulsory, or is shared disk enough? I can't understand the hardware ...
1
vote
2answers
138 views

SQL 2008 Clustering

I need to configure SQL or Windows 2008 Clustering to get HA with no packet loss. I configure my SQLcluster, but when I restart one node, I lose one ping. I try to lose no ping so that my query will ...
0
votes
2answers
214 views

SQL 2008 in Clustering can run on simultaneous database?

With SQL cluster 2008, can we run two SQL servers simultaneously on the same database? The real question was, is it possible to load balance query on multiple SQL server for the same database
1
vote
0answers
650 views

SSL Thumbprint Registry setting for SQL Server 2008 clustered on Windows Server 2008

I'm deploying an active/passive, two node fail over Windows Server 2008 cluster to support a SQL Server 2008 instance. I'm attempting to configure SQL Server to use a certificate issued by my domain's ...
1
vote
1answer
768 views

SQLServer 2008 FailOver and Load Balancing

I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the project a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer ...
1
vote
3answers
2k views

How to install sqlserver2008 failover cluster on windows2003 server?

Can any one give me the procedure to create a failover cluster on windows2003??? Any links would also be helpful..... I got warning messages on MSDTC such that MSDTC is not running on local machine. ...
0
votes
3answers
2k views

Memory settings for multi-instance failover clustering

When using multi-instance failover clustering (used to be called active-active) in SQL Server 2005 and 2008, I'd like to know what you configure the min and max server memory to. For a two-node ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
2
votes
3answers
635 views

What issues are there installing a SQL 2008 on Win 2008 cluster?

As we all know, the cluster setup, maintenance, and underlying mechanisms have been changed extensively for SQL 2008 compared to 2005/2000. Although this fell under the Storage Engine group I was ...