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.

Given your lack of knowledge and experience on SQL Server, if you want this process to run efficiently you will need to get some mentoring on board to help you...

1) the advise to make tempdb files equal to CPU cores is overblown. virtually no one out there has sufficient IO throughput to feed up 8, 16, 32, 64,...