The tools available within SQL Server for monitoring the VM level stuff (memory, cpu, some disk counters depending on your VM) are pretty much non-existent. SQL Server and it's tools...

GilaMonster (8/5/2014)

---

Koen Verbeeck (8/5/2014)

---

GilaMonster (8/5/2014)

---

In that case, for 5+ years...

Are you getting deadlocks or are you getting blocks. I'm unclear based on the information.

But, no, the situation you're describing sounds quite abnormal. I'd need to see more about the...

I asked the same questions I asked someone with 2-3 years of experience. I just expected better answers. Also, when we get to the open-ended questions, I expect answers with...

So far as I know, the approved method is to check to see if the server is the primary. I'm sure you could write a PowerShell routine that cycles through...

The differences between Standard and Enterprise could be part of it. There are options within the optimizer that are different there. But, it probably comes back to the available memory...

homebrew01 (8/4/2014)

---

SQLRNNR (7/31/2014)

---

In both cases, you can upgrade from 2000. I might even restore the database onto the 2008R2 box and leave it in compat 80 for a few...

Some of the memory and CPU measurements within a VM become problematic. Again, I'd drill down to the specifics instead of using the average, but you might also want to...

You might just be seeing high PLE, but it could also be related to running on a NUMA architecture[/url]. Instead of just reading the average, get the specific values for...

Same query, but different data sets right? Which means radically different statistics? It helps explain why you might see differences in the plans selected. But, it all comes back to...

jcrawf02 (8/4/2014)

---

Jesus Grant, you throw this one to the OP like it's a "querying for dummies" book or something, and while I cannot disagree that reading it would give you...

MuhammadShafiq (8/4/2014)

---

Grant Fritchey (8/4/2014)

---

You're describing the WHERE clause of a query. You can combine different criteria in the WHERE clause using AND/OR logic to arrive at filtered record sets. There's...

You're describing the WHERE clause of a query. You can combine different criteria in the WHERE clause using AND/OR logic to arrive at filtered record sets. There's nothing you must...

raj.prabhu001 (8/3/2014)

---

Hello,

I have a fact table which has six field now and I have created non clustered index on all fields.

It will also have more fields later with millions of...

Better still, don't use trace and start using extended events. You're running 2012, so the excuse of not having a GUI has been eliminated.