Help, doesn't ANYONE have something to say about my question?

I need to solve this.

Leo

Besides the deadloc trace image, you also need to supply the rest of the deadlock information. One way of doing this is by enabeling the Trace Flag 1204. This will...

Are the CPUs Hyper Threaded?

First off I'd almost never run SQL Server 2005 on a single processor core, which is what I assume you are doing. Your per-processor licence (which...

Yes, I can see ALL my posts here, but I don't need that, besides I have to wade through them to find the chains I started, and I have to...

You don't say what edition of SQL Server 2005 you are using, Standards or Enterprise.

Note that if you are using Standard Edition Lock Pages In Memory was only available from...

You need to understand what a snapshot does to know if it will do waht you want.

Taking a snapshot actually creates an empty database, with a view over the real...

dave.hobbs (7/13/2010)

---

Thanks for the reply Leo.

I hadn't considered A/A clusters before as we have always wanted some level of passive redundancy, but now I'm not sure that it is worth...

Sorry, ignore this point. I wasn't thinking...

Two things come to mind:

1) You are changing the...

Not quite a question for the SQL Admins, as it really applies to an application, and your application vendor should be able to answer this. It just so happens I've...

mohammed moinudheen (7/13/2010)

---

My doubt is if parallelism is set to 2 on the system, it would be used by all queries right as long there is no maxdop hint in...

That is true. Unfortunately there will still be a UDP 1434 still read with every SQL install. With the named instances, you achieve Obfuscation of your instances but...

..so can we ignore this kind of blocking?

Is there any script to continuously run as a SQL Agent job and capture the blocking and send an email when it finds...

CirquedeSQLeil (7/12/2010)

---

The servers will continue to show up despite disabling SQL Browser. SQL Browser does not control the default instance and thus an osql -L scan will still find...

The CXPacket block is caused by parallel processing. One thread in the process is waiting for another to complete, typically reads. What are the DISK performance counters like?

Some DBAs...