blake colson-405790 (6/5/2010)

---

Reducing MaxDop is a classic internet text book/bandaid response which 99.999% results in unacceptable results. If you're messing with maxdop, then I'd say you're short on experience...

"but I see constant CXPACKET and PageLatch wait times"

...check the paralellism settings. Maybe think about changing it to '1'.

CXPACKET is an indication that the server is waiting for queries...

I see a lot of variety in the answers given.....

1st before doing anything with the tempdb, You should also ensure that the Windows partitions are aligned: http://support.microsoft.com/kb/929491.

Aligning the...

If you set it to single user you risk getting blocked before you can start the restore by a user or application connecting to it.

Better going the ALTER DATABASE x...

Using the SQL Configuration Manager is the recommended method

http://support.microsoft.com/kb/283811

http://support.microsoft.com/kb/911839

http://technet.microsoft.com/en-us/library/ms143746.aspx

unless there is some reason not to, application compatibility, etc, go 64bit. In the long run it'll be beneficial.

if you have a 2nd site available to you use a MNS...

Does your SQL Server service account have "Lock pages in memory" rights?

Some useful info here: http://support.microsoft.com/kb/274750

If the log file doesn't shrink immediately on running the SHRINKFILE cmd it's probably because there are open transactions preventing the log file from being shrunk. You may have run...

Vivien Xing (1/8/2008)

---

google "Geographically Dispersed Clusters". Here is MS doc http://download.microsoft.com/download/7/6/f/76f3db2f-6f43-4624-bfde-ff731e3c1f96/GDClusters.doc#_Toc87754923

EMC Geospan/SDRF has remote replication solutions for this. You may look into this.

I remember the distance...

I have worked with Majority Node Set clusters where the nodes were located in locations over 100kms form each other. This was done using mirrored SAN disks, each node writing...

Joe Clifford (11/22/2007)

---

Hmm... your error isn't really related to a "linked server" as the term usually applies. You're dynamically creating a connection to an excel spreadsheet on a UNC...

There's...

I'm looking at the "for linked server "(NULL)"" and I'm thinking that it doesn't really seem right to me.

I think Microsoft ADS would ahve been your best bet for this. Using ADS you could have deployed completely configured machines, with all OS SP's and SQL installed remotely, in...

1st Check cluster log for any errors, ensure all nodes can communicate with each other.

Logon to server 1 and run the setup and choose instance A and apply the sp...