GilaMonster (4/14/2011)

---

fname lname-1111520 (4/14/2011)

---

"then" and "there's"... I didn't find it incoherent. I claimed "it can't be coherent". If I were reviewing resumes, you go in the Engrish...

There's...

Don't you have to turn your...

ChrisM@home (4/13/2011)

---

Grant Fritchey (4/13/2011)

---

ChrisM@home (4/13/2011)

---

varun.dubey29 (4/13/2011)

---

That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the...

Timothy Straub (4/13/2011)

---

Grant -

Thanks for the info and yes I am testing the performance of a query. I was hoping to be able to test a separate DB...

Hard one to answer. Unless there was a...

Stack overflow is pretty good too.

It's going after the instance. Why would you do that?

I mean, for testing purposes, fine, but I wouldn't suggest running that in production.

After the fact, when everything is done, without a trace file available? You can't. If you have a trace running, you can use that to get the user (assuming you're...

Patrick_Fiedler (4/13/2011)

---

That's true, this would be also an indicator. Thanks Craig.

You can take the following statement:

selectcntr_value as [PageLifeExpectancyInSeconds]

fromsys.dm_os_performance_counters

whereobject_name like '%:Buffer Manager%'

and counter_name like 'Page life expectancy%'

If the value falls below...

ChrisM@home (4/13/2011)

---

varun.dubey29 (4/13/2011)

---

That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the one in the...

First thing I'd do is bump the cost threshold for parallelism up to a much higher number. The default of 5 is ridiculously low. Start at 30 and then adjust...

On first glance, it looks like you're swapping stuff out of memory a lot. I'd focus where I usually find myself focusing, the queries. Use a server-side trace to get...

I left a company that split the duties between development and administration. Further, administration was split between operations and systems. The systems guys literally built servers, clusters, virtuals, and managed...

If you didn't get errors when you created the index, it's there, and "kicked in." Now, whether or not it's getting used, well, there's used and there's used. As was...