Jack Corbett (8/30/2011)

---

Hmm, interesting. Since I can't duplicate this I have no idea why it would be blank. The source for sysprocesses and sys.dm_exec_sessions are different so the...

Here is a script that cycles though all databases running the DMV query on each one separately and storing the results into a temp table for final retrieval;

this is the...

Sure, here it is:

--"Performance Tuning with SQL Server Dynamic Management...

Good idea, I'll try it both ways...

Only way I can think of is to loop through all databases in the SQL instance and issue the sys.dm_tran_locks query filtering by resource_database_id.

Store the intermediate results in a temp...

So is there a way...

Thanks, your suggestion is working.

Still getting NULLs, but not as many as before:

SELECT

DTL.[resource_type] AS [resource type] ,

...

What error are you getting?

I have always done this within stored procedures, not views.

Is there a reason you are using a view instead of a sproc to do this?

I still haven't figured this out; any ideas anyone?

Here is a link that describes how I am doing this through SQL Profiler UI:

http://msdn.microsoft.com/en-us/library/ms179321(v=SQL.100).aspx

However, when I attempt to save it as...

GilaMonster (8/22/2011)

---

I never said that it doesn't matter.

I said that just because Microsoft recommends something does not mean that you must go out and do it. (There have been very...

GilaMonster (8/21/2011)

---

When most of my queries use covering indexes

When my data is in cache already (which hopefully is most of the time)

When a query is only using the clustered indexes...

No, trace flag 2861 is not enabled.

Also, these are not 0-cost plans. For example, I'm getting the issue for XML that is 12,002 lines long from start to finish.

I'm also...

GilaMonster (8/20/2011)

---

Marios Philippopoulos (8/20/2011)

---

Jeffrey Williams-493691 (8/20/2011)

---

Yes - definitely need more input, and I wasn't assuming SAN or DAS...

I see this a lot, and the assumption by the person is that...

awu (8/17/2011)

---

Thanks Jason, but I am still puzzling over something here, if you right , it's 8, then i can set : max degree of...

Odd indeed...

Db is on 100 comp...