Viewing 15 posts - 211 through 225 (of 1,518 total)
eccentricDBA (9/6/2011)
Try dbo.RunningJobs
Thanks, but won't this only give me reports running as subscriptions?
September 6, 2011 at 2:16 pm
GSquared (9/6/2011)
Have you run a trace to see what the commands are?Have you thought about setting the default isolation level to READ_COMMITTED_SNAPSHOT? (Data here: http://msdn.microsoft.com/en-us/library/ms173763.aspx)
READ_COMMITTED_SNAPSHOT sounds like a...
September 6, 2011 at 1:30 pm
Marios Philippopoulos (8/29/2011)
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;...
The...
September 1, 2011 at 8:49 am
JKG (8/31/2011)
Great article - very helpful!!!
Thank you 🙂
September 1, 2011 at 8:02 am
Ignacio A. Salom Rangel (8/31/2011)
Marios Philippopoulos (8/31/2011)
Ignacio A. Salom Rangel (8/31/2011)
Marios Philippopoulos (8/31/2011)
August 31, 2011 at 5:00 pm
Here is another case of login name showing up as blank (not from EntityFramework).
2 records returned with:
same session_id (=163)
same request_id (=1)
status='running'
login_name BLANK
original_login_name = 'some value'
program_name = 'Microsoft SQL Server'
wait_type =...
August 31, 2011 at 3:31 pm
Adam Machanic (8/31/2011)
Marios Philippopoulos (8/31/2011)
I noticed that there are 3 threads for that session: 3 records returned. Why would that be?
3 threads? You're not joining to any views that deal...
August 31, 2011 at 3:18 pm
I just did a quick check.
There is a session running EntityFramework, and the original_login_name is populated (not NULL); login_name is blank.
I noticed that there are 3 threads for that session:...
August 31, 2011 at 3:06 pm
Ignacio A. Salom Rangel (8/31/2011)
Marios Philippopoulos (8/31/2011)
What is the distinction...
August 31, 2011 at 2:44 pm
OK, perhaps we can disregard my second question; since I am doing a left join on sys.dm_exec_requests, I am bound to get NULLS for both columns for sessions that are...
August 31, 2011 at 9:31 am
Aiello DBA (8/31/2011)
here I wrote an article about that: http://aiellodba.blogspot.com/2011/08/entendiendo-el-waitresource.html
Thanks, I'll take a look.
August 31, 2011 at 8:36 am
Jack Corbett (8/31/2011)
Marios Philippopoulos (8/31/2011)
Jack Corbett (8/31/2011)
Posted this on Twitter and got an interesting question. Are you seeing this happen with a specific application like Access?
I get it for...
August 31, 2011 at 8:23 am
Adam Machanic (8/31/2011)
What do you get from the original_login_name column? And what does "blank" mean? NULL? Or an empty string?
I get empty string.
I will add the original_login_name column in the...
August 31, 2011 at 8:09 am
Jack Corbett (8/31/2011)
Posted this on Twitter and got an interesting question. Are you seeing this happen with a specific application like Access?
I get it for something called "Entity Framework",...
August 31, 2011 at 8:01 am
colin.Leversuch-Roberts (8/31/2011)
oh yes the "times" - back in sql 2000 I wrote some functions which convert the times into something usable.
Thanks for sharing. By threshold I mean a certain...
August 31, 2011 at 7:21 am
Viewing 15 posts - 211 through 225 (of 1,518 total)