I would very strongly reccomend againt setting up a cluster using two production servers. You have no test environment. ...

Do you have a SAN or shared external array? You need one or the other for a cluster.

Do you have any baseline to know the average number of transactions that you should get?

You may want to run SQL Profiler and see what is happening.

pankaj.baluni (4/6/2010)

---

ok...

so please answer my first question that

if i have active/active clustering up & running in the production site between server 1 and server 2 then can I put...

pankaj.baluni (4/6/2010)

---

How Database gets updated on the secondary instance if I have Active/PAssive clustering setup.

Let's say I have 2 servers at 2 different locations (one is Production and another is...

There is no way to answer that given the information that you provided. It would be helpful to know what is being inserted, the size of the existing table,...

Jeff Moden (4/5/2010)

---

Heh... that's been the subject of many a heated debate. My experience has been that people with certifications haven't learned...

Upgrading hardware has always been the easiet solution 🙂 I've worked at a place that purchased a 64 core (32 proc's) IA-64 cluster with 256GB of RAM active/passive cluster...

Here is the way I have done it with Block-Level SAN Replication

1) Create a DNS Alias for the Server

2) The DR server is always up

3) the system DB's are *not*...

GSquared (4/5/2010)

---

A lot of the answers to your questions will depend on your local job market.

For example, there are a lot of jobs where I am that don't require any...

Another thing to really keep in mind, bearing in mind that I don't know what your prupose is. It's also wise to know the NetBIOS hostname of the client....

If it's a dedicated SQL Server, the OS does not need more than 1-2GB

declare @IPAddress as varchar(15)

declare @data XML

set @data = EVENTDATA()

set @IPAddress = @data.value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(15)')

You can also login using SQLCMD, then drop the trigger.

Logging in using SQLCMD bypasses the trigger, I have had to do it dozens of times when things go wrong.

SQL does not care one lick what the volume is named. You can go in right now and rename it and won't see any difference.

Since the C drive seems...