We could use the other server plan (as Gail asked for already).

Without that I am going to guess:

a) production memory is being used much more heavily and their...

ESAT ERKEC (11/27/2012)

---

My Sql Server Buffer I/O wait is very high

I have 390 GB RAM

I set the sql server min 300 gb max 350 gb

what is the reason can...

In addition to what GSquared said I would also check to see if TCP Chimney was enabled. This is a not-good thing for SQL Server boxes.

This should be done with a properly coded trigger.

This is often because the non-read-uncommitted SELECT is blocked by INSERT/UPDATE/DELETE operations currently ongoing. You can use sp_whoisactive (an awesome free tool on sqlblog.com) to observe this behavior if...

Nikhi123 (11/20/2012)

---

Hi,

I have a number of stored procedures used for reporting and whenever we run these reports it slows down the entire database.

Will optimizing the stored procedures improve the performance...

You have a lot of VERY complex statements there (which actually don't make sense to me) and LOTS of missing information like query plans, complete table/index definitions, etc. This...

I would like to add to this thread that the number of clients I have had in 15 years of consulting that actually had tempdb allocation issues is TWO, and...

Hopefully you can afford to have database servers that take hours to return answers to queries....

As Gail has said several times you aren't giving us much to go on.

First thing to try is spreading out the SSIS activity so fewer things are running...

I think with so few spindles carving them up into smaller sets just sets yourself up for one or more of those smaller groups to be a bottleneck. I...

You could hunt-and-peck on this forum for days or weeks for a problem such as this (and I have seen that happen any number of times) and never find a...

Perhaps your tlog is...

For best performance there is no "it depends" - go with bigint over uniqueidentifier. Actually, in this case you could almost certainly get away with an int, which is...

I happen to know one of the best!...