Shark Energy (6/5/2011)

---

We have 2 larger databases that had their logs moved to a virtual drive as they were too big.

During a recent outage the physical server was brought back...

PhilipC (6/5/2011)

---

I'm not much of a disk expert at all, and after requesting a new server by the SAN administrator for split Data and Log drives he came back with...

tfeuz, you have been going round-and-round on this problem for EIGHT days now! Forums are not very useful for this type of extremely complex problem resolution. I bet...

Get a copy of sp_whoisactive (amazing freebie from Adam Machanic found on sqlblog.com) and check for tempdb usage, IOs, query plan, etc. Parameter sniffing could be at fault here...

Does that mean you are afraid it will harm performance of server (it won't)...

This one has two possible solutions.

First, put the necessary join/output columns from the T4 and T5 tables into a temporary TABLE (not table variable). Then join to...

ken.herring (6/2/2011)

---

We have recently converted an Active/Passive cluster to an Active/Active cluster (SQL2005). I understand that if one of the nodes fails, the remaining node will have to carry all...

sqldba_icon (6/1/2011)

---

I have a huge database with the below three options ON. I am not sure if i should be having all these three set to ON.

i) AUTO UPDATE STATS...

1) not sure if it is required when migrating from 2005 to 2008+, but for earlier upgrades one MUST update ALL statistics with FULL_SCAN. maybe you can try that.

2)...

Go here and drop down the Publish Date list and get a copy of the March SolidQ Journal. Read Itzik Ben-Gan's Packing Intervals article. STUNNINGLY efficient solution for...

Sorry, but I still don't see anything you need help on.

Danzz (5/26/2011)

---

we are facing performance issues.

system functions mainly as an OLAP/reporting environment, I mean like it is onlt read only server.

Configuration is

SQL servers 2005 Ent Edition (64-bit)

Total Physical...

ckingtaylor (5/25/2011)

---

I have a similar question.

I told the OS admin that tempdb needs to be off C: with the bins and put on a separate drive. I also recommended...

What do you need help on? The G drive, per your metrics, is significantly slower than the F drive, right?

Note that SQLIO is a much better tool...

Create appropriate indexes.

I note that my answer isn't any more useful than your completely open-ended question.