Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,518 total)

  • RE: Query to give reports currently running on report server

    eccentricDBA (9/6/2011)

    Try dbo.RunningJobs

    Thanks, but won't this only give me reports running as subscriptions?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 6, 2011 at 2:16 pm

    #1377677

  • RE: Blocking on ReportServer, ReportServerTempdb databases

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 6, 2011 at 1:30 pm

    #1377660

  • RE: Getting NULL for Object Name when trying to decode sys.dm_tran_locks.resource_associated_entity_id

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 1, 2011 at 8:49 am

    #1376006

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    JKG (8/31/2011)

    Great article - very helpful!!!

    Thank you 🙂

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 1, 2011 at 8:02 am

    #1375970

  • RE: wait_type and last_wait_type in sys.dm_exec_requests - differences and NULL values

    Ignacio A. Salom Rangel (8/31/2011)

    Marios Philippopoulos (8/31/2011)

    Ignacio A. Salom Rangel (8/31/2011)

    Marios Philippopoulos (8/31/2011)

    (1) I don't quite understand the meaning the 2 wait types; as I mention, the BOL definition is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 5:00 pm

    #1375761

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    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 =...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 3:31 pm

    #1375740

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 3:18 pm

    #1375736

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    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:...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 3:06 pm

    #1375730

  • RE: wait_type and last_wait_type in sys.dm_exec_requests - differences and NULL values

    Ignacio A. Salom Rangel (8/31/2011)

    Marios Philippopoulos (8/31/2011)

    (1) I don't quite understand the meaning the 2 wait types; as I mention, the BOL definition is not very informative.

    What is the distinction...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 2:44 pm

    #1375719

  • RE: wait_type and last_wait_type in sys.dm_exec_requests - differences and NULL values

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 9:31 am

    #1375556

  • RE: Getting NULL for Object Name when trying to decode sys.dm_tran_locks.resource_associated_entity_id

    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.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 8:36 am

    #1375520

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 8:23 am

    #1375509

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 8:09 am

    #1375494

  • RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

    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",...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 8:01 am

    #1375492

  • RE: Trying to find long-running jobs from dm_exec_requests, dm_exec_sessions and sysjobhistory - what a pain!

    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...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 31, 2011 at 7:21 am

    #1375454

Viewing 15 posts - 211 through 225 (of 1,518 total)